| Author |
Topic |
|
mike123
Master Smack Fu Yak Hacker
1462 Posts |
 Posted - 2005-07-07 : 04:18:44
|
| I just discovered why my servers drive kept getting more and more full. I have 6 months of backup for the MSDB databaseIs it safe to remove the oldest 5 months? I just want to delete them, I am 99.9999% sure its ok but haven't done this before and don't want anything strange happening .. :)thanks!mike123 |
|
|
franco
Constraint Violating Yak Guru
255 Posts |
Posted - 2005-07-07 : 04:33:51
|
| If you don't need a backup of 6 month ago, then yes, you can delete these backups files.Franco |
 |
|
|
mike123
Master Smack Fu Yak Hacker
1462 Posts |
Posted - 2005-07-07 : 04:37:44
|
| thanks franco! .. i just wasnt sure because I dont know 100% of the purpose of the msdb ..mike123 |
|
|
|
franco
Constraint Violating Yak Guru
255 Posts |
Posted - 2005-07-07 : 04:39:19
|
| We are talking about backup of msdb, not msdb itself.MSDB is a system db and should not be deleted for any reason.Franco |
|
|
|
mike123
Master Smack Fu Yak Hacker
1462 Posts |
Posted - 2005-07-07 : 04:39:52
|
| the same rule applies for the PUBS DB ?thanks again!mike123 |
|
|
|
mike123
Master Smack Fu Yak Hacker
1462 Posts |
Posted - 2005-07-07 : 04:41:20
|
| yes sorry for confusion .... I am talking about the backups (.BAK) files located in the backup directory.I have no intention of dropping either database :)Thanks!Mike123 |
|
|
|
franco
Constraint Violating Yak Guru
255 Posts |
Posted - 2005-07-07 : 04:42:08
|
| From BOL:pubs Sample DatabaseThe pubs sample database is modeled after a book publishing company and is used to demonstrate many of the options available for a Microsoft® SQL Server™ database. The database and its tables are commonly used in the examples presented in the documentation content.If you have made changes to the pubs database, you can reinstall it using files located in the Install directory of your SQL Server installation. The installation process requires two steps: From the command prompt, use the osql utility to run the Instpubs.sql script. This drops the existing pubs database, creates a new one, and defines all the objects in the database.From the command prompt, run Pubimage.bat. This inserts image values into the pub_info table. Franco |
|
|
|
franco
Constraint Violating Yak Guru
255 Posts |
Posted - 2005-07-07 : 04:43:09
|
| Happy to hear that from you.CheersFranco |
|
|
|
mike123
Master Smack Fu Yak Hacker
1462 Posts |
Posted - 2005-07-07 : 04:46:05
|
| ok great i deleted 6 months of backups .. that freed up alot of needed Hd space!thanks! :)mike123 |
|
|
|
franco
Constraint Violating Yak Guru
255 Posts |
Posted - 2005-07-07 : 04:52:32
|
| You know you can automate the process of backing up your databases and T-Log, and delete backup files (*.bak) and transaction log (*.trn) on a regular basis, for example using Maintenace Plan or your own routine.Franco |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2005-07-07 : 05:18:54
|
if this is production server, please do delete northwind and pubsquote:
Originally posted by mike123
the same rule applies for the PUBS DB ?thanks again!mike123
--------------------keeping it simple... |
|
|
|
|
deleting MSDB databases