.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
Kaviya Balasubramanian
Sgraph Infotech
Imran Ghani
Post New Web Links

xp_sqlmaint

Posted By:      Posted Date: September 23, 2010    Points: 0   Category :Sql Server
 

Hi All,

 

I have the following scehduled to run every hour but it keeps failing. Any thoughts? Thanks in advance.

 

EXECUTE master.dbo.xp_sqlmaint N'-PlanID 5E964CCA-EFD0-46FC-8D49-C19CD5AD6DD9 -Rpt "C:\Program Files\Microsoft SQL Server\MSSQL\INFO\DB Maintenance Plan2.txt" -DelTxtRpt 4WEEKS -WriteHistory  -VrfyBackup -BkUpMedia DISK -BkUpLog "G:\SQLDATA\MSSQL\Archive" -DelBkUps 2DAYS -CrBkSubDir -BkExt "TRN"'




View Complete Post


More Related Resource Links

Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend