Yes my DB file is 10MB but my LOG file (LDF) is 300MB
is there a way to reduce or compres that one?
thanxTake a backup of database and check the log file size.
|||Run DBCC Shrinkfile SQL Server returns space less what it calls active log. Run a search for DBCC shrinkfile in the BOL(books online) and you can also set up a job to run it as needed. Hope this helps.
Showing posts with label reduce. Show all posts
Showing posts with label reduce. Show all posts
Wednesday, March 28, 2012
Subscribe to:
Posts (Atom)