3 03 2014
MS-SQL – BACKUP
|
1 2 3 4 5 6 7 8 9 10 11 |
BACKUP DATABASE abc TO DISK = 'H:/backup/abc.backup' WITH INIT; BACKUP DATABASE pia TO DISK = 'H:/backup/pia.backup' WITH INIT; BACKUP DATABASE pubs TO DISK = 'H:/backup/pubs.backup' WITH INIT; 시스템백업용도 BACKUP DATABASE Northwind TO DISK = 'H:/backup/Northwind.backup' WITH INIT; BACKUP DATABASE master TO DISK = 'H:/backup/master.backup' WITH INIT; BACKUP DATABASE model TO DISK = 'H:/backup/model.backup' WITH INIT; BACKUP DATABASE msdb TO DISK = 'H:/backup/msdb.backup' WITH INIT; BACKUP DATABASE tempdb TO DISK = 'H:/backup/tempdb.backup' WITH INIT; |