Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials
Store

Database Consistency error after Solarwinds Application Upgrade

jakkidi

Can some one help me how to fix the NetPerfMon database consistency issues for Solarwinds Application upgrade

Email: abhilash.jakkidi@flocorp.com

DatabaseIntegrityCheck_USER0x8755939717A4D640BAB59321ABE9DDAF_1_20200814_110000.txt

Find more posts tagged with

Accepted answers

All comments

jm_sysadmin

I don't want to sound like I don't want to assist, but this type of thing is best fixed by support.

jakkidi

Thanks For Reply.

We contacted Support already they said only support application not SQL Database.

jm_sysadmin

So maybe Microsoft is the support that can help if the DB is corrupt. Otherwise I would do a clean install if you don't have a good back up of the database.

stek0

Hello jakkidi,

you have 2 options from this point:
1. restore the Database to the last know functioning state.
2. repair the Database...

(make sure to make a Database Backup before you start)

You can repair the Database using DBCC with REPAIR options using SQL Server Management Studio

USE [master]
GO
ALTER DATABASE [SolarWindsOrion] SET  SINGLE_USER WITH NO_WAIT
GO
DBCC CHECKDB ('SolarWindsOrion', REPAIR)
GO
ALTER DATABASE [SolarWindsOrion] SET  MULTI_USER
GO

The results should usualy be like this:

CHECKDB found 0 allocation errors and 0 consistency errors in database 'SolarWindsOrion'.
DBCC execution completed.

Due to you have inconsistence, you will have an output like 15 allocation errors, 15 repaired allocation errors and 21 consistency errors, 21 repaired consistency errors.

if not all errors are repaired you can try the REPAIR_REBUILD action:

USE [master]
GO
ALTER DATABASE [SolarWindsOrion] SET  SINGLE_USER WITH NO_WAIT
GO
DBCC CHECKDB ('SolarWindsOrion', REPAIR_REBUILD)
GO
ALTER DATABASE [SolarWindsOrion] SET  MULTI_USER
GO

If you have again no output like 41 allocation errors, 41 repaired allocation errors and 13 consistency errors, 13 repaired consistency errors, you have one option left:

You can try the REPAIR_ALLOW_DATA_LOSS action:
!NOTE: as you can tell from the name of the command... you can lose data from now.
(But you will propably get a consistent Database and can make the problem again a problem for SolarWinds Support )

USE [master]
GO
ALTER DATABASE [SolarWindsOrion] SET  SINGLE_USER WITH NO_WAIT
GO
DBCC CHECKDB ('SolarWindsOrion', REPAIR_ALLOW_DATA_LOSS)
GO
ALTER DATABASE [SolarWindsOrion] SET  MULTI_USER
GO

To check if your Database is now consistent you can run the DBCC again:

USE [master]
GO
DBCC CHECKDB ('SolarWindsOrion')
Go

your output should be like this:

CHECKDB found 0 allocation errors and 0 consistency errors in database 'SolarWindsOrion'.
DBCC execution completed.

...

I Hope this helps you. Good Luck.