Execute the provided script on an MS SQL Server instance where you want to know the progress of a maintenance operation. The script will return all the maintenance commands, progress in % for each operation, and thier start time.
The script has been tested on MS SQL Server versions: 2005, 2008, 2008R2, 2012, 2014, 2016.
SELECT command, percent_complete, start_time FROM sys.dm_exec_requests where percent_complete <> 0;
In the part 18, we created a Cube based on the Azure Data Warehouse. In this new chapter, we will work with the cube, create backups and show some tips to restore.
2020-05-29 (first published: 2017-10-23)
2,994 reads
Perform automated database restores and check the integrity of your backup files
2014-08-11
5,462 reads
A DBA's tasks, from day-to-day, are rarely constant; with one exception: the need to ensure each and every day that any database in their charge can be restored and recovered, in the event of error of disaster. In this book, you'll discover how to perform each of these backup and restore operations using SQL Server Management Studio (SSMS), basic T-SQL scripts and Red Gate's SQL Backup tool.
2013-08-26
12,691 reads
It’s uncommon that a SQL Server DBA needs to create a customized backup and restore routine for an application using combination of LiteSpeed extended stored procedures. However, you should be really careful when you are implementing such a solution.
2012-12-19
1,108 reads
Backups are an everyday part of DBA life, whereas restores tend to happen on call at 3 a.m. In this article, Grant Fritchey looks at what you should be doing to make your restores as quick and seamless as possible.
2011-12-14
7,037 reads
