How do we get rid of Old Backups?

How do we get rid of Old Backups?

Post by Dinesh.T.K » Sat, 26 May 2001 04:57:19



Rohit,

BOL
-----
Read about the option WITH INIT  under BACKUP DATABASE .

Dinesh.

 
 
 

How do we get rid of Old Backups?

Post by Rohit Achary » Sat, 26 May 2001 05:11:15


Will it alos erase the history of the backup in MSDB. Actually when I do a
restore , I would like only the currents backups be available in Enterprise
Manager


Quote:> Rohit,

> BOL
> -----
> Read about the option WITH INIT  under BACKUP DATABASE .

> Dinesh.


 
 
 

How do we get rid of Old Backups?

Post by Dinesh.T.K » Wed, 30 May 2001 22:30:30


sp_delete_backuphistory.

Dinesh.