整個backup plan Schedule 如下:
星期日使用full database backup:
代碼: 選擇全部
BACKUP DATABASE [TRY] TO DISK = N'C:TRY.bak'
WITH NOFORMAT, INIT, NAME = N'TRY-完整 資料庫 備份',
SKIP, NOREWIND, NOUNLOAD, STATS = 10
GO
代碼: 選擇全部
BACKUP DATABASE [TRY] FILEGROUP = N'fg3', FILEGROUP = N'PRIMARY'
TO DISK = N'C:TRY1.bak'
WITH NOFORMAT, INIT, NAME = N'TRY-完整 檔案群組 備份', SKIP, NOREWIND, NOUNLOAD, STATS = 10
GO
BACKUP LOG [TRY] TO DISK = N'C:TRYLog.bak' WITH NOFORMAT, INIT,
NAME = N'TRY-交易記錄 TRUNCATE 備份', SKIP, NOREWIND, NOUNLOAD, STATS = 10
GO
restore plan我分為兩個:
file group restore:
代碼: 選擇全部
RESTORE DATABASE [TRY] FILE = N'fg3', FILE = N'TRY'
FROM DISK = N'C:TRY1.bak' WITH FILE = 1,
NORECOVERY, NOUNLOAD, REPLACE, STATS = 10
GO
RESTORE LOG [TRY] FROM DISK = N'C:TRYLog.bak' WITH FILE = 1, NOUNLOAD, STATS = 10
GO
代碼: 選擇全部
RESTORE DATABASE [TRY] FROM DISK = N'C:TRY.bak'
WITH FILE = 1, NORECOVERY, NOUNLOAD, REPLACE, STATS = 10
GO
RESTORE LOG [TRY] FROM DISK = N'C:TRYLog.bak' WITH FILE = 1, NOUNLOAD, STATS = 10
GO