This website uses cookies. By clicking Accept, you consent to the use of cookies. Click Here to learn more about how we use cookies.
Community FAQ
Register | Log In
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
- Lansweeper Community
- Forums
- General Discussions
- Database size
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
Register to ask a question, start a topic or share an idea
Join the Community
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-31-2011 12:25 PM
Hi,
we have following situation.
Currently database size is over 4.5GB and over night transaction log raise over 4.5GB also.
How can we decrease size of database since its only growing up?
Is it possible to delete data older of one year, for example?
we have following situation.
Currently database size is over 4.5GB and over night transaction log raise over 4.5GB also.
How can we decrease size of database since its only growing up?
Is it possible to delete data older of one year, for example?
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
04-01-2011 12:22 PM
Most likely the space is used by the eventlog information.
5 REPLIES 5
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-01-2011 12:22 PM
Most likely the space is used by the eventlog information.
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-31-2011 01:19 PM
Yes, transaction log shrink after that.
You mean Scanning servers -> Scanning & Cleanup options then to check whatever I need?
I did check some options after I started to use Lansweeper, but it is strange that database is growing up but we don't have new computers in system...
You mean Scanning servers -> Scanning & Cleanup options then to check whatever I need?
I did check some options after I started to use Lansweeper, but it is strange that database is growing up but we don't have new computers in system...
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-31-2011 01:08 PM
Normally the transaction log should shrink again, can you confirm this?
To clean up old data you can choose one of the cleanup options in the configuration tool.
To clean up old data you can choose one of the cleanup options in the configuration tool.
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-31-2011 01:03 PM
last version of everything, I have updated with this last update
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-31-2011 12:59 PM
Which version of the service do you have?
General Discussions
Find answers to technical questions about Lansweeper.
New to Lansweeper?
Try Lansweeper For Free
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now
Related Content
- Helpdesk dispatch rules problem in General Discussions
- Does Lansweeper support Azure SQL Server (Azure SQL Database or Managed Instance) databases? in Technical Support Solutions
- Why are some scan item options greyed out in Scanning > Scanned Item Interval? in Technical Support Solutions
- Understanding “No Asset Linked” Entries in LsAgent Assets in Technical Support Solutions
- Lansweeper Installation Fails During Migration Due to Insufficient SQL Permissions in Technical Support Solutions
