→ 🚀What's New? Join Us for the Fall Product Launch! Register Now !

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
camerons
Engaged Sweeper
I just found out in my database the log files are running 25gb and the database is 4gb. This seems rather large. I was wondering if there any tables and logs I could truncate and if so
A)What are the names?
B)what is the sql script to do this?

I'm running SQL Server 2008 X64 Express

Thanks.
1 ACCEPTED SOLUTION
Hemoco
Lansweeper Alumni
I suggest downloading the sql server management tools (free download from Microsoft site)
You can right click the database and select "shrink" and "shrink files"

View solution in original post

1 REPLY 1
Hemoco
Lansweeper Alumni
I suggest downloading the sql server management tools (free download from Microsoft site)
You can right click the database and select "shrink" and "shrink files"