Browse by Tags

SQL Server 2005 how to copy database maintenance plans between the servers?

Published 15 October 7 8:54 AM | SSQA.net

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...

Filed under: sql server, backup, ssis, ssms, maintenance plan, service pack2, management studio

Error message when you try to restore a database by using SQL Server Management Studio in SQL Server 2005 after you use the Backup tool: "Restore failed for Server '<ServerName>' (Microsoft.SqlServer.Smo)"

Published 4 June 7 7:28 PM | SSQA.net

Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition Notification Contents: New and Major Modifications Error message when you try to restore a database by using SQL Server Management Studio in SQL Server 2005 after you use the...

Filed under: sql server, restore, backup, ssms, database