• 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/