General discussion

Locked

Technical Specialist not so special?

By cd2041 ·
Tags: Off Topic
blog root

This conversation is currently closed to new comments.

2 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

SQL Maintenance Plan Help

by cd2041 In reply to Technical Specialist not ...

<p class="MsoNormal"><font face="Times new roman" size="3">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.</font></p>
<p class="MsoNormal"><?xml:namespace prefix =" o" ns =" "urn:schemas-microsoft-com:office:office"" /><o><font face="Times new roman" size="3"> </font></o></p>
<p class="MsoNormal"><font face="Times new roman" size="3">We would like to implement an effective MS SQL Maintenance Plan. Should we use the wizard or something else, not sure?</font></p>
<p class="MsoNormal"><o><font face="Times new roman" size="3"> </font></o></p>
<p class="MsoNormal"><font face="Times new roman" size="3">Sorry if this question was asked 50 million times. I?m new here.</font></p>
<p class="MsoNormal"><o><font face="Times new roman" size="3"> </font></o></p>
<p class="MsoNormal"><font face="Times new roman" size="3"><strong>The Transaction Log Backup</strong> job we created using the wizard doesn?t work anymore. Can some help.</font></p>
<p class="MsoNormal"><o><font face="Times new roman" size="3"> </font></o></p>
<p class="MsoNormal"><font face="Times new roman" size="3">Created using the Wizard.</font></p>
<ul>
<li>
<div class="MsoNormal"><font face="Times new roman" size="3">EXECUTE master.dbo.xp_sqlmaint N'-PlanID 4EC1FB53-8846-4604-B520-5157BE9213AF -WriteHistory<span>  </span>-BkUpOnlyIfClean -CkDBRepair<span>  </span>-BkUpMedia DISK -BkUpLog<span>  </span>-UseDefDir<span>  </span>-DelBkUps 2WEEKS -BkExt "TRN"'</font></div></li></ul>

Collapse -

SQL Maintenance Plan Help

by kev In reply to SQL Maintenance Plan Help

HI.<br />
<br />
Can you post that actual error for the reason its failing from the report log, that will provide much more useful information.<br />
<br />
thanks.<br />

Back to After Hours Forum
2 total posts (Page 1 of 1)  

Related Discussions

Related Forums