Slowdown in SQL Restore on SQL Server 2000
We are running SQL Server 2000 on Windows 2000 Server SP4, and our SQL Restore takes at least 10 minutes to launch in Enterprise Manager. We had to roll back after an upgrade, and we find that when selecting “Restore Database”, Enterprise Manager runs remarkably slow. I’m sure we could run the restore through a [...]

Answer Question   |  February 27, 2009  4:34 PM
Enterprise Manager, SQL Enterprise Manager, SQL Restore, SQL Server 2000, SQL Server performance

SQL Restore takes 6-10 minutes to come up in Enterprise Manager
SQL Restore takes 6-10 minutes to come up in Enterprise Manager. We have a customer with hundreds of sites, and all their servers do the same thing. We had to roll back after an upgrade and we find that when just selecting “Restore Database” it will seem like Enterprise Manager is hung, but eventually it [...]

Answer Question   |  February 17, 2009  2:52 PM
MySQL Restore, SQL 2000, SQL Enterprise Manager, SQL performance, SQL Restore, SQL Restore Performance, Windows 2000 Server

Backup/Restore a DB from Microsoft SQL Enterprise Manager to SQL Server Management Studio Express
Hi Is it possible to copy a DB from a server that has a genuin SQL Enterprise Manager to a server that has SQL Server Management Studio Express installed? Both servers are on the same net. I get following error when trying: Restore failed for Server ‘PROGTSTSQLEXPRESS’. (Microsoft.SqlServer.Express.Smo) System.Data.SqlClient.SqlError: The backup set holds a backup [...]

Answer Question   |  August 29, 2008  12:12 PM
Backup, SQL Enterprise Manager, SQL Express, SQL Server backup and restore, SQL Server Management Studio