SQL Server transaction Log
-
Hi everybody I am using SQL Server 2000. The size of my actual data is 110MB. On the other hand the size of the respective transaction log is 7GB. Is the logical? If not is there a way to reduce it? Note that I use SQL Server's 2000 shrink menu option but the size will not reduce. IMHO this is tooooo much!!!! Thank you in advance for your help Spiros Prantalos Miami the place to be!!
-
Hi everybody I am using SQL Server 2000. The size of my actual data is 110MB. On the other hand the size of the respective transaction log is 7GB. Is the logical? If not is there a way to reduce it? Note that I use SQL Server's 2000 shrink menu option but the size will not reduce. IMHO this is tooooo much!!!! Thank you in advance for your help Spiros Prantalos Miami the place to be!!
Go to the properties of your database, on the "Options" tab, choose "simple" recovery model, and make sure autoshrink is set.
-
Go to the properties of your database, on the "Options" tab, choose "simple" recovery model, and make sure autoshrink is set.