SQL Server Transaction Log Backup

Here's a sample PowerShell script, which demonstrates an end-to-end solution of backing up and restoring a database in an Azure SQL IaaS Virtual Machine. The sample uses the T-SQL snapshot backup capabilities introduced in [!INCLUDE sssql22-md].

使用 SQL Server 快照集備份，在 SQL Server 建立備份鏈結所需的初始完整備份之後，只需使用單一交易記錄備份就能將資料庫還原至交易記錄備份的時間點。

Read this tutorial to learn how to create SQL Server backup jobs using SQL Server Management Studio (SSMS).

Backup SQL Server database with our complete 2025 guide. Step-by-step instructions and best practices for all skill levels.

In Microsoft SQL Server, we can create full database backups using either SQL Server Management Studio (SSMS) or Transact-SQL (T-SQL). In this guide, we will learn an overview of the methods for performing full backups, highlight the necessary permissions

Learn about different options that can be used when creating a full database backup with several examples.