- Community Home
- >
- Servers and Operating Systems
- >
- HPE ProLiant
- >
- Server Management - Systems Insight Manager
- >
- SQL Database log file
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-01-2005 06:19 AM
тАО06-01-2005 06:19 AM
Environment;
Windows 2003, HP SIM v4.1 and about monitoring about 450 managed systems.
Query;
The log files have been steadily increasing and stand at 97gb on a 143gb disk. At the moment the log file is configured to unrestricted growth but it's behaviour is contrary to another HP SIm box.
Does anyone know of any reason why this would be happening? Can I delete this log file, and then restrict the size of the new one? any advice would be appreciated.
Thank you
Joe
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-01-2005 06:24 AM
тАО06-01-2005 06:24 AM
Re: SQL Database log file
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-01-2005 08:16 PM
тАО06-01-2005 08:16 PM
Re: SQL Database log file
if you are using MS SQL server this should help
created a DB Maintenance plan for the insight db.
added to the transactionlog backup step a second step with this SQL states
------
use Insight_v1_0
DBCC SHRINKfile(Insight_v1_0_log, 0)
------
let this run every 30 minutes an kill all transactionlogbackup that are older than 2 hrs, then it should not grow beyond 200 MB
you will surely have to adjust the statement to oyur db names and filegroups names, but after that it will work.
hope this helps
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-02-2005 12:44 AM
тАО06-02-2005 12:44 AM
Re: SQL Database log file
Thanks for your reply. Just to clarify, What effect if any will this have? Will it reduce/ Shrink the already huge transactio logs or do I have to delete the existing transaction log file.
Also will this setting (auto shrink) not have an adverse effect on database performance.
Please forgive me as my SQL knowlegde is limited.
Thanks
Joe
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-02-2005 01:28 AM
тАО06-02-2005 01:28 AM
Re: SQL Database log file
Thanks for your reply.
Please forgive me as my SQL knowlegde is limited.
I am not totally clear on your suggestion.
The Insight manager database is not currently being backed up via SQL but by an enterprise solution.
I have read that it would be a good idea to create a backup maintenance plan for database and transaction logs, change the recovery mode to simple as suggested by James and this should work.
What do you think
Cheers
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-02-2005 02:45 AM
тАО06-02-2005 02:45 AM
SolutionAt the size of the log files you have right now, it'd be very difficult to do any backups. You definately want to get it shrunk down, and then you can setup a backup plan if you desire.
Backing up the logs aren't that important unless you require the ability to do a restore to the exact moment of a loss. Generally I don't consider the SIM database logs that important, as they will recreate themselves based on newly collected data.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-02-2005 04:45 AM
тАО06-02-2005 04:45 AM
Re: SQL Database log file
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-27-2010 05:02 AM
тАО03-27-2010 05:02 AM
Re: SQL Database log file
I am facing same problem my sql data mdf log files are increasing facing problem while starting the SM
Please help me how to delete these files
I dont have SQL so much Knowledge.
size is incresing please help needed critical
REgards
VAsu