Error with restoring Backups

I recieved 4 database's that were backed up from our client. They are using SQL Server 2000 and each of the files has no extension.

When attempting to restore a database of the same name in SQL Server Express 2k5 I recieve the following error.

System.Data.SqlClient.SqlError: The media set has 2 media families but only 1 are provided

Is there a way to restore the backup without the log backup?

Thank you
-Robert-

Hi,

i just guess that you don′t have a full backup specified here. YOu will have to pick the Full backup and apply the Diff. backups or transactional backups afterwards.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

Error while restoring SQL7 data on SQL Express 2005

Hi,

I have backup of data from SQL Server 7.0 and now when i'm trying to restore it into SQL Express 2005, I'm getting following error......

--
Msg 3154, Level 16, State 2, Line 1
The backup set holds a backup of a database other than the existing 'GOSLDW' database.
Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.
--

Here is SQL i'm using to restore database,

RESTORE DATABASE GOSLDW
FROM DISK = 'C:\sqlserverData\GOSLDW'
WITH MOVE 'GOSLDW' TO 'C:\sqlserverData\GOSLDW.mdf',
MOVE 'GOSLDW' TO 'C:\sqlserverData\GOSLDW.ldf'
GO

Why i'm getting this error? Am i missing anything here?

Thanks in advance for your HELP.

- R

There is already a database existing with this name, you either have to drop the database first or replace it with the WITH REPLACE option, see BOL for more details.

HTH, jens Suessmeyer.

http://www.sqlserver2005.de
|||

Thanks for you reply...

After droping database and runing same query again I got message back that database is restore successfully but I don't see any database created.

How i can see this restored database?

I'm new in this SQLServer world..... Thanks for your help.

-R

|||

When you say you can't see it where are you looking? If this is the treeview in SSMS then try right clicking on the databases node and select refresh. If yuo still can not see it then try executing the following query

select * from sys.databases

|||

I guess you are just connected to the wrong instance, use the following command while connected to the *assumed* right instance to see wheter the database appears in the list: SELECT * FROM sys.databases If not the instance does not hold the database you want to use and you restore the database on another system than the wanted :-|

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

|||

Thanks now its working fine. I had to stop server and restart to see all database.

Thanks for you help,

R

|||You should not have to do that, a simple refresh of the node should allow you to see them all.

Error while restoring database,

Hi,
Im trying to restore a database, when i try to restore by selecting the file groups option it gives me an error Microsoft SQL DMO The backup set holds a backup of a database other than the existing database. RESTORE DATABASE terminated abnormally.
I tried deleting all the tables and the stored procedures that are there, but it still gives the same error.I got this message, too.

In the Options tab, check "Force Restore over existing database".|||Where is this option located?
I'm using SQL Express|||

Tell me. why do I need to check the option "Override the existing database"?

Thanks for the answer

|||If you check "Force Restore over existing database", it must works.|||In Express, click Options on the left and check the field called 'Overwrite the Existing Database'. Also, you may need to change the mdf and log file names to your new database.|||

I had a similar problem, but I was trying to restore the ".bak" file from my laptop to my pc. I had copied the file my pc My Documents folder and tried to restore from SQL Management Express, kept getting the same error. Eventually i tried placing the file in the original backup location it was created but this time on the pc i.e. "C:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\Backup" then it worked. Not sure what's the reason for this but just thought I’d share since I know someone else is probably bursting their heads over the same issue..

|||Setting the "Overwrite existing database" fix the problem for me

Thanks for the pointer.|||

I was getting the following error and ur solution worked fine here, Thx a lot!

"The backup set holds a backup of a database other than the existing database."

Error while restoring database,

Hi,
Im trying to restore a database, when i try to restore by selecting the file groups option it gives me an error Microsoft SQL DMO The backup set holds a backup of a database other than the existing database. RESTORE DATABASE terminated abnormally.
I tried deleting all the tables and the stored procedures that are there, but it still gives the same error.I got this message, too.

In the Options tab, check "Force Restore over existing database".|||Where is this option located?
I'm using SQL Express|||

Tell me. why do I need to check the option "Override the existing database"?

Thanks for the answer

|||If you check "Force Restore over existing database", it must works.|||In Express, click Options on the left and check the field called 'Overwrite the Existing Database'. Also, you may need to change the mdf and log file names to your new database.|||

I had a similar problem, but I was trying to restore the ".bak" file from my laptop to my pc. I had copied the file my pc My Documents folder and tried to restore from SQL Management Express, kept getting the same error. Eventually i tried placing the file in the original backup location it was created but this time on the pc i.e. "C:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\Backup" then it worked. Not sure what's the reason for this but just thought I’d share since I know someone else is probably bursting their heads over the same issue..

|||Setting the "Overwrite existing database" fix the problem for me

Thanks for the pointer.|||

I was getting the following error and ur solution worked fine here, Thx a lot!

"The backup set holds a backup of a database other than the existing database."

Error while restoring database,

Hi,
Im trying to restore a database, when i try to restore by selecting the file groups option it gives me an error Microsoft SQL DMO The backup set holds a backup of a database other than the existing database. RESTORE DATABASE terminated abnormally.
I tried deleting all the tables and the stored procedures that are there, but it still gives the same error.I got this message, too.

In the Options tab, check "Force Restore over existing database".|||Where is this option located?
I'm using SQL Express|||

Tell me. why do I need to check the option "Override the existing database"?

Thanks for the answer

|||If you check "Force Restore over existing database", it must works.|||In Express, click Options on the left and check the field called 'Overwrite the Existing Database'. Also, you may need to change the mdf and log file names to your new database.|||

I had a similar problem, but I was trying to restore the ".bak" file from my laptop to my pc. I had copied the file my pc My Documents folder and tried to restore from SQL Management Express, kept getting the same error. Eventually i tried placing the file in the original backup location it was created but this time on the pc i.e. "C:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\Backup" then it worked. Not sure what's the reason for this but just thought I’d share since I know someone else is probably bursting their heads over the same issue..

|||Setting the "Overwrite existing database" fix the problem for me

Thanks for the pointer.|||

I was getting the following error and ur solution worked fine here, Thx a lot!

"The backup set holds a backup of a database other than the existing database."

Error while restoring database,

Hi,
Im trying to restore a database, when i try to restore by selecting the file groups option it gives me an error Microsoft SQL DMO The backup set holds a backup of a database other than the existing database. RESTORE DATABASE terminated abnormally.
I tried deleting all the tables and the stored procedures that are there, but it still gives the same error.I got this message, too.

In the Options tab, check "Force Restore over existing database".
|||Where is this option located?
I'm using SQL Express
|||

Tell me. why do I need to check the option "Override the existing database"?

Thanks for the answer

|||If you check "Force Restore over existing database", it must works.|||In Express, click Options on the left and check the field called 'Overwrite the Existing Database'. Also, you may need to change the mdf and log file names to your new database.|||

I had a similar problem, but I was trying to restore the ".bak" file from my laptop to my pc. I had copied the file my pc My Documents folder and tried to restore from SQL Management Express, kept getting the same error. Eventually i tried placing the file in the original backup location it was created but this time on the pc i.e. "C:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\Backup" then it worked. Not sure what's the reason for this but just thought I’d share since I know someone else is probably bursting their heads over the same issue..

|||Setting the "Overwrite existing database" fix the problem for me
Thanks for the pointer.
|||

I was getting the following error and ur solution worked fine here, Thx a lot!

"The backup set holds a backup of a database other than the existing database."

Error while restoring database,

Hi,
Im trying to restore a database, when i try to restore by selecting the file groups option it gives me an error Microsoft SQL DMO The backup set holds a backup of a database other than the existing database. RESTORE DATABASE terminated abnormally.
I tried deleting all the tables and the stored procedures that are there, but it still gives the same error.I got this message, too.

In the Options tab, check "Force Restore over existing database".
|||Where is this option located?
I'm using SQL Express
|||

Tell me. why do I need to check the option "Override the existing database"?

Thanks for the answer

|||If you check "Force Restore over existing database", it must works.|||In Express, click Options on the left and check the field called 'Overwrite the Existing Database'. Also, you may need to change the mdf and log file names to your new database.|||

I had a similar problem, but I was trying to restore the ".bak" file from my laptop to my pc. I had copied the file my pc My Documents folder and tried to restore from SQL Management Express, kept getting the same error. Eventually i tried placing the file in the original backup location it was created but this time on the pc i.e. "C:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\Backup" then it worked. Not sure what's the reason for this but just thought I’d share since I know someone else is probably bursting their heads over the same issue..

|||Setting the "Overwrite existing database" fix the problem for me
Thanks for the pointer.
|||

I was getting the following error and ur solution worked fine here, Thx a lot!

"The backup set holds a backup of a database other than the existing database."

Error while restoring database,

Hi,
Im trying to restore a database, when i try to restore by selecting the file groups option it gives me an error Microsoft SQL DMO The backup set holds a backup of a database other than the existing database. RESTORE DATABASE terminated abnormally.
I tried deleting all the tables and the stored procedures that are there, but it still gives the same error.I got this message, too.

In the Options tab, check "Force Restore over existing database".|||Where is this option located?
I'm using SQL Express|||

Tell me. why do I need to check the option "Override the existing database"?

Thanks for the answer

|||If you check "Force Restore over existing database", it must works.|||In Express, click Options on the left and check the field called 'Overwrite the Existing Database'. Also, you may need to change the mdf and log file names to your new database.|||

I had a similar problem, but I was trying to restore the ".bak" file from my laptop to my pc. I had copied the file my pc My Documents folder and tried to restore from SQL Management Express, kept getting the same error. Eventually i tried placing the file in the original backup location it was created but this time on the pc i.e. "C:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\Backup" then it worked. Not sure what's the reason for this but just thought I’d share since I know someone else is probably bursting their heads over the same issue..

|||Setting the "Overwrite existing database" fix the problem for me

Thanks for the pointer.|||

I was getting the following error and ur solution worked fine here, Thx a lot!

"The backup set holds a backup of a database other than the existing database."

Error while restoring database

Hi,
Im trying to restore a database, when i try to restore by selecting the file groups option it gives me an error Microsoft SQL DMO The backup set holds a backup of a database other than the existing database. RESTORE DATABASE terminated abnormally.
I tried deleting all the tables and the stored procedures that are there, but it still gives the same error.I got this message, too.

In the Options tab, check "Force Restore over existing database".|||Where is this option located?
I'm using SQL Express|||

Tell me. why do I need to check the option "Override the existing database"?

Thanks for the answer

|||If you check "Force Restore over existing database", it must works.|||In Express, click Options on the left and check the field called 'Overwrite the Existing Database'. Also, you may need to change the mdf and log file names to your new database.|||

I had a similar problem, but I was trying to restore the ".bak" file from my laptop to my pc. I had copied the file my pc My Documents folder and tried to restore from SQL Management Express, kept getting the same error. Eventually i tried placing the file in the original backup location it was created but this time on the pc i.e. "C:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\Backup" then it worked. Not sure what's the reason for this but just thought I’d share since I know someone else is probably bursting their heads over the same issue..

|||Setting the "Overwrite existing database" fix the problem for me

Thanks for the pointer.|||

I was getting the following error and ur solution worked fine here, Thx a lot!

"The backup set holds a backup of a database other than the existing database."

Error while restoring a database.HELP!

Hello,

I am taking the error message which is in the below side,while restoring a database.(I am using sql server 2005)

The backup set holds a backup of a database other than the existing 'db1' database. (db1 is the database name.)

Can you help me?

This error indicate the database being restored is not the same database backuped in the backup set. This is possible even when the database name is the same. You can take a look at this error description:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/trblsql/tr_reslsyserr_2_7mk4.asp