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 Transaction Log backup of a database in SQL Server - SQL Server DBA Tutorial
This video illustrates how to take Transaction Log backup (T-Log) of a database in sql server 2005, 2008, 2012 and 2014 using SQL Server management studio as well as using T-SQL script. It shows step by step going through different options of the T-Log backup such as General, media option and Backup options. You will learn how to verify Transaction Log backup and perform check-sum before writing to the media.
Scripts used in this video:
BACKUPLOG[SalesOrders]TO DISK =N'C:\Program Files\Microsoft SQL Server\MSSQL12.SQLPROD\MSSQL\Backup\SalesOrders_Tlog.bak'WITHNOFORMAT,NOINIT, NAME=N'SalesOrders-Full Database Backup',SKIP, NOREWIND,NOUNLOAD, STATS=10 GO
Manually Take 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.