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 |
|
silas2
Yak Posting Veteran
65 Posts |
 Posted - 2005-08-11 : 08:51:10
|
| When you create a dump device, then add backups with the NOINIT arg, the space taken up on the device grows, is there a way of removing individual backups from the device without (i guess) purging the whole lot by running WITH INIT?I can get a list of the files by running the RESTORE WITH HEADERONLY, but I can't see how to remove individual ones. |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2005-08-11 : 10:29:42
|
| This problem is one reason why most people no longer use backup devices. It is easier to backup to a file with a timestamped name, and just delete the files when they are no longer needed.You can use a Maintenance Plan to do this, or you can use a stored procedure to do it. Several people have postes procedures here that do this.CODO ERGO SUM |
 |
|
|
silas2
Yak Posting Veteran
65 Posts |
Posted - 2005-08-11 : 13:58:52
|
| I am sorry, I don't quite understand, I can only see <dump_device> as one of the args, I thought backing up the files refered to file groups which compise the database, not the target medium. |
|
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2005-08-11 : 19:08:37
|
You can backup to disk like this:BACKUP DATABASE msdbTO DISK = 'T:\MSSQL\Backup\msdb\msdb_db_200508111647.BAK' CODO ERGO SUM |
|
|
|
silas2
Yak Posting Veteran
65 Posts |
Posted - 2005-08-16 : 08:26:07
|
| Thanks, I'll try that. |
|
|
|
|
|
|
Removing Files From a Dump Device