MS SQL Server : Backup & Restore menggunakan query

Berikut adalah  syntax paling mudah untuk mem-backup database SQL Server Anda



Backup Database :

BACKUP DATABASE AdventureWorks
TO DISK = 'C:\Backups\AdventureWorks.BAK' 

Restore Database :

RESTORE DATABASE Adventureworks
FROM DISK = 'C:\Backup\AdventureWorks.bak';