Wednesday, September 02, 2009

Perintah Shrink Database SQL


backup log "databasename" with no_log
dbcc shrinkfile(2,1)
dbcc shrinkdatabase("databasename")

2 comments:

adiwirasta said...

bwahahaha...

sangking pentingnya sampe diposting di blog, hahaha...
mantap!!!

MG said...

Iya, gue suka kehilangan script ini :P, gue mo dokumentasiin di blog aja dah. loe juga baru tau scriptnya kaN :D