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

Post New Web Links


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

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