alter databse databasename set recovery simple dbcc shrinkfile (databasename_log) exec sp_helpdb databasename alter database databasename set recover full