[srbatcha]

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

[motcom]

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...

[pipjt]

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