Restore Systems Databases All at once

Question

Post reply

Restore Systems Databases All at once

j mangual

Ten Centuries

Points: 1197
More actions
May 18, 2006 at 10:09 am

#113031

We are testing the following recovery scenario: SQL Server crashed, no clustering nor standby servers are available. The instances of the crashed server will be restored on a new server that have SQL installed with other named instances.
We successfully rebuilded the master from the backup file while on single mode. When db restart it complains that can't open files for the other databases. We use the restore with move option command to restore the db on new server/new instance.
Do we have to recreate the directory structure from the old server in order to restore? How can we restore all databases from backup files into new environment?
Thanks for all suggestions.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

R2ro Default port Points: 1439 More actions · Answer 1

Just as you did with the system db's. RESTORE ... WITH MOVE...

You may place the user database files wherever the new server configuration allows.

j mangual Ten Centuries Points: 1197 More actions · Answer 2

From the error log, after restoring master SQL tries to start up and it can't. See messages:

Starting up database 'master'.

1 transactions rolled back in database 'master' (1).

Recovery is checkpointing database 'master' (1)

Using 'SSNETLIB.DLL' version '8.0.766'.

Starting up database 'model'.

udopen: Operating system error 2(The system cannot find the file specified.) during the creation/opening of physical device E:\Microsoft SQL Server\MSSQL\MSSQL$TAPPWASD\data\model.mdf.

FCB:pen failed: Could not open device E:\Microsoft SQL Server\MSSQL\MSSQL$TAPPWASD\data\model.mdf for virtual device number (VDN) 1.

Device activation error. The physical file name 'E:\Microsoft SQL Server\MSSQL\MSSQL$TAPPWASD\data\model.mdf' may be incorrect.

Database 'model' cannot be opened due to inaccessible files or insufficient memory or disk space.

crashed server directory structure was: E:\Microsoft SQL Server\MSSQL\MSSQL$TAPPWASD\data\

new server is 'E:\Microsoft SQL Server\MSSQL\MSSQL$TAPPWASD\data\

R2ro Default port Points: 1439 More actions · Answer 3

I misunderstood... I thought you had successfully restored the system db's and were trying to get the user db's restored.

I noticed that you posted in the http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=24&messageid=202168 thread. That info should help you get the appropriate directions.

j mangual Ten Centuries Points: 1197 More actions · Answer 4

Hopefully, however thread is referring to two file *.cmd containing system variables that I can't understand. Seems that I missing a big key in this puzzle....