xp_sqlmaint | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive


I need help to write Transaction Log BACKUP JOB with the help of xp_sqlmaint. i try to gather require information, but some how it is not working. i will appreciate if some one can help me to put all together.
I am trying to do is to create transaction log backup job which runs every hour & delete any 2 or 3 days older Transaction log so to maintain log size smaller.Any help will be highly appreciated.

exec xp_sqlmaint ‘ -S SERVERNAME-D Northwind -BkUpLog c: emp -CrBkSubDir -BkUpMedia DISK -DelBkUps 2days -Rpt C: empNwind_bkuplog.txt’ This is assuming you are using Windows Authentication (omits -U username -P password)
… you would get the syntax information from the command prompt by typing xp_sqlmaint /?. Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.