SQL Enterprise Manager

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

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

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 'PROGTST\SQLEXPRESS'. ...