When issuesing these TSQL commands, make sure you're an admin and the target database is selected/active
- Open a query window
- make sure your target database is active by issueing a 'use databasename' statement, or selecting the appropriate database in the dropdown
- Change the Recovery Model to Simple; Alter database databaseName SET Recovery Simple
- Shrink the file using DBCC ShrinkFile; DBCC Shrinkfile('Logical name of Log', 1)
- Then switch it back to FULL database recovery mode if desired
Subscribe