hi guys, we have a translog database (.LDF) of 60 GB which the contain database itself (.MDF) is only 500 MB. I have detached the translog and succeeded, but when i tried to attached the MDF file, there was an error message says "physical device error D:\\...". Please advice, what should we do towards the .LDF file (60 Gigs) - our objective is to delete/decrease the LDF file mentioned. Thanks in advance.Try this page:
http://www.support.microsoft.com/?id=272318
Basically you want to eliminate the data within the log then shrink the footprint of the file. Also, if you do not require transactional recovery you might consider using simple recovery mode which truncates the log upon checkpoint of the data.
HTH
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment