Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
mohinsoft
Starting Member
7 Posts |
 Posted - 2008-03-25 : 05:57:55
|
| hello my freands i attached my database on 3 computer those are stand alone. i get backup form those separately . now,i have 3 backup files,with name: "bkcomputer1.bak","bkcomputer2.bak" and "bkcomputer3.bak" i want merge these,and make new file with new name "master" and restore to new computer my code for restor is: restore database [mydatabase] from disk='c:\bkupcomputer1.bak' restore database [mydatabase] from disk='c:\bkupcomputer2.bak' restore database [mydatabase] from disk='c:\bkupcomputer3.bak' but this way is false,because each restore deleted structure and data old data base,therefore after compile 3 over line,i have only data of computer3 please help me.... thanxM.O.H.I.N |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-03-25 : 14:53:17
|
| This is not possible.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
mohinsoft
Starting Member
7 Posts |
Posted - 2008-03-25 : 16:06:10
|
| thanks my friendwhat is your solution about this problem?i want merge backup filesi need help.........please help me..........M.O.H.I.N |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-03-25 : 18:30:23
|
| It is not possible to do this via backups. You will need to restore the files to separate databases and then merge the objects and data in the databases to your main database.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
|
|
|
i want restore my backup with append