Monday, November 1, 2010

To Truncate Logfiles (to shrink logfiles )

ALTER DATABASE [9JVPD]
SET RECOVERY SIMPLE;
GO
-- Shrink the truncated log file to 1 MB.
DBCC SHRINKFILE ([9JVPD_log], 1);
ALTER DATABASE [9JVPD]
SET RECOVERY FULL WITH NO_WAIT

No comments:

Post a Comment

Misc Javascript points

 Nodejs can support multithreading through use of promises _ is the numeric separator for javascript, that means the numbers 10_000, 11.23_0...