Ideal Shrink Size

Question

Ideal Shrink Size

Viewing 2 posts - 16 through 16 (of 16 total)

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

Jeff Moden SSC Guru Points: 1004365 More actions · Answer 1

shohelr2003 (11/13/2012)
Yesterday I shrunk transaction log file. After shrinking, my drive's free space was increased to 270 GB. But before shrinking it was 240 GB.
So what's the matter?

It'll probably just grow back to the previous size unless you've done something to change how any batch processes (including any index rebuilds) are being executed. As Anthony asked, what recovery mode are your databases in? Full, BulkLogged, or Simple"?

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Jeff Moden SSC Guru Points: 1004365 More actions · Answer 2

shohelr2003 (11/13/2012)
Actually I do not take transaction log backup. But I take full database backup everyday.
Is there any inconsistency in my backup activities? Why is transaction log backup necessary?
Please let me know.
Thank in advance.

Possibly. It depends on what the recovery mode for your databases are and, like Anthony stated, how much the company values its data.

At this point though and because you brought it up, it sounds like you may be missing some basic knowleddge about databases and backups in Sql Server. There are some really good books that will quickly help you get up to speed with rather general titles like "Accidental DBA" that you should search for and possibly invest in. They could make all of this a whole lot easier for you.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)