February 1, 2005 at 2:07 pm
I am using SQL Server 2000, both Enterprise and Standard SP3a.
To make restores at the DR site easier, and not to have to run special scripts for the SQL databases (20+ prodcution systems), I want to restore the master database. Here is my current scenerio:
1) New install of SQL Server
2) Restore user databases only
3) Run scripts for user/logins and special security per system
4) Run scripts to create the jobs.
5) Done.
New way:
1) New install of SQL Server
2) Restore user databases master database and msdb
3) Restore user databases
4) Done.
Problem:
The master database might not have the have the same path. I have hit many errors stating the "cannot find files". Also, the user database need to have the same paths or master "cannot find files".
Any one know how to restore master to a different path?
How to get around the master database being restore with out the user databases? Or the user databases in a different location?
I have restored the master database from a backup device, with the same directory path. Also the user databases had to be in the same path and name.
Thanks,
Joseph Devereaux
February 1, 2005 at 3:16 pm
This might help... http://support.microsoft.com/kb/304692/EN-US/
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
February 8, 2005 at 7:08 am
Thank you. The article and related articles did help. Not as easy and clean as I would like, but the process works.
Joseph
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply