If you are running a DATABASE BACKUP or RESTORE command manually, SQL Server will show you the progress at a specified % completion interval. For the BACKUP, the default is...
The...
2019-05-17
This is the wrap up of this series on a system for developers to restore production database in test. It gets pretty detailed on the web setup side.
2019-05-16
1,950 reads
Dive deep into the details of part 2 in this series of creating a solution so Developers can start a restore of Production to test.
2019-05-09
3,398 reads
Default backup schemes for databases would be a nice enhancement.
2019-05-08
191 reads
Empower developers to refresh their own test systems with production backups.
2019-05-02
5,026 reads
Learn how to load an external certificate into SQL Server to encrypt your backups.
2019-04-25
1,043 reads
The provisioning process is a critical part of database development. Redgate's Rebecca Edwards looks at a tool that can remove the pain points of backup and restore and replace them with a more efficient solution can hugely benefit your organization and the quality of life of you and your team.
2019-04-24
I recently presented a session on log file management where I discussed monitoring and managing the logical segments of the transaction log known as Virtual Log Files, or VLFs....
2019-04-12
Restoring a database backup from one server to another, or from one database to another on the same machine, often requires MOVE ... TO ... commands. For databases with...
2019-04-05
2018-09-04 (first published: 2018-08-23)
229 reads
By KamilN78
It was tremendously extensive week for me (a week ago) when I spent time...
Techorama 2019 is over and it was a blast, as usual. Neatly organised, great...
Creating a custom container is where things get truly exciting. There’s actually a ton...
Comments posted to this topic are about the item The Change Failure Rate
I have created the following function which is to be used for a check...
If I want to do a SQL Server health check, which aspects should be...
Ask SSC