topic Re: Database is getting large ( 25Gb) in Server Management - Systems Insight Manager

Database is getting large ( 25Gb)

henrik nordström — Fri, 08 Apr 2005 07:03:38 GMT

Hi

I run SIM 4.2 on windows 2003 server standard with sql-server.

I just found out that the database for insight manager is 25 Gb and growing.

The database that im talking about is at:

D:\Data\Microsoft SQL Server\MSSQL\BACKUP\Insight_v1_0_105045708

Any suggestions on why its growing so much

Im a beginner at this so any suggestions would be great

Re: Database is getting large ( 25Gb)

OlivierV — Fri, 08 Apr 2005 08:22:41 GMT

Hi Henrik.
The "live" SQL database is in DATABASE, not in BACKUP. In BACKUP, you will only find the backup of the databases. I think you have scheduled a backup job in SQL enterprise manager to backup the SIM database but you have selected to append the backups instead of replacing. Thus, each time the job runs, it adds the data to the previously backuped ones instead of replacing them with the new ones. I don't think you can change this setting. You will have to delete the current backup job and create a new one with the correct settings. This is done in SQL Enterprise Manager.
Hope this helps.

Re: Database is getting large ( 25Gb)

henrik nordström — Fri, 08 Apr 2005 08:28:23 GMT

Thanks

I was on the right track then, I will take a look at it next week..

Have a nice weekend

Regards

Henrik