Web Development

Ask something
Discussion Locked

SQL.LOG

0 helpful
7 replies

by moushie_23

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
One of my developers has a file (sql.log) on his c: drive that is 3GB. We are trying to get rid of this file, because it is taking up so much space. When I try to delete the file it says Access denied and when I try to open it in wordpad or notepad it either hangs or says the file is too large. Any suggestions on how to get rid of this file?

7 replies

by jmorris

If it's a developer, good chance is they have the local version of SQL server called MSDE running on the system. Try and open up a SQL manager connection to the local computer and or stop the MSSQLSERVER service in service manager. That should unlog the log to delete.

by jmorris

If it's a developer, good chance is they have the local version of SQL server called MSDE running on the system. Try and open up a SQL manager connection to the local computer and or stop the MSSQLSERVER service in service manager. That should unlog the log to delete.

by griffida

First back up the database.
In Enterprise Manager right click for properties, click transaction log and delete. Restrict file growth if you want to keep future files smaller.
If that doesn't work:
Shutdown the processes for SQL after you shut down the server,agent ect.. delete log.

This discussion is closed to new replies.