SqlServer-QA.net

The following pages were recently modified. Source: Knowledge BaseProduct: Microsoft SQL Server 2005 Enterprise Edition, SQL Server 2005 Standard Edition & SQL Server 2005 Enterprise  X64EditionNotification Contents: New Changes to a SQL Server Agent job are lost when the job corresponds to a subplan in a maintenance plan that you ...

How can you copy the database maintenance plans from one SQL Server instance to another SQL Server instance using 2005 version.  Using the Database Maintenance plans has been increased since SQL Server 2005 is released, also lot more once Microsoft fixed the issues with Service Pack2 for SQL 2005. In general you can take help of ...

If you take into account of most Frequently Asked Questions in any SQL community forums, you will get to see problems against database maintenance plans by the users. Personally I don't like them to use (by default) and professionally always depend (suggest) upon my own scripts to manage the backup & database re-org processes. So coming to ...