TechBrothersIT is a blog and YouTube channel sharing real-world tutorials, interview questions, and examples on SQL Server (T-SQL, DBA), SSIS, SSRS, Azure Data Factory, GCP Cloud SQL, PySpark, ChatGPT, Microsoft Dynamics AX, Lifecycle Services, Windows Server, TFS, and KQL. Ideal for data engineers, DBAs, and developers seeking hands-on, step-by-step learning across Microsoft and cloud platforms.
How to Manually Take Tail Log Transaction Log Backup of a Database in SQL Server - SQL Server DBA Tutorial
In this video you will learn how to take Tail Log Transaction Log backup using sql server management studio as well as T-SQL script. After watching this video you will be able to take transaction log backup, Tail Log backup options, store the backup at different location, define database expiry option, backup completion status, how to restore full backup, how to restore differential backup, how to restore Transaction backup (T-Log) and how to restore Tail Log backup of a database in sql server 2008, 2012 as well as 2014. You will also learn recovery options of database while restoring database in sql server 2012.
Script used in this video
BACKUPLOG[SalesOrders] TO DISK =N'C:\Program Files\Microsoft SQL Server\MSSQL12.SQLPROD\MSSQL\Backup\SalesOrders_Tlog.bak' WITH NO_TRUNCATE, COPY_ONLY,NOFORMAT,NOINIT, NAME=N'SalesOrder_Tail_LogTbackup', SKIP,NOREWIND,NOUNLOAD, NORECOVERY, STATS=10 GO
Manually Take Tail Log Transaction Log backup of a database in SQL Server
No comments:
Post a Comment
Note: Only a member of this blog may post a comment.
No comments:
Post a Comment
Note: Only a member of this blog may post a comment.