Full disk

Question

Full disk

Viewing 5 posts - 31 through 34 (of 34 total)

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

Steve Jones - SSC Editor SSC Guru Points: 736255 More actions · Answer 1

There's a wizard for the maintenance plan you can use. Just choose log backups to not mess up anything else you have running.

middletree Hall of Fame Points: 3316 More actions · Answer 2

So if I back up the lgos regularly, it will make the logs smaller?

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 3

middletree (5/26/2009)
So if I back up the lgos regularly, it will make the logs smaller?

In theory, yes. By running regularly scheduled transaction log backups, you will keep the size of the transaction log from continually growing. The transaction log backup will allow SQL Server to reuse space in the transaction log instead of having to continually grow to store additional log records.

Unexpected activities or one off processes may affect this.

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

middletree (5/26/2009)
So if I back up the lgos regularly, it will make the logs smaller?

More correct to say, if you backup the logs frequently the log shouldn't grow. A backup won't make the log smaller.

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

Steve Jones - SSC Editor SSC Guru Points: 736255 More actions · Answer 5

The log backup clears space from the existing log so that it can be reused. It clears the space of the transactions that are in the log backup.

So if you have more frequent log backups, you can have a smaller log file. Less frequent, bigger log file.

Frequency doesn't change disk requirements much as you still back up the same information.