Home › SQL Server › SQL Server Mirroring

SQL Server Database Mirroring - Taking a Data and Log Backup on the Principal Server for configuring Mirroring


Taking a FULL Backup on the Principal Server for configuring Mirroring

-- DatabaseName: AdventureWorks
BACKUP DATABASE AdventureWorks 
    TO DISK = 'C:\AdventureWorks.bak' 
    WITH FORMAT
GO

Taking a Transaction Log Backup on the Principal Server

-- Database Name: AdventureWorks
BACKUP LOG AdventureWorks 
    TO DISK = 'C:\AdventureWorks.bak' 
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.