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 |
|
orlith
Starting Member
6 Posts |
 Posted - 2008-05-14 : 12:33:56
|
| Hi ThereI have a DB with multiple files (data, index..) (about 20).I'm migrating this DB to a new server and I would like to know how I can decrease the number of file when doing a restoration.I would like to have 1 for Data, one for index and one for logs.Is there a way to do that by script ?I've tried a restore statement with move.. but with no luck.Any idea/help please ? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-05-14 : 13:12:51
|
| You can't do this during the restore. You'll have to fix it after the restore by moving the objects to the filegroups you want to keep, and then when the filegroup is empty, you can delete it.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Database maintenance routines:http://weblogs.sqlteam.com/tarad/archive/2004/07/02/1705.aspx |
 |
|
|
orlith
Starting Member
6 Posts |
Posted - 2008-05-15 : 05:13:54
|
| Thanks for your answer |
|
|
|
|
|
|
Restoration & merging file - Help