Danbrasco
asked on
SQL EXPRESS and SQL Server backup and restore issue smo
Hello Tech Gurus,
I took a backup of my database in SQL EXPRESS( using the backup option when when right click on the database) and now i trying to restore this database in proper SQL SERVER( restore option we get when you right click on the database folder) and it won't. It says " Restore failed for "SERVER_NAME" Microsoft.Sql.Server.smo"
Restore failed for Server 'PURPLESERV'. (Microsoft.SqlServer.Smo)
Following is the detailed error message
System.Data.SqlClient.SqlE rror: The backup set holds a backup of a database other than the existing 'StandardTimeSQL' database. (Microsoft.SqlServer.Smo)
-------------------------- ----
Program Location:
at Microsoft.SqlServer.Manage ment.Smo.R estore.Sql Restore(Se rver srv)
at Microsoft.SqlServer.Manage ment.SqlMa nagerUI.Sq lRestoreDa tabaseOpti ons.RunRes tore()
========================== =========
System.Data.SqlClient.SqlE rror: The backup set holds a backup of a database other than the existing 'StandardTimeSQL' database. (Microsoft.SqlServer.Smo)
-------------------------- ----
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.00&LinkId=20476
-------------------------- ----
Program Location:
at Microsoft.SqlServer.Manage ment.Smo.E xecutionMa nager.Exec uteNonQuer yWithMessa ge(StringC ollection queries, ServerMessageEventHandler dbccMessageHandler, Boolean errorsAsMessages)
at Microsoft.SqlServer.Manage ment.Smo.B ackupResto reBase.Exe cuteSql(Se rver server, StringCollection queries)
at Microsoft.SqlServer.Manage ment.Smo.R estore.Sql Restore(Se rver srv)
Thanking you in Advance
Regards
I took a backup of my database in SQL EXPRESS( using the backup option when when right click on the database) and now i trying to restore this database in proper SQL SERVER( restore option we get when you right click on the database folder) and it won't. It says " Restore failed for "SERVER_NAME" Microsoft.Sql.Server.smo"
Restore failed for Server 'PURPLESERV'. (Microsoft.SqlServer.Smo)
Following is the detailed error message
System.Data.SqlClient.SqlE
--------------------------
Program Location:
at Microsoft.SqlServer.Manage
at Microsoft.SqlServer.Manage
==========================
System.Data.SqlClient.SqlE
--------------------------
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.00&LinkId=20476
--------------------------
Program Location:
at Microsoft.SqlServer.Manage
at Microsoft.SqlServer.Manage
at Microsoft.SqlServer.Manage
Thanking you in Advance
Regards
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
After restoring the database into SQL server, I tried creating the same users again( that use to be in the SQL EXPRESS ) but it says that user already exsit but i don't have users listed in the login list.
Please see the following error
Server Name: SEVER_NAME
Error Number: 15023
Severity: 16
State: 1
Line Number: 1
User, group, or role 'MY_NAME' already exists in the current database. (.Net SqlClient Data Provider)
Please see the following error
Server Name: SEVER_NAME
Error Number: 15023
Severity: 16
State: 1
Line Number: 1
User, group, or role 'MY_NAME' already exists in the current database. (.Net SqlClient Data Provider)
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER