Sau khi restore một DB với dung lượng cực lớn ta làm gì

1. Chấm dứt việc restore database

RESTORE DATABASE AdventureWorks2008R2 WITH RECOVERY

2. Kiểm tra DB

USE AdventureWorks2008R2;
DBCC CHECKDB

3. Giảm dung lượng file log:

USE AdventureWorks2008R2;
GO
-- Truncate the log by changing the database recovery model to SIMPLE.
ALTER DATABASE AdventureWorks2008R2
SET RECOVERY SIMPLE;
GO
-- Shrink the truncated log file to 1 GB.
DBCC SHRINKFILE (AdventureWorks2008R2_Log, 1024);
GO
-- Reset the database recovery model.
ALTER DATABASE AdventureWorks2008R2
SET RECOVERY FULL;
GO