Pinterest • The world’s catalogue of ideas

Explore Test Database, Simple Recovery and more!

I had a test Database that had built up a giant transaction log. Solution: Change to simple recovery model then right-click -- > Tasks -- > Shrink -- > Files!

Job 1-3 ...."God was protecting him from greater harm. God protects us and send someone or something just to make sure we are safe.

Effect of Instant File Initialization within SQL Server

Remove Unnecessary SQL Server Transaction Log Files

Steps to add Log Shipping monitor into an existing SQL Server

The full scripts to retrieve LSNs from all backup files are found at the end of this tip. “Column A” is backup type performed at a point-in-...