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.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment