SQL Server Performance Forum – Threads Archive

.bak database files

I’d like to know how can I do to restore database files with .BAK extension using SQL Server 2000 Enterprise Edition, cause I tried using DTS and ‘restore from disk’ command and nothing happened. I’d really appreciate it if someone can help me out with this issue. Thanks.

You’re risking the backup file with a corruption, refer to the SQL Server books online for RESTORE statement topic. In order to restore the required file use as per BOL examples USE master
GO
— First determine the number and names of the files in the backup.
RESTORE FILELISTONLY
FROM MyNwind_1
— Restore the files for MyNwind.
RESTORE DATABASE MyNwind
FROM MyNwind_1
WITH NORECOVERY,
MOVE ‘MyNwind_data_1’ TO ‘D:MyDataMyNwind_data_1.mdf’,
MOVE ‘MyNwind_data_2’ TO ‘D:MyDataMyNwind_data_2.ndf’
GO
Satya SKJ
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

The right way to restore is what Satya said.
If you want to use Enterprise Manager: Expand Databases, right click, all task, restore and follow the instructions.
Luis Martin
Moderator
SQL-Server-Performance.com One of the symptoms of an approaching nervous breakdown is the belief that one’s work is terribly important
Bertrand Russell
All postings are provided â€œAS ISâ€ with no warranties for accuracy.

]]>