切換資料庫的狀態為:ONLINE。
RESTORE DATABASE [資料庫名稱]
WITH RECOVERY
GO
切換資料庫的狀態為:ONLINE。
RESTORE DATABASE [資料庫名稱]
WITH RECOVERY
GO
DBCC SHRINKFILE語法:
DBCC SHRINKFILE
(
{ file_name | file_id }
{ [ , EMPTYFILE ]
| [ [ , target_size ] [ , { NOTRUNCATE | TRUNCATEONLY } ] ]
}
)
[ WITH NO_INFOMSGS ]
先查詢確認「資料庫名稱_log」實際名稱
SELECT * FROM SYS.DATABASE_FILES
WHERE TYPE_DESC = 'LOG'
淢肥開始: