skip to main
|
skip to sidebar
SQL Server Heaven
Tuesday, August 23, 2011
Shrink Database Files
ALTER DATABASE --DatabaseName--
SET RECOVERY SIMPLE;
SELECT name FROM sys.database_files
DBCC SHRINKFILE (--name--, 3);
ALTER DATABASE --DatabaseName--
SET RECOVERY FULL;
Newer Posts
Older Posts
Home
Subscribe to:
Posts (Atom)
About Me
Sagesh
View my complete profile
Archive
►
2013
(1)
►
August
(1)
►
2012
(3)
►
September
(1)
►
February
(2)
▼
2011
(8)
►
September
(2)
▼
August
(1)
Shrink Database Files
►
July
(2)
►
June
(3)
►
2009
(13)
►
November
(1)
►
October
(1)
►
August
(1)
►
July
(1)
►
June
(2)
►
May
(1)
►
April
(1)
►
March
(5)
Followers