Restoring the backedup database

Dear All,

I had created the backup for the exisiting datbase by writing the schedule which triggers at the particular time on a day. The backup format i had used is .bak. Now i want to restore these backup files into another database (fake database). When i am trying to restore the backup data, an error stating 'The backup set holds the backup of other than exsting <Database Name> database' is displayed and the restore operation is terminating abnormally. kindly give the excat soultion for this problem..

Regards,Try to rstore with the option "Force restore over existing database" (Enterprise Manager - All Tasks - Restore Database (option panel)

Originally posted by pardhu
Dear All,

I had created the backup for the exisiting datbase by writing the schedule which triggers at the particular time on a day. The backup format i had used is .bak. Now i want to restore these backup files into another database (fake database). When i am trying to restore the backup data, an error stating 'The backup set holds the backup of other than exsting <Database Name> database' is displayed and the restore operation is terminating abnormally. kindly give the excat soultion for this problem..

Regards,|||Hai dbadelphes,

I tried even by checking that option.

Originally posted by dbadelphes
Try to rstore with the option "Force restore over existing database" (Enterprise Manager - All Tasks - Restore Database (option panel)|||Make sure the database name is identical between these 2 servers.
BTW what command you're using to restore?|||Hai,

I am trying thru Enterprise Manager Wizard. I made the database names identical even.

Regards,

Originally posted by Satya
Make sure the database name is identical between these 2 servers.
BTW what command you're using to restore?|||From QA have you tried using WITH MOVE (no existing db1), or REPLACE (when you have a new db1)?

Try making sure that no db1 currently exists, then something like:
RESTORE DATABASE db1 FROM DISK='c:\db.doc'
WITH MOVE 'db1_Data' TO 'R:\Microsoft SQL Server\MSSQL\data\db1.mdf',
MOVE 'db1_Log' TO 'q:\Microsoft SQL Server\MSSQL\data\db1.ldf'

Refer to BOL for more information on BACKUP statement.sql

Restoring datbase on different machine

Hi All,

I am using SQL serve 2000. My client has sent me one database. I want to restore here. How do I restore the database which has been sent to me.
Vinihi vini,
what do u mean by the client has sent u a database? I mean is it a database backup or the database file(mdf)??
If it is a backup of the database then you can create a empty database and restore the database backup on this new database.
If it is a database file (mdf) then attach the database to the database server.
regards,
harsh.|||To restore a dump from other Server , you don't have to create an empty database !! Use RESTORE COMMAND WITH MOVE option (See BOL) or USe Enterprise manager , Right click any existing database : Click Restore : Change the name to New Db , In Options tab , amke sure the Physical File Path is Correct matching to the Server you are restoring , Click Force Restore and Hit OK .

For MDF Files If you do not have Log File with it , sp_Attach_singly_file might work but you are likely to loose the transactions which are uncommited and sitting on MDF file ..