Очистка логов

При выполнении скрипта на 2008 сервере не удаляются логи. Это невозможно сделать скриптом. Нужно установить "Recovery model" БД в "Simple". 

To view or change the recovery model of a database:

After connecting to the appropriate instance of the Microsoft SQL
Server Database Engine, in Object Explorer, click the server name to expand the server tree.
- Expand Databases, and, depending on the database, either select a
user database or expand System Databases and select a system database.
- Right-click the database, and then click Properties, which opens the Database Properties dialog box.
- In the Select a Page pane, click Options.
- The current recovery model is displayed in the Recovery model list box.
- Optionally, to change the recovery model select a different model list. The choices are Full, Bulk-logged, or Simple.

Add picture from clipboard (Maximum size: 742 MB)