SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

DR: SQL installed on new path, master restored, and SQL can't find resource database or start jobs!?!

If you ever need to perform a DR install of SQL to a new path and then restore the system databases, you may encounter these gotchas.

I share these gems that google (and the authors) have wrought:

For SQL 2005 you may learn that the instance cannot find the resource database after you restore the master db. If that is the case, take two aspirin and read this blog post:

Moving the Resource Database in SQL Server 2005

read more


Some dude named Chuck.


Leave a comment on the original post [sql.chuckboycejr.com, opens in a new window]

Loading comments...