January 22, 2010 at 7:43 am
Hello, old db server died, only database backups are available. Mdf and Ldf files are gone.
Is there a way to restore these databases on new server from backup only? Data loss is not essential.
thank you for the help.
January 22, 2010 at 1:46 pm
Yes it is possible. This is one of the main reason why you take a back up. If your server dies and you have back up, you just have to restore the back up.
Check in Books On Line the command RESTORE DATABASE
-Roy
January 22, 2010 at 8:05 pm
Hi Roy, thank you for our reply. I know why I take the backup. My plan as I think it should be, is like this: on a new server do restore files only to get logical names of the files. Create a new database. Then do a restore from backup of my old database with move of logical file names to new location. want to try it when new server is available.
January 23, 2010 at 12:45 pm
L_avital (1/22/2010)
Hi Roy, thank you for our reply. I know why I take the backup. My plan as I think it should be, is like this: on a new server do restore files only to get logical names of the files. Create a new database. Then do a restore from backup of my old database with move of logical file names to new location. want to try it when new server is available.
That is a lot of extra work that is not necessary at all. When you restore a database from a backup it creates the mdf/ldf files that are needed for that database. Creating a new database, then using the move option just overwrites the existing files.
You can test this yourself by creating a new database, add multiple data files - then restore with the move option with a database that has a single mdf. The previous ndf files will no longer exist.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply