http://www.sqlservercentral.com/blogs/chuckboycejr/2012/11/12/dr-sql-installed-on-new-path-master-restored-and-sql-cant-find-resource-database-or-start-jobs/

Printed 2014/07/29 11:00PM

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

By chuckboycejr, 2012/11/12

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


Copyright © 2002-2014 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.