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

rls

To enable row-level security (RLS) in MS SQL Server (2016 and later) , you need to define a security policy that uses a user-defined, inli...