Wednesday, April 5, 2023

MS-SQL Server - Backup One Liner

Backup One Liner


The backups are taken to ensure we can recover the data anytime if in case server having an issue.


The common backup types are


- Full Backup

- Differential

- Log

- Copy Only


Related Article...


https://learn.microsoft.com/en-us/sql/t-sql/statements/backup-transact-sql?view=sql-server-ver16


Best Regards



T. Amit Vaid S.

1 comment:

Anonymous said...

Perform Tail-Log Backup

https://learn.microsoft.com/en-us/sql/relational-databases/backup-restore/tail-log-backups-sql-server?view=sql-server-ver16