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 |
|
crazyme
Starting Member
11 Posts |
 Posted - 2008-06-09 : 07:16:18
|
| Hi all,I have a Prodn DB which has 8ldf's and 1MDF...now my DB is getting migrated to a high end server, in the new server i would like to have only 1 ldf. Tried deleting all the ldf and then backed up the database, wasn't able to restore it, it is asking for all the ldf's.Is there anyway i could restore the database with only one ldf?P.S: I have the latest back up of my DB, ldf's isn't required for me. Knowledge grows when shared... |
|
|
mcrowley
Aged Yak Warrior
771 Posts |
Posted - 2008-06-09 : 15:21:12
|
| Best way to accomplish this is to use the ALTER DATABASE command to remove logfiles. You may need to issue DBCC SHRINKFILE (fileid, EMPTYFILE) before using the ALTER DATABASE command. Otherwise:1) create a new database with the file layout that you want. 2) Create all of the tables in the new database without triggers, or foreign keys3) Transfer the data over (either by BCP or DTS)4) Apply all of the triggers and foreign key constraints. |
 |
|
|
|
|
|
Multiple Transaction logs