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 |
|
ras2a
Yak Posting Veteran
66 Posts |
 Posted - 2006-07-10 : 06:26:31
|
| Is it possible to physically delete old dbs and tx logs if you are running out of space on a drive? - I assume this would affect the backup job history written to the msdb database? If so, how can you get around this?The drive I'm using for DB and log backups is (usually) plenty large enough to store up to 4wks worth of backups (which is what I've set in the plan), but with one thing and another (messing about testing jobs etc), I am running out of space and would like to delete about a week's worth of data to get back on track?thanksras |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2006-07-10 : 06:29:17
|
| Do you want to delete the databases or the backups?If the databases do you want to get rid of them permanently.If it's the backups then if you backup to files with the date in the name then it's simple.mydbname_full_yyyymmdd_hhmmss.bak==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
ras2a
Yak Posting Veteran
66 Posts |
Posted - 2006-07-11 : 09:48:14
|
| My apologies, it's the backups of the db's that I want to delete. Well, not all, just some? |
|
|
|
|
|
|
Possible to delete old dbs and tx logs?