July 26, 2019 at 1:52 pm
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.
July 26, 2019 at 1:58 pm
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.
July 26, 2019 at 2:31 pm
As Alejandro Santana says, just make sure the recovery model is set to Simple.
July 26, 2019 at 2:48 pm
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
Change is inevitable... Change for the better is not.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply