understand following concepts of resouce database:

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » understand following concepts of resouce...

14 posts, Page 2 of 2

««1 2

understand following concepts of resouce database:

Rate Topic

Display Mode

Topic Options

Author

Message

Steve Jones - SSC Editor

Posted Monday, January 25, 2010 7:48 AM

SSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 3:30 PM
Points: 31,436, Visits: 13,751

You can see which files are changed in the kb article for each SP/CU. You will see quite a few files have their sizes and versions updated.

Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help

Post #853010

andrewkane17

Posted Monday, January 25, 2010 2:48 PM

SSC-Addicted

Group: General Forum Members
Last Login: Yesterday @ 12:09 PM
Points: 414, Visits: 2,698

Just a quick question, related somewhat, if the mssqlsystemresource.mdf and mssqlsystemresource.ldf cannot be backed up by SQL and I am assuming as SQL has them open, while the service is running, it cannot be backed up to tape, isn't this a point of failure that cannot be easily be remedied whenever the mssqlsystemresource.mdf and mssqlsystemresource.ldf ever become corrupt?

Andrew

Post #853330

G.R.Prithiviraj Kulasingham

Posted Tuesday, January 26, 2010 1:35 AM

SSC-Addicted

Group: General Forum Members
Last Login: Sunday, October 21, 2012 8:59 PM
Points: 421, Visits: 362

The database serves as read only database and will not be written when SQL Server instance is running.

Like any other file backup, or registry backup, backup of these files too can help you in some extend, but will not help you in service pack upgrades.
This thread is mainly concentrating on the comments of the article.

Cheers,
Prithiviraj Kulasingham

http://preethiviraj.blogspot.com/

Post #853438

GilaMonster

Posted Tuesday, January 26, 2010 1:50 AM

SSC-Dedicated

Group: General Forum Members
Last Login: Yesterday @ 4:11 PM
Points: 37,741, Visits: 30,020

andrewkane17 (1/25/2010)

isn't this a point of failure that cannot be easily be remedied whenever the mssqlsystemresource.mdf and mssqlsystemresource.ldf ever become corrupt?

Yes, but since those only change when service packs/hotfixes are installed, you can just stop SQL as part of the SP installation and take file backups of them.

Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #853444

« Prev Topic | Next Topic »

14 posts, Page 2 of 2

««1 2

Permissions