
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎09-17-2010 09:53 PM
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.
A)What are the names?
B)what is the sql script to do this?
I'm running SQL Server 2008 X64 Express
Thanks.
Solved! Go to Solution.
Labels:
- Labels:
-
General Discussion
1 ACCEPTED SOLUTION

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎09-17-2010 10:35 PM
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"
You can right click the database and select "shrink" and "shrink files"
1 REPLY 1

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎09-17-2010 10:35 PM
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"
You can right click the database and select "shrink" and "shrink files"
