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 |
|
NJDba
Starting Member
31 Posts |
 Posted - 2008-01-21 : 15:00:37
|
| I found out our system backup system database every week, which occupy a lot of space. Is it necessary?Thank you. |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-01-21 : 15:12:14
|
| Yes since they store all server level data like logins, jobs and so. By the way, system dbs usually are smell and should take much space. |
 |
|
|
CShaw
Yak Posting Veteran
65 Posts |
Posted - 2008-01-22 : 00:50:09
|
| Yes you should back up your system databases. The only system database that you do not need to back up is the Temp DB. That database gets re-created every time the SQL Server Service gets re-started.Chris Shawwww.SQLonCall.com |
|
|
|
|
|
|
Do we need to backup system database?