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 |
|
chander_2580
Yak Posting Veteran
76 Posts |
 Posted - 2008-03-18 : 20:23:14
|
| Hi Gurusis it possible to resore a database (with only 1 mdf & 1 ldf)with the backup set of database (with 2 mdf and 2 Ldf ) without adding files in destination (to be restored ) database ???If yes then how can i do this Please revert as soon as possibleThanks & RegardsChander |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-03-19 : 07:45:00
|
| What do you mean? The backup set doesn't contain MDF and LDF files.Explain clearly.Did you mean attaching/Detaching? |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-03-20 : 23:59:06
|
| If source db has 4 files, target db will get 4 files after restoring from backup. |
|
|
|
|
|
|
Backup & Restoration