Generate Restore Database Commands
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
Backup and restore
2018-09-04 (first published: 2018-08-23)
309 reads
2018-07-24
871 reads
2018-06-25
896 reads
2018-02-22
801 reads
2018-01-12
890 reads
2017-07-18
990 reads
Displaying Backup or Restore Progress
Have you ever started a database backup or a restore process that runs a long time then wanted to know when it will complete? Knowing when a database backup or restore operation will complete provides you valuable information, especially when you need to perform follow-on tasks that are waiting for the backup or restore process to complete.
2017-05-12
4,017 reads
Extended Events for Tracking Backup and Restore Progress
Microsoft has introduced new extended events in SQL server 2016 which will give us detailed information about restore and backup process.
2016-12-26
1,731 reads
2016-10-19
1,180 reads
Blogs
Bicep Your Elastic Jobs
I posted on Terraform and Azure SQL last year but wanted to see what...
3rd Party Applications Have Issues
By Kevin3NF
As a SQL DBA, what do you do when a vendor application has performance...
Check Azure SQL DB Space Used
A couple of days ago I was doing some cleaning on some Azure SQL...
Forums
The On-Call Load
Comments posted to this topic are about the item The On-Call Load
Two Table Hints
Comments posted to this topic are about the item Two Table Hints
Database Dashboards in Azure Data Studio
Comments posted to this topic are about the item Database Dashboards in Azure Data...
Question of the Day
Two Table Hints
What happens when I run this code:
SELECT p.ProductName , p.ProductCategory FROM dbo.Product AS p WITH (NOLOCK, TABLOCK);See possible answers