Moving the Resource Database

Question

Post reply

Moving the Resource Database

Junior Galvão - MVP

SSCertifiable

Points: 6951
More actions
December 1, 2015 at 10:39 pm

#313571

Comments posted to this topic are about the item Moving the Resource Database
December 1, 2015 at 10:43 pm

This was removed by the editor as SPAM
December 2, 2015 at 5:45 am

This was removed by the editor as SPAM

Viewing 15 posts - 1 through 15 (of 30 total)

You must be logged in to reply to this topic. Login to reply

HappyGeek SSCoach Points: 18729 More actions · Answer 1

Nice question thank you, I did learn something new.

...

Carlo Romagnano SSC-Insane Points: 22680 More actions · Answer 2

Here's a method to move resource database:

http://www.sqlnotes.info/2012/01/06/new-way-to-relocate-resource-database/[/url]

I never tested it, but, it seems to work.

Junior Galvão - MVP SSCertifiable Points: 6951 More actions · Answer 3

Junior Galvão - MVP

SSCertifiable

Points: 6951

December 2, 2015 at 2:31 am

#1843432

Thanks.

Junior Galvão - MVP SSCertifiable Points: 6951 More actions · Answer 4

Hi Carlos,

Thanks for post and comments, I do not know this form you posted.

John Mitchell-245523 SSC Guru Points: 148809 More actions · Answer 5

Mmmm, interesting. The documentation does say unequivocally that the database can't be moved. I've moved it in the past, though. Maybe it ought to say instead that moving the resource database isn't supported?

John

Hany Helmy SSChampion Points: 13921 More actions · Answer 6

I remember 1 situation in the past where the Resource system db was lost for 1 of our testing environments, then I had 2 copy it from another instance in order 2 fix that situation & it worked just fine 🙂

Thanks & Best Regards,
Hany Helmy
SQL Server Database Consultant

Scott-144766 SSCarpal Tunnel Points: 4333 More actions · Answer 7

Scott-144766

SSCarpal Tunnel

Points: 4333

December 2, 2015 at 4:14 am

#1843453

You could move it in SQL 2005

--
Scott

tom.w.brannon Hall of Fame Points: 3976 More actions · Answer 8

I don't deal with this level of the db but it seems like a trick question. At https://msdn.microsoft.com/en-us/library/ms190940.aspx it states 'These files are located in <drive>:\Program Files\Microsoft SQL Server\MSSQL<version>.<instance_name>\MSSQL\Binn\ and should not be moved'. 'Should not' is less restrictive than 'Cannot'. The specification that the drive is a variable would seem to indicate that different drives can be used. The name of the folder seems fixed for a database. I took the 'or' as if either is true then the whole thing is.