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
Hi! Connecting people around the world and providing international money transfer services, World Remit has become indispensable for many users. Their services are distinguished by low fees and high transaction processing speed, so many are happy to use their services. More information about the company is written here https://world-remit.pissedconsumer.com/customer-service.html and after reading this information, everyone will see all the benefits that their clients receive.
This comment has been removed by the author.
ReplyDeleteHi! Connecting people around the world and providing international money transfer services, World Remit has become indispensable for many users. Their services are distinguished by low fees and high transaction processing speed, so many are happy to use their services. More information about the company is written here https://world-remit.pissedconsumer.com/customer-service.html and after reading this information, everyone will see all the benefits that their clients receive.
ReplyDelete