This works with MS SQL 2005 and 2008
Use <database Name> GO Alter Database <database Name> Set Recovery Simple GO Alter Database <database Name> Set Recovery Full GO DBCC SHRINKFILE (‘<log file name>’, 1) GO
Use <database Name> GO
Alter Database <database Name> Set Recovery Simple GO
Alter Database <database Name> Set Recovery Full GO
DBCC SHRINKFILE (‘<log file name>’, 1) GO
Copyright © 2010 0×53.com - All Rights ReservedWordPress · BFA Wordpress Templates · Professional Wordpress Templates