Database error
-
- Posts: 19
- Joined: Mon Apr 05, 2021 6:10 pm
- Location: Antelope, CA
Database error
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?
- Attachments
-
- Database settings.png (57 KiB) Viewed 1569 times
-
- Database error.png (9.6 KiB) Viewed 1569 times
Re: Database error
What does it show in the Log ? It could be that the database is corrupted and needs to be rebuilt.
Forum Moderator.
Problem ? Ask and we will try to assist, but please check the Help file.
Problem ? Ask and we will try to assist, but please check the Help file.
-
- Posts: 19
- Joined: Mon Apr 05, 2021 6:10 pm
- Location: Antelope, CA
Re: Database error
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?
How do i rebuild the DB? Will i loose any information?
Re: Database error
...
Last edited by MikeBwca on Fri Apr 05, 2024 11:50 am, edited 1 time in total.
-
- Posts: 19
- Joined: Mon Apr 05, 2021 6:10 pm
- Location: Antelope, CA
Re: Database error
...
Last edited by MikeBwca on Fri Apr 05, 2024 11:51 am, edited 1 time in total.
-
- Posts: 19
- Joined: Mon Apr 05, 2021 6:10 pm
- Location: Antelope, CA
Re: Database error
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?
What is the process to rebuild the DB?
Re: Database error
...
Last edited by MikeBwca on Fri Apr 05, 2024 11:51 am, edited 1 time in total.
-
- Posts: 1
- Joined: Thu Feb 22, 2024 4:41 am
Re: Database error
Thanks for sharing this processMikeBwca wrote: ↑Sun Feb 04, 2024 4:40 amartamous75 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.