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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-04-25 : 11:43:47
|
| WanToh Shong writes "How to combine multiple database physical files back to one physical file in SQL Server 7.0?" |
|
|
Page47
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2002-04-25 : 12:49:37
|
| don't use the 'with init' argument in you backup command<O> |
 |
|
|
izaltsman
A custom title
1139 Posts |
Posted - 2002-04-25 : 16:03:00
|
Umm... I am not sure if the question has anything to do with backup...  I could be wrong, but I think WanToh has a database that consists of multiple data (mdf/ndf) and log (ldf) files, which he wants to consolidate into one mdf and one ldf.If that's the case, he would need to issue DBCC SHRINKFILE ('logical_filename', EMPTYFILE) command for every file he wants to remove, and then use ALTER DATABASE to drop the empty files.---------------Strong SQL Developer wanted in the Boston area. Please e-mail if interested. |
|
|
|
|
|
|
Conbine multiple physical file back to one