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

Python List, NumPy Array and Pandas DataFrame

 The strength of numpy arrays is that it allows for vectorized operations (applying a calculation to the whole array at once without loops)...