Shrinking database (Dump,transaction,tran, invalid, syntax error) in SQL Server 2008

Starting with SQL SERVER 2008, we are no longer able to use the previous

DUMP TRAN database name with NO_LOG

This way to shrink the database, however, you can use another alternative method, the SQL statement is as follows:

ALTER database name set RECOVERY simplealter database name set RECOVERY FULLDBCC shrinkdatabase (database name, 0)

This way to do

Original link: http://www.lukiya.com/Blogs/2010/06/25/Post-1029.html

Shrinking database (Dump,transaction,tran, invalid, syntax error) in SQL Server 2008