Problem in restoring database
-
Hi I have to database in sql sever 2000 db1 & db2 I want db2 backup in db1 . I have taken db1 bacckup After tht how i do restore Plz Help
-
Hi I have to database in sql sever 2000 db1 & db2 I want db2 backup in db1 . I have taken db1 bacckup After tht how i do restore Plz Help
Do you mean you want to overwrite the data of db1 database with that of db2.
Thanking you in Advance Regards Pratik Shah
-
Do you mean you want to overwrite the data of db1 database with that of db2.
Thanking you in Advance Regards Pratik Shah
ya SO how to do? Thnx
-
ya SO how to do? Thnx
Hi, Since you already have the backup of db1 (assumed, as said by you) you can just drop the database db1 and restore the data of db2 in a new database and give the dbname as db1. (This can be done using the Enterprise Manager in SQL 2000). Kind regards PS
Thanking you in Advance Regards Pratik Shah
-
Hi I have to database in sql sever 2000 db1 & db2 I want db2 backup in db1 . I have taken db1 bacckup After tht how i do restore Plz Help
I assume you want to copy everything from db2 to db1. 1. Backup db2. 2. Right click db1, go to All Task/Restore Database.. 3. Check "FROM Device". 4. Select the device by click on button "Select Devices". 5. Add the backup file that you backup from db2. Click button "OK". 6. Go to tab "Option". Change the physical file name to db1.mdf and db1.ldf. 7. Check option "Force restore over existing database". 8. You should know how to continue now. btw, please check Management/Current Activity/Process Info to make sure no connection is connected to db1. Eliz.K www.oin1.com