July 7, 2005 at 6:47 am
Hi,
I have a client who is upgrading their production server and needs to run SQL on a different drive (C:\ drive on the new server, SQL is currently running on the E:\ drive on the old server). They have installed SQL onto the new server and contacted us when they ran into problems. Basically when we restore the master database onto the new server, SQL will not re-start. I'm restoreing through EM in single user mode, and specifying the new location of the data and log files on the options tab.
We can get all the other databases restored and ideally I want to avoid having to set up all the logins on the new server.
Has anyone else tried to restore a master backup to a new location?
cheers
Dave
July 7, 2005 at 12:22 pm
Just look at here
http://www.databasejournal.com/features/mssql/article.php/3379901
Thanks
Amish Shah
July 8, 2005 at 12:19 am
Hiyas
This is my favourite article from MS
http://support.microsoft.com/default.aspx?scid=kb;en-us;224071
You can modify the parameters in the registry, before starting up the SQL Server service. This can be used if you manually copy the master files from one location to another.
HKLM\Software\Microsoft\MSSQLServer\MSSQLServer\Parameters
This is not really recommended.
Regards
hot2use
__________________________________
Searching the KB articles is like
picking your nose. You never know
what you'll find.
July 8, 2005 at 3:43 am
Amish / hot2use,
Thanks for your suggestions.
cheers
Dave
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply