- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
+1 for Tims answer,
the transaction log problem occurs when the recovery mode is set to full, are you sure you have set the recovery mode to simple.
also don't keep the performance data for too long as this will fill the database.
To view or change the recovery model of a database with SQL Server Management Studio.
- 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.