DEV Community

Abdelhak
Abdelhak

Posted on • Edited on

SQL Server Backup Report : SQL Server Database

This report provides a detailed overview of SQL Server backups conducted on July 17, 2024. It includes critical metrics such as server name, timestamp, database name, backup type, start and end times, duration, status, last log backup, and backup size.

Backup Details

Server Name Timestamp Database Name Backup Type Start Time End Time Duration (mins) Status Last Log Backup Backup Size (GB)
Server1 17/07/24 07:49 DB1 Full Backup 17/07/24 00:05 17/07/24 00:10 5 Backup Complete 16/07/24 14:00 35.20
Server2 17/07/24 07:49 DB2 Full Backup 17/07/24 00:15 17/07/24 00:25 10 Backup Complete 16/07/24 14:00 1.50
Server3 17/07/24 07:49 DB3 Full Backup 17/07/24 00:30 17/07/24 00:45 15 Backup Complete 16/07/24 14:00 0.75
Server4 17/07/24 07:49 DB4 Full Backup 17/07/24 01:00 17/07/24 01:15 15 Backup Complete 16/07/24 14:00 2.80
Server5 17/07/24 07:49 DB5 Full Backup 17/07/24 01:30 17/07/24 01:45 15 Backup Complete 16/07/24 14:00 0.90
Server6 17/07/24 07:49 DB6 Full Backup 17/07/24 02:00 17/07/24 02:30 30 Backup Complete 16/07/24 14:00 3.50

Column Descriptions

  • Server Name: The name of the server where the backup was performed.
  • Timestamp: The date and time when the report was generated.
  • Database Name: The name of the database that was backed up.
  • Backup Type: Indicates the type of backup performed, such as a full backup.
  • Start Time: The timestamp when the backup operation started.
  • End Time: The timestamp when the backup operation ended.
  • Duration (mins): The total time taken for the backup operation, in minutes.
  • Status: The status of the backup operation, indicating if it was completed successfully.
  • Last Log Backup: The timestamp of the last log backup before this backup operation.
  • Backup Size (GB): The size of the backup file generated, in gigabytes.

Speedy emails, satisfied customers

Postmark Image

Are delayed transactional emails costing you user satisfaction? Postmark delivers your emails almost instantly, keeping your customers happy and connected.

Sign up

Top comments (0)

A Workflow Copilot. Tailored to You.

Pieces.app image

Our desktop app, with its intelligent copilot, streamlines coding by generating snippets, extracting code from screenshots, and accelerating problem-solving.

Read the docs

👋 Kindness is contagious

Discover a treasure trove of wisdom within this insightful piece, highly respected in the nurturing DEV Community enviroment. Developers, whether novice or expert, are encouraged to participate and add to our shared knowledge basin.

A simple "thank you" can illuminate someone's day. Express your appreciation in the comments section!

On DEV, sharing ideas smoothens our journey and strengthens our community ties. Learn something useful? Offering a quick thanks to the author is deeply appreciated.

Okay