November 10, 2005 at 12:00 pm
Hello,
I am using log shipping as a disaster recovery soloution. The problem I am having is that the log file continues to grow after I have performed a log backup. I have used DBCCC OPENTRAN(databasename) to see if there are currently any open transactions. The result is there are no open transactions. I am thinking that the transactions are being committed but are remaining active. I want to find out if there are commited transactions that are still active. Any suggestions.
Nick.
November 14, 2005 at 8:00 am
This was removed by the editor as SPAM
November 16, 2005 at 5:35 am
Is log shipping functioning? Are backups being dumped to the Log Shipping Destination, and are they being uploaded by the standby server?
You should not be trying to perform manual log backups as this would interfere with the log shipping process.
November 16, 2005 at 5:36 am
Oh, and is this really on SQL 2005?
November 16, 2005 at 6:01 am
Is it logshipping out-of-the-box or did you implement it by yourself?
check the log backup statements for "with not_truncate", if that option is set, you might want to set it to "with truncate".
regards
karl
Best regards
karl
November 19, 2005 at 10:29 am
No this is not in SQL Server 2005. First time posting and I did not realize until after I posted.
Log shipping is set up using the log shipping tools supplied by SQL Server 2000 Ent. and it works great.
The problem that I am having is that after my log file gets backed up it does not shrink it keeps growing. Eventually it will shrink a little but then grows again. The problem is there are no active transactions and the virtural log remains active.
This is causes log shipping to become out of synch. Because the files are becoming to large and are taking a long time to copy over to the DR location. Any suggestions.
November 21, 2005 at 3:07 am
"The problem that I am having is that after my log file gets backed up it does not shrink it keeps growing"
Is this the backup part of the logshipping process, or an additional backup you are scheduling?
November 22, 2005 at 5:29 pm
It is part of the process. It is handled by the Database Maitenace Plan.
November 23, 2005 at 2:28 am
There should be two backups in your plan, one to do a daily full backup and one to periodically backup and copy the trasaction logs.
Can you check that these tasks are completing successfully?
December 15, 2005 at 10:10 am
Yes both are completing successfully.
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply