Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
dalim.ghosh
Starting Member
11 Posts |
 Posted - 2009-11-14 : 02:46:27
|
| How to take backup of resource db in sql server 2005 |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2009-11-14 : 08:51:17
|
In SSMS right click on database and you will see...More detailed information is available here:http://msdn.microsoft.com/en-us/library/ms186865(SQL.90).aspx
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2009-11-14 : 09:22:26
|
| This link is a little better (I thinkk fred missed the "resource database" part of the question perhaps): http://msdn.microsoft.com/en-us/library/ms190940.aspxBacking Up and Restoring the Resource Database SQL Server cannot back up the Resource database. You can perform your own file-based or a disk-based backup by treating the mssqlsystemresource.mdf file as if it were a binary (.EXE) file, rather than a database file, but you cannot use SQL Server to restore your backups. Restoring a backup copy of mssqlsystemresource.mdf can only be done manually, and you must be careful not to overwrite the current Resource database with an out-of-date or potentially insecure version. |
|
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2009-11-14 : 09:29:33
|
Yes I missed that.Thank you!
No, you're never too old to Yak'n'Roll if you're too young to die. |
|
|
|
|
|
|
Backup