Backup/Restore a DB from Microsoft SQL Enterprise Manager to SQL Server Management Studio Express
Home > IT Answers > SQL Server > Backup/Restore a DB from Microsoft SQL Enterp...
Lissy
5 pts.
0
Q:
Backup/Restore a DB from Microsoft SQL Enterprise Manager to SQL Server Management Studio Express
SQL Express, Backup, SQL Server Management Studio, SQL Server backup and restore, SQL Enterprise Manager
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'. (Microsoft.SqlServer.Express.Smo)
System.Data.SqlClient.SqlError: The backup set holds a backup of a database other than the existing 'SpiraTest' database.

??
ASKED: Aug 28 2008  12:12 AM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
Mrdenny
46795 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
Yes you can. SQL Server 2005 (including express) will within the throw an error message when trying to restore over an existing database unless you check the Replace Existing check box on the options tab of the restore window. When using the RESTORE DATABASE command you need to use the WITH REPLACE option to avoid the error.

This is to prevent people from accidentally restoring the database when they don't mean to.
Last Answered: Aug 29 2008  6:02 AM GMT by Mrdenny   46795 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

Mrdenny   46795 pts.  |   Aug 29 2008  6:02AM GMT

Check out my SQL Server blog “SQL Server with Mr Denny” for more SQL Server information.

 
0