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 |
|
bpsintl
Posting Yak Master
132 Posts |
 Posted - 2009-03-17 : 14:30:43
|
| I'm using SQL 2008 Express and have a couple of databases on it.I am backing up the databases via a 3rd party app and was wondering if I also need to backup the system db's eg master etc?If yes, why? What is the reason for backing these up as well? |
|
|
mfemenel
Professor Frink
1421 Posts |
Posted - 2009-03-17 : 15:24:48
|
| MSDB has all of your sql agent configuration and job information code. SQL Server wont' start or do much of anything without Master so those two are must have's and I would definitely back them up. Frequency depends on how much you're making server level or job level changes. Model isn't necessary. Model is the "model" that is used when you create a new database. You could get away with backing it up once and you're done with it.Mike"oh, that monkey is going to pay" |
 |
|
|
bpsintl
Posting Yak Master
132 Posts |
Posted - 2009-03-17 : 15:48:49
|
| I thought sql 2008 express doesn't have any agent config etc because it's disabled isn't it? |
|
|
|
mfemenel
Professor Frink
1421 Posts |
Posted - 2009-03-17 : 16:01:28
|
| I believe you're right about that part.Mike"oh, that monkey is going to pay" |
|
|
|
bpsintl
Posting Yak Master
132 Posts |
Posted - 2009-03-17 : 16:08:19
|
| Can Master and or MSDB ever get corrupt then and need restoring from a backup? |
|
|
|
mfemenel
Professor Frink
1421 Posts |
Posted - 2009-03-17 : 16:47:10
|
| Yes it certainly is possible. Disk drives fail and do strange things. Master and MSDB are still subject to drive problems, consistency issues and torn pages. All good reasons to back them up. Maybe just once but definitely worth backing up.Mike"oh, that monkey is going to pay" |
|
|
|
bpsintl
Posting Yak Master
132 Posts |
Posted - 2009-03-18 : 05:00:29
|
| Thanks |
|
|
|
|
|
|
Backups