2 Replies - 633 Views - Last Post: 06 June 2010 - 06:40 AM Rate Topic: -----

#1 srbatcha  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 17
  • Joined: 20-March 09

SQL SERVER 2000 DATABASE

Posted 24 May 2010 - 03:35 AM

hello everybody


i have two database files (.bak file format) like
1.budget_log.bak
2.budget.bak
D:\ drive in my system.

How can i add in my sql server 2000 database as a new database.

please explain

Advance Thanks

sathik
Is This A Good Question/Topic? 0
  • +

Replies To: SQL SERVER 2000 DATABASE

#2 motcom  Icon User is offline

  • D.I.C Lover
  • member icon

Reputation: 290
  • View blog
  • Posts: 1,371
  • Joined: 16-June 08

Re: SQL SERVER 2000 DATABASE

Posted 24 May 2010 - 06:07 AM

Hi,

It seems like they are backup files. If yes, you have to create a new database and restore the backup files onto the new database...
Was This Post Helpful? 0
  • +
  • -

#3 pipjt  Icon User is offline

  • New D.I.C Head
  • member icon

Reputation: 2
  • View blog
  • Posts: 11
  • Joined: 19-November 08

Re: SQL SERVER 2000 DATABASE

Posted 06 June 2010 - 06:40 AM

Hi

If you login to SQL Server Enterprise Manager/Management Studio and right click on the Databases tree node you will be able to select the restore option, specify restore from disk and select the .bak files, then its just a case of specifying the DB name and starting the task. This can all be done from the wizard.

The only real issue that you may encounter is that any custom users stored in the database may need to be recreated or remapped to the new SQL Server instance.

Cheers

Phil
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1