Moving 2005 Resource Database

We have a sql 2005 installation that has service pack 2 applied. All
the system databases apart from the resource database have been moved
from the default data directory to our own data directory on a
seperate drive and this went ok. We've done this basically to make the
back up process more efficient in our environment. The issue is that
we cant find a way to move the resource database to the new location
and this I beleive needs to be kept with the master database. We've
followed the BOL instructions for moving system databases but the
Alter script for the resource database fails as the resource database
doesnt exist in sysdatabases. I've tried simply moving the resource
files to the new location but then sql wont start as it cant find the
files.
Anybody have any ideas how to resolve this issue?
Thanks
MichaelThe instructions in Books Online for moving the master and resource database
files should work. However, we made some corrections to the procedure in
April 2006. If you don't have the latest version of Books Online, you might
be running into a problem.
I suggest that you download the latest version fo BOL (see the link in my
signature) and then starting with step 7 (Start the instance of SQL Server
in master-only recovery mode...), see if you can get the resource database
moved. If you still run into trouble, please report the exact error
message you're getting.
Regards,
Gail
--
Gail Erickson [MS]
SQL Server Documentation Team
This posting is provided "AS IS" with no warranties, and confers no rights
Download the latest version of Books Online from
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
"Michael" <michael@.hampel.fsnet.co.uk> wrote in message
news:1183985960.779841.257510@.k79g2000hse.googlegroups.com...
> We have a sql 2005 installation that has service pack 2 applied. All
> the system databases apart from the resource database have been moved
> from the default data directory to our own data directory on a
> seperate drive and this went ok. We've done this basically to make the
> back up process more efficient in our environment. The issue is that
> we cant find a way to move the resource database to the new location
> and this I beleive needs to be kept with the master database. We've
> followed the BOL instructions for moving system databases but the
> Alter script for the resource database fails as the resource database
> doesnt exist in sysdatabases. I've tried simply moving the resource
> files to the new location but then sql wont start as it cant find the
> files.
> Anybody have any ideas how to resolve this issue?
> Thanks
> Michael
>sql