Attach resource database

Question

Attach resource database

kladibeeto

SSCommitted

Points: 1582
More actions
April 7, 2010 at 6:27 am

#231475

Hi all,
Does anybody know how to attach resource database on SQL SERVER 2008?
I tried on the same way like in SQL SERVER 2005 but that doesn't work on anymore.
I think on sigle user (add startup parameter -m) and normal attach (I got massage that I can't attach resource database?)
I also tried to change name with hexa editor but that also didn't help.
Regards,

Viewing 11 posts - 1 through 10 (of 10 total)

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

ps. One Orange Chip Points: 29422 More actions · Answer 1

AFAIK, resource database is a read only database containing system objects that cannot be attached and used as a user database. Never tried attaching it though..

Pradeep Singh

george sibbald SSC Guru Points: 104210 More actions · Answer 2

What are you trying to do? You should not need to touch this database in SQL2008, and certainly don't rename it.

---------------------------------------------------------------------

kladibeeto SSCommitted Points: 1582 More actions · Answer 3

Of course that I don't touch orginal resource DB 🙂

Right now it is not important what I am trying to do.

george sibbald SSC Guru Points: 104210 More actions · Answer 4

kladibeeto (4/7/2010)
Of course that I don't touch orginal resource DB 🙂
Right now it is not important what I am trying to do.

sounds top secret. I'll leave you to it.

---------------------------------------------------------------------

kladibeeto SSCommitted Points: 1582 More actions · Answer 5

Sorry, don't be angry to me.

I am preparing course and I wan't to be sure that Microsoft didn't change one thing in SQL SERVER 2008.

That is the reason why I need to see resource db like I see it in SQL 2005.

george sibbald SSC Guru Points: 104210 More actions · Answer 6

I'm not angry. Just difficult to give correct information if I'm not sure what you are trying to achieve and you won't tell me.

Have you tried copying resource files somewhere else, renaming them and attaching as a user database?.

Not that I advocate this as a good thing to do.

can you use sp_help, sp_helptext, information_schema to check out changes without going to these lengths?

---------------------------------------------------------------------

kladibeeto SSCommitted Points: 1582 More actions · Answer 7

I understand you.

Yes I tried to rename db, I also tried to rename it with hexa editor.

It seems that Microsoft put some flag and that is the solution how they know that this is resource db.

george sibbald SSC Guru Points: 104210 More actions · Answer 8

they have gone to great lenghts to protect it, basically they don't want people touching it, which is fair enough.

---------------------------------------------------------------------

kladibeeto SSCommitted Points: 1582 More actions · Answer 9

kladibeeto

SSCommitted

Points: 1582

April 7, 2010 at 8:30 am

#1147374

Unfortunely I must agree with you 🙁

SQLRNNR SSC Guru Points: 281334 More actions · Answer 10

george sibbald (4/7/2010)
they have gone to great lenghts to protect it, basically they don't want people touching it, which is fair enough.

I agree with George here. This is one of those things that one should not touch.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events