Discussion Locked
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.
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.
Trending After Hours posts
Sort by Trending
Question Unanswered
What Instagram content works best for a practical digital planner?
0 helpful
0 replies
0 helpful
10 replies
0 helpful
2 replies
0 helpful
3 replies
Discussion
Hello everyone
0 helpful
3 replies