I have set up differential backups for six of my critical databases to run every two hours, between certain times of the day. I have set them up bt creating the job in TSQL using append, but I want to set an option to delete/remove entries after 2 days like you can in Enterprise Manager. (In Enterprise Manager I can ony set up full backups) How can I accomplish this
Thanks
TinaI think you need to add the following in the parameter:
-DelBkUps 2DAYS
Cheers,
James Goodman MCSE, MCDBA
http://www.angelfire.com/sports/f1pictures
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment