sql.pravin (11/19/2009)
hi everyone,i need a script (stored proc ) to identify all user databases in a server and then apply full backup, differential backup and transactional backup to them ( with their specific schedules )
and it should automatically delete all the backups keeping 2 recent backups in all the 3 types(full, diff, tran)
thanks,
praveen
Hi Praveen,
Check the links
For Backup
http://www.mssqltips.com/tip.asp?tip=1599
For Cleanup
http://www.sqlservercentral.com/Forums/Topic801727-1557-1.aspx
Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/