Discussion Locked

Technical Specialist not so special?

0 helpful
2 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
blog root

2 replies

by cd2041

I?m trying hard to figure out what the write way of managing our SQL server is. We have sporadic success. Sometimes the jobs work sometimes they do not.

 

We would like to implement an effective MS SQL Maintenance Plan. Should we use the wizard or something else, not sure?

 

Sorry if this question was asked 50 million times. I?m new here.

 

The Transaction Log Backup job we created using the wizard doesn?t work anymore. Can some help.

 

Created using the Wizard.

  • EXECUTE master.dbo.xp_sqlmaint N'-PlanID 4EC1FB53-8846-4604-B520-5157BE9213AF -WriteHistory  -BkUpOnlyIfClean -CkDBRepair  -BkUpMedia DISK -BkUpLog  -UseDefDir  -DelBkUps 2WEEKS -BkExt "TRN"'

by kev

HI.

Can you post that actual error for the reason its failing from the report log, that will provide much more useful information.

thanks.

This discussion is closed to new replies.