Hi everybody, I have a 10.2Gb .ldf file that is giving me hard disk space problems. We already empty the file with the Enterprise Manager, but the file
still weigths the same...
Is there any procedure shrink this file??
thanks in advanceHi everybody, I have a 10.2Gb .ldf file that is giving me hard disk space problems. We already empty the file with the Enterprise Manager, but the file
still weigths the same...
Is there any procedure shrink this file??
thanks in advance
go to the database in question, type in CHECKPOINT. Wait a little while, then run a shrinkdb. If you are not going to be doing log backups, you need to set the recovery mode to Simple so you don't keep having trouble with this though. After you set it to simple, you can run a shrinkdb and you'll be fine.|||thanks,!
that worked pretty good...
regards,
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment