Sean Wallbridge
Seems everytime I have to do this, I need to find the bloody syntax. So, here it is, so I can find it again fast next time 🙂
DBCC SHRINKFILE(DATABASE_NAME_log, 2)
https://support.microsoft.com/kb/272318/en-us
Powered by www.itgroove.net
DBCC SHRINKDATABASE (DATABASE_NAME, 10);
GO
http://msdn2.microsoft.com/en-us/library/ms190488.aspx
You may need to backup the transaction logs (and the database of course) in order to see the results you want…