2018-02-22
809 reads
Backup and restore
2018-01-12
905 reads
2017-07-18
1,005 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
2,090 reads
2016-10-19
1,186 reads
Managing SQL Server Backup and Restore History Information
Greg Larson explains that SQL Server provides a couple of different ways to delete backup and restore history. If you want to remove backup and restore information for all databases based on a date you can use the sp_delete_backuphistory system stored procedure. Or you can use the system stored procedure named sp_delete_database_backuphistory if you want to remove all backup and restore history for a specific database.
2016-10-04
5,098 reads
2016-02-12
1,519 reads
Solve Common SQL Server Restore Issues
Understanding backup and restore processes is essential for developers and DBAs to be more confident when dealing with uncommon situations and having the ability to suggest flexible solutions related to these processes. In this article, Sergey Gigoyan answers some key questions relating to backup and restore.
2015-12-16
3,341 reads
Backup and Restore Strategies in SQL Server – Part 2
In this article of the series Arshad Ali discusses different types of restore processes and backup and restore scenarios.
2014-11-07
10,468 reads
Blogs
AI Helps Me with My Sloppiness
By Steve Jones
I type fairly well. Well, I type fast, but I do wear out a...
Automatic Index Compaction
By ReviewMyDB
Index maintenance has always meant nightly jobs and a window you have to defend....
The Goldilocks problem – Materialized Views
I’m sure you’ve all heard the tale of Goldilocks and the Three Bears, but...
Forums
SQL Art, Part 4: Happy 4th of July — A British DBA's Guide to Celebrating a War We Don't Talk About
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
How We Handled a Vendor Retry That Loaded Twice in Snowflake
Comments posted to this topic are about the item How We Handled a Vendor...
Cognitive Coverage
Comments posted to this topic are about the item Cognitive Coverage
Question of the Day
Getting the Average
I have this data in the dbo.Commission table in a SQL Server 2022 database.
salesperson commission Brian 12 Brian 16 Andy 7 Andy 14 Andy 21 Steve 20 Steve NULLAll the data is a varchar, and I decide to run this query to get the totals for each salesperson.
SELECT SalesPerson
, AVG(TRY_PARSE(Commission AS int)) AS TotalCommission
FROM commission
GROUP BY SalesPerson
GO
What average commission is calculated for Steve? See possible answers