Tuesday, June 03, 2008

FAQ: How to see what is inside hidden SQL Server 2005 Resource Database (mssqlsystemresource) ?

We all know the master database in SQL Server 2000 was split into two databases in SQL Server 2005. One kept as Master only and the other database is Resource database which is hidden. You can’t see that in Management studio or in any tool. You can see the physical files in Data ( default )folder. The idea behind this separation of objects is to allow very fast and safe upgrades.

If you want to see what is inside this database follow these steps

(a) Stop SQL Server
(b) Copy /paste mssqlsystemresource mdf and ldf files to a new location
(c) Create a new database by Attaching the files from the new location

Now you have the hidden database right in front….

posted by Madhu K Nair at 7:04 AM

2 Comments:

Anonymous Anonymous said...

Your pouches will degrade after time, so you will have to repair them every once in a
while in the abyss. Try and keep all of your tools and items organized
in a neat way. Gold is a platinum widely adorned and also highly valued globally.


Here is my website; mining

6:26 PM  
Anonymous Anonymous said...

Yeast infection cannot be eliminated if only treated with a one-dimensional
treatment like antibiotics, creams, pills, or detox diets.
As someone who believes in natural healing methods more than the traditional medicine which has its own side effects,
I liked the fact that she focuses on natural methods of healing from yeast infection.
licitations with regards to making ones cachet that is most certainly Talbots at present.
, one of the chiropractors in Fayetteville, is pleased to announce the implementation of
programs for natural detoxification therapy. o -
Focus on the optometry practice (no ambition to supply a retail eyewear answer).


Look into my web page - interesting movie trivia

7:45 PM  

Post a Comment

Subscribe to Post Comments [Atom]

<< Home