Home › SQL Server

SQL Server Backup


Creating a Full Database Backup

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

Creating a Differential Backup

-- Database Name: AdventureWorks
BACKUP DATABASE AdventureWorks 
TO DISK = 'c:\temp\AdventureWorks_diff.bak'
WITH DIFFERENTIAL
GO

Creating a Transaction Log Backup

-- Database Name: AdventureWorks
BACKUP LOG AdventureWorks 
TO DISK = 'c:\temp\AdventureWorks_log.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.
  • 879 reads