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 |
|
anuradhay
Starting Member
41 Posts |
 Posted - 2004-12-09 : 04:01:56
|
| Hi,I have a database which has one mdf and say 2 ndfs. i am taking backup of this and trying to restore it as another database. now i don't want have mdf and ndf files in the new database. i want to merge it . is it possiblethanks, |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2004-12-10 : 01:02:14
|
not sure, but in restore process, there's a partial restore operation, haven't used it though, but it might be the one you're looking for.or if you're using the wizard, delete the other files and retain the primary when you goto options and force restore the backup to the existing databasebut ofcourse if you have indexes saved on the ndf, you'd probably need it, so i suggest, restore the backup as is, then copy the database and data to another database (with only one data file)  --------------------keeping it simple... |
 |
|
|
anuradhay
Starting Member
41 Posts |
Posted - 2004-12-10 : 06:28:04
|
| Hi,I cannot do partial restore. i want to restore all the files. Thank u. |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2004-12-13 : 00:53:22
|
quote:
so i suggest, restore the backup as is, then copy the database and data to another database (with only one data file)
--------------------keeping it simple... |
|
|
|
|
|
|
|
|
Restore