Thursday, 28 January 2010

SQL DB Shrink Sample

Sample SQL 2000 SQL 2005
use "DB_Name"
backup log "DB_Name" with truncate_only
dbcc shrinkfile ("DB_LogFile_Name",10)

Sample SQL 2008
use "DB_Name"
dbcc shrinkfile ("DB_Name",100,TRUNCATEONLY)

Technet

No comments: