Backup Question

Question

Backup Question

pyoung

SSC Enthusiast

Points: 106
More actions
July 26, 2019 at 1:52 pm

#3666355

I do not wish to backup my database or databases. Can I do this without suffering a performance hit , such as the transaction log growing enormous ?
Thank you.

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

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

Alejandro Santana SSCommitted Points: 1838 More actions · Answer 1

pyoung wrote:

I do not wish to backup my database or databases. Can I do this without suffering a performance hit , such as the transaction log growing enormous ? Thank you.

The transaction log will grow depending on your transaction size regardless of your database recovery model, if you don't want to the transaction log to grow, make small transactions, if you don't want your transaction log to retain the transactions and grow till a log backup cleans it, make your recovery model simple, and remember, when you make a transaction log backup, the size of the file won't shrink, it just cleans the VLFs so another transactions can use them, to shrink then use the shrink command, and if your transaction log grew up in recovery model simple, shrinking it won't solve your problema, sooner or later it will grow again.

Greetings.

Jonathan AC Roberts SSCoach Points: 18355 More actions · Answer 2

As Alejandro Santana says, just make sure the recovery model is set to Simple.

Jeff Moden SSC Guru Points: 1004356 More actions · Answer 3

pyoung wrote:

I do not wish to backup my database or databases. Can I do this without suffering a performance hit , such as the transaction log growing enormous ? Thank you.

As the others have recommended, change the databases to the SIMPLE Recovery Model.

The real key here, though, is why don't you want to backup anything in the databases? Are they 100% expendable and business will not suffer at all if all the data went away?

--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)