November 19, 2009 at 5:03 pm
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
November 19, 2009 at 7:14 pm
try SSIS
November 19, 2009 at 8:30 pm
Check out this article, it will get you going in the right direction. It's a stored procedure for making Full, Diff, and Trans backups. Variables to pass in are database name and backup type.
Steve
SQL Managed
November 19, 2009 at 9:54 pm
A maintenance plan can do this as well.
November 19, 2009 at 11:00 pm
Though the maintenance plan and ssis options are perfectly sound, here is a list of some possible scripts.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
November 23, 2009 at 5:57 am
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/
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply