SQL 2005/2008資料庫還原指令

[kaku]

-- 如何還原系統資料庫
/* master */
--------------------------------------------------------------------------------------------------------
-- 1. 用 單一 模式去啟動
NET STOP MSSQL$
--STOP ALL SQL Serivces
NET START MSSQL$ /m
-- 2. 用 SQLCMD 連進去
SQLCMD -S DBServer -U sa -P xxxxxxxx
-- 3. 下指令去還原 DB
RESTORE DATABASE master FROM DISK = N'E:\DBBackup\master_backup.bak' WITH REPLACE
GO
--------------------------------------------------------------------------------------------------------
--4.啟動SQL服務
NET START MSSQL$
--------------------------------------------------------------------------------------------------------
/* msdb/model */
--在Management Studio中即可
--建議除了SQL Server本身的服務啟動外,其他SQL相關服務必需關閉
restore database msdb from disk = 'E:\DBBackup\msdb_backup.bak' with replace
restore database model from disk = 'E:\DBBackup\model_backup.bak' with replace
--------------------------------------------------------------------------------------------------------
/* 其它資料庫 */
--在Management Studio中即可
restore database XXXX from disk = 'E:\DBBackup\XXXX_backup.bak' with replace
--------------------------------------------------------------------------------------------------------