-
how to decrease transcation log file size in sql server 7.0
My Transcation log file size growing to 16GB.There is nospace in that perticular drive.
ie why i need to decrease size of that transcation log file.
Can u please do a favour
-
for transaction log
friend.. how about shrink log file?
shrink method is shrink the referenced files to be a smallest possiable size but at least should try 3 or 4 times.
It'll work.
-
If you didn't enable db option 'truncate log on checkpount', you have to do log backup periodically to control log size.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|