Mirror Database growup Log file

Question

Post reply

Mirror Database growup Log file

TNT Development CH

Mr or Mrs. 500

Points: 535
More actions
September 9, 2008 at 12:16 am

#382570

Dear ive a problem with a mirrored Database on SQL2005
Data File Initial Size 75MB By 1 MB, unrestricted growth
Log File Inditial Size 1096 Mb By 10 percent, restricted growth to 2097152 MB
why does the logfile grows up and the database are 1170 MB space use?

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 1

Do you have regular log backups running?

See - http://sqlinthewild.co.za/index.php/2008/07/23/recovery-model-and-transaction-logs/

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

TNT Development CH Mr or Mrs. 500 Points: 535 More actions · Answer 2

the Database are in a Full Recovery Model

and there is configurate only backup from the Database and not from the Log File

on your link are described to do an Logbackup

In full recovery mode, log records are retained within the transaction log until a log backup occurs.

I run a Backup from Transaction Log Shipping for a few times, after this ive run a shrink on the Database New Size 68 MB

I think the best would be to run an logfile backup and Shrink job as scheduled Job on the server,

this will let the logfile not grow up!

Thanks for your help

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 3

You need to schedule regular log backups. If you do, the log won't grow to huge sizes. The frequency of the log backup depends on the activity in the DB, and how much data you're willing to lose in the case of a disaster.

Do not regularly shrink the database or the log. It has several downsides. The idea is to size the log appropriately for the activity and the frequency of the log backups, and leave it alone.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

TNT Development CH Mr or Mrs. 500 Points: 535 More actions · Answer 4

ive configured now only an daily Backup job for the logfile.

then i will see how big the log are growing up in the next time.

thanks