When I create new maintenance plans on an instance of SQL 2005 SP2, they are all successfully created (e.g. they are in the Package Store and jobs are created for each step) but they do not show up in
Is it possible to backup Maintenance Plan? Is it enou开发者_开发问答gh to backup msdb database that has all Agent Jobs?I use SQL Server 2008.
Is there any way to programmatically execute (start) a SQL Server maintenance plan? We have a windows ser开发者_如何学Pythonvice that runs nightly and updates the DB with lots of data, once that is fi
This has been driving me crazy. I have tried a开发者_如何学Goll suggestions and no go. This absolutely does not work. The files are all still there.
Im currently running a Maintenance Plan on SQL that do the following: 1 daily full backup Hourly transaction log backup
I know you can use Reporting and Logging wizard to setup开发者_如何学编程 a report e-mail for a maintenance plan, but is there a way to only send this out if there was a failure? I\'m interested in re
Closed. This question is off-topic. It is not currently accepting answers. Want to improve this question? Update the question so it's on-topic for Stack Overflow.
I created some Maintenance Plans in SQL Server开发者_开发百科 2008 without using the wizard (i.e. right-click on Maintenance Plans and select New Maintenance Plan...). When created that way, there is
When I\'m trying to create a new maintenance plan in SQL Server, it is showing this error: TITLE: Microsoft SQL Server Management Studio
Closed. This question is opinion-based. It is not currently accepting answers. Want to improve this question? Update the question so it can be answered with facts and citations by editing
加载中,请稍侯......