Page 1 of 1
Database error
Posted: Mon Jan 29, 2024 4:28 pm
by artamous75
Im showing a Large database alert see attached. Any ideas on how to correct or what is best practice/settings for keeping the DB from causing any performance issues?
Re: Database error
Posted: Mon Jan 29, 2024 4:33 pm
by TimG
What does it show in the Log ? It could be that the database is corrupted and needs to be rebuilt.
Re: Database error
Posted: Tue Jan 30, 2024 3:25 pm
by artamous75
I dont see any errors pertaining to the DB in the log, but i also dont see the runing log, can you point me to where it should be?
How do i rebuild the DB? Will i loose any information?
Re: Database error
Posted: Tue Jan 30, 2024 4:10 pm
by MikeBwca
...
Re: Database error
Posted: Tue Jan 30, 2024 4:14 pm
by artamous75
See Attached
Re: Database error
Posted: Tue Jan 30, 2024 4:34 pm
by MikeBwca
...
Re: Database error
Posted: Tue Jan 30, 2024 10:10 pm
by artamous75
Seagate IronWolf 12TB NAS Internal Hard Drive HDD – 3.5 Inch SATA 6Gb/s 7200 RPM 256MB Cache
What is the process to rebuild the DB?
Re: Database error
Posted: Sun Feb 04, 2024 4:40 am
by MikeBwca
...
Re: Database error
Posted: Thu Feb 22, 2024 4:54 am
by JimkissJum
MikeBwca wrote: ↑Sun Feb 04, 2024 4:40 am
artamous75 wrote: ↑Tue Jan 30, 2024 10:10 pm
Seagate IronWolf 12TB NAS Internal Hard Drive HDD – 3.5 Inch SATA 6Gb/s 7200 RPM 256MB Cache
What is the process to rebuild the DB?
1st - Database 'Repair/Regenerate'. This will keep alerts.
If this doesn't work, then...
2nd - Database Delete & Regenerate. With this option you will loose all alerts. You could use the 'Search' function to generate new alerts, but that would take an extremely large amount of time.
If this doesn't work, then...
3rd - Start with an empty DB...
Shutdown BI. delete the entire BI DB folder and all contents. Then, Start BI. BI will create the necessary folders.
Thanks for sharing this process