Backup – Restore SQL 2005

por | 21 Septiembre, 2007

T-SQL code

BACKUP:

USE myDatabaseName

GO

BACKUP DATABASE myDatabaseName
TO DISK = ‘C:\filePath\myDatabaseName.bak’
NAME = ‘The name of the back up.’

 

RESTORE:

RESTORE databaseName

FROM DISK = ‘C:\filePath\backupFilename’