Ismet posted on April 11, 2010 09:40
Lets say you have a SQL Server Database and it has a log file with the size of 10 gb. (Trust me, i have experienced much more dangerous scenario with the 28gb size of it)
For those desperately looking for ways to decrease the size of SQL Server Database Transaction Log File, you may want to follow these three easy steps below:
First of all find the database that troubles you most and browse its location via Windows Explorer (Via > SQL Management Studio > Obj. Ex. > Databases > the name of the db u wanna check out > Properties > Files)
Once finding out the troublemaker, we need to put out the fire. So, you must Shrink the Database (i am going to call it troublemaker again :D)
Many of SQL DB Admins using Full as recovery mode, so it wouldn't give you much happiness with this, don't hesitate and change it over to Simple for a few moments. I swear, nothing bad will happen.
From Tasks menu under OBJ EXP, run the magic of Shrink. Then come back and say thanks to me :)
Posted in:
Tips,
Tutorials
