October 22, 2003 at 9:46 am
We recently had to restore a complete server to different hardware. When we attempted to restore SQL Server we discovered that the master db was missing. We installed a master db from the SQL Server CD. When we attempted to bring up SQL server it came up with error 1 - something to do with collation sequence and or path being wrong and could not bring up the server.
Are there special procedures to complete in this kind of disaster situation - when recovering an entire server?
Should the master db be backup separately?
What would cause the path error?
Thank you.
October 22, 2003 at 9:54 am
We recently migrated SQL 7 from machine A to machine B. We installed SQL Server on B, created the directory structure to mirror A, then did a complete backup of A, getting all MDB and LDF files. We turned off the SQL Server and SQL Agent services, restored to machine B overwriting the default MASTER, re-booted (which automatically started the services) and it worked well for us.
RBR
October 23, 2003 at 8:39 am
Thanks for the response. One question though: was the backup you did a cold backup (after shutting down SQL Server on machine A)?
I suspect that the trouble we were having might be related to trying to back up the open files. Perhaps backing up the master database while SQL Server is up is asking for trouble.
October 23, 2003 at 10:41 am
If you still have access to the original server you can do a Sql Backup or if the Sql install is hosed you can do an OS file copy (after ensuring the MSSqlServer service is off). Either one should work.
Richard L. Dawson
Sql Server Support Engineer
ICQ# 867490
Richard L. Dawson
Microsoft Sql Server DBA/Data Architect
I can like a person. People are arrogant, ignorant, idiotic, irritating and mostly just plain annoying.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply