Home › SQL Server › SQL Server Backup

SQL Server Transaction LOG Backup


Creating a Transaction LOG Database Backup to a Disk File

-- Database Name: AdventureWorks
BACKUP LOG AdventureWorks 
TO DISK = 'c:\temp\AdventureWorks_log.bak'
GO

Creating a Transaction LOG Backup with COPY ONLY Option

-- Database Name: AdventureWorks
BACKUP LOG AdventureWorks 
TO DISK = 'c:\temp\AdventureWorks_log.bak'
WITH COPY_ONLY
GO

Share |
 Cant find the page you are looking for?
 Help us to improve by adding the content that you are looking for.
 Leave a feedback
 We look forward to hear your comments and feedback.