SQL Server Performance Forum – Threads Archive
.bak database filesI’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
— First determine the number and names of the files in the backup.
— Restore the files for MyNwind.
RESTORE DATABASE MyNwind
MOVE ‘MyNwind_data_1’ TO ‘D:MyDataMyNwind_data_1.mdf’,
MOVE ‘MyNwind_data_2’ TO ‘D:MyDataMyNwind_data_2.ndf’
Contributing Editor & Forums Moderator
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.
SQL-Server-Performance.com One of the symptoms of an approaching nervous breakdown is the belief that one’s work is terribly important
All postings are provided â€œAS ISâ€ with no warranties for accuracy.