-
Transaction Log Size
Hello dear friends,
In my database i am not able to take the backup of transaction log.
Even if i took the back up and then shrunk the file it doesnt make any change to my transaction log size.
Still the size is same.
So in every two weeks i am restarting my server.
Once it is restarted then it is ok for another 2 weeks.
After 2 weeks my transaction log size will be more than the size of my datafile.
Can you suggest your openion.
No replication or log shipping exist.
Thank you
-
use backup log with TRUNCATE_ONLY option
-
Backup log will not shrink log file size either. Did you get any error when you try to backup log? What's recovery mode the db is? Post details if you need help.
-
Hello shamshe and rmiao,
Thank you for the response.
I tried both commands like
backup log dbname with no_log
backup log dbname with_truncate only.
the result is 'done sucessfully'
then i shrunk the transaction log file.
That was also success.
No error generating.
But after all these when i look on the database the transaction
log size is same.
No change to the size.
give your ideas please.
Thank you
Ichayan
-
You have to check how much free space in the file, don't sgrink it if server has enough free disk space.
-
Hi rmiao,
now my log file size is about 40 gig.
every day we have 4 complete backup.
As the log size is increasing dramatically the backup size also
become big.
how can i solve.
Thank you
-
You have to do log backup to free log space if the db is not in simple recovery mode.
-
yes, i have done that too.
even then no change to the log size.
-
That's correct, backup never change file size. How often do you backup log?
-
Why dont u try this.
Backup the log file and then shrink the logfile using the DBCC shrinkfile command with the argument as the target size..
Its similar to HWM in oracle.
Pavan.
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
|
|