June 9, 2008 at 2:55 am
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.
June 9, 2008 at 2:55 pm
Never do this before, but, I guess you have to empty those LDFs first, then backup, then, restore.....
June 9, 2008 at 7:26 pm
Hi,
Look like you can take your database offline. If this is the case then the quickest way will be detach database (do a full backup before this) and then attach to the new server with a single log file.
Another way is to backup your log, run dbcc shrinkfile with emptyfile switch. Alter database remove the empty log file. Repeat until only one log file left. Backup and restore on the new server.
By the way, what is the reason you create 8 ldfs as you won't benefit from multiple log files.
Alan
June 9, 2008 at 11:22 pm
Thanks Alan! The reason for multiple ldf's was done by previous DBA, who created multiple ldf when complained of log getting filled.
Atleast to make life easier henceforth, thought to set the db with 1 ldf...would try out your option and let you know the feedback.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply