Backup overview (SQL Server) - SQL Server | Microsoft Learn
Oct 11, 2023 · A backup of SQL Server data is created at the level of a database or one or more of its files or filegroups. Table-level backups cannot be created. In addition to data backups, the full …
Troubleshoot SQL Server database backup - Azure Backup
Nov 12, 2025 · This article provides troubleshooting information for SQL Server databases running on Azure virtual machines. For more information about the backup process and limitations, see About …
Restore a SQL Server Database to a Point in Time (Full Recovery Model)
To permit log backups, before taking a full database backup, the database was set to use the full recovery model, using ALTER DATABASE AdventureWorks SET RECOVERY FULL.
sql server - Why Does the Transaction Log Keep Growing or Run Out …
Dec 5, 2012 · Instead, it lets the log file continue to grow and will allow it to keep growing, until you take a log backup (or run out of space on your log file drive) under normal circumstances.
How Often Should SQL Transaction Logs Be Backed Up?
Jun 2, 2025 · Yes, SQL transaction log backups can be automated using SQL Server Agent, cron jobs (for MySQL and PostgreSQL), or other scheduling tools. In SQL Server, you can create scheduled …
Get Last Database Backup Times in SQL Server
Jan 18, 2026 · Check the last full, differential, and transaction log backup times for all databases in SQL Server to verify backup coverage and recovery readiness.
Azure Monitor Logs in Azure Backup - Azure Backup | Microsoft Learn
Nov 26, 2025 · Monitor backup jobs using the Recovery Services vault's activity logs Caution The following steps apply only to Azure VM backups. You can't use these steps for solutions such as the …
Unable to Shrink Log file for Always On Availabilty Group Database
Nov 19, 2020 · Else, the log will have to grow again - and that is an expensive operation, because SQL Server need to zero out the log space. Once you have scheduled regular log backups, you can …
SQL SERVER – Transaction Logs: The Good, The Bad, and The Ugly
Aug 21, 2023 · Best Practices for Managing SQL Server Transaction Logs 1. Regular Log Backups To prevent transaction logs from growing indefinitely and consuming all available disk space, it’s crucial …
sql server - Get last full backup and transaction log backup for each ...
Jan 14, 2015 · How to write script or a query that will display the last full backup and the last log backup for each database on each of the production servers using the system table "backupset" and related …