troubleshooting Question

Copying a database in SQL Server 2005

Avatar of Declan Basile
Declan BasileFlag for United States of America asked on
MySQL ServerMicrosoft SQL Server 2005
5 Comments1 Solution1534 ViewsLast Modified:
We have an enterprise edition trial version of SQL Server 2005 installed on our file server, and SQL Server Express installed on a workstation.  What is the best way to copy a database from the enterprise edition installed on the file server to the SQL Server Express installed on the workstation?
    The "Copy Database" option isn't available in the Express Edition, when I backup the database to a file and try to restore the database I get the error messages:

If the database already exists:
"System.Data.SqlClient.SqlError: The backup set holds a backup of a database other than the existing 'Northwind' database."

If the database doesn't exist:
"System.Data.SqlClient.SqlError: The operating system returned the error '5(Access is denied.)' while attempting 'RestoreContainer::ValidateTargetForCreation' on 'c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Northwind.mdf'. (Microsoft.SqlServer.Express.Smo)"
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 5 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 5 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros