“But I don’t need to back up that database.”
Brent Ozar shares four stories of people who thought they could avoid backups - and got burned.
2018-05-04
5,663 reads
Brent Ozar shares four stories of people who thought they could avoid backups - and got burned.
2018-05-04
5,663 reads
Once you enable your database to be encrypted with Transparent Data Encryption (TDE), the physical database files, and the database backups are encrypted. If your database and database backup are encrypted, then how can you send the encrypted backup to a person outside your organization?
2018-03-27
2,947 reads
Jeffrey Yao explains how to generate backups based on the amount of data that has changed for differential and transaction log backups.
2018-01-02
3,457 reads
So you’re hosting your SQL Server in the cloud, and you’ve noticed that when you’re running a backup or a DBCC CHECKDB, you suffer from extreme performance problems - what's going on? Brent Ozar explains.
2016-11-08
3,699 reads
2016-03-14
90 reads
An explanation as to what Log Shipping is and why it's still a viable solution in 2016.
2016-02-18
542 reads
Are you using Ola Hallengren's Maintenance Solution? Here's a Python script that helps you keep track of your backup file inventory.
2016-01-25
2,376 reads
Generic SQL backup with Azure support allowing several, handy backup options.
2016-01-29 (first published: 2016-01-21)
354 reads
It is anoying that someone created a new database and left its recovery mode in simple and it caused your backup jobs to fail.
2015-11-23 (first published: 2015-10-26)
643 reads
-- Backup Growth Trend Check To Understand how much disk space you need in future
2019-05-03 (first published: 2015-06-02)
1,195 reads
By Steve Jones
Today’s coping tip is to ask other people about things they’ve enjoyed recently I...
By Steve Jones
Today’s coping tip is to challenge negative thoughts and look for the upside. I’m...
Since changing to the new MVP renewal model, Microsoft MVPs have had until 31...
Hi friends, So I have a Login to a server that is a windows...
We recently had to rebuild servers that were configured with AG. I built everything...
Hi there I have a problem with a dynamicSQL Statement. In this code, I...