Cannot backup database.

[ampeh12]

Hi Guys,

I'm a newbie here. i have a problem where i cannot backup m database. i'm going to do the upgrade of my Solarwinds (NPM, SAM and IPAM). But when i do backup, it hang on 60% - 70% of the backup. im using MSSQL 2005 Express but my database is size 27GB. im going to upgrade my MSSQL too. Anyone can help me regarding this?

Thanks.

Azfar

[mharvey · Accepted solution]

If your database is truly 27GB then you've far exceeded the max size limit of MS SQL Express.  If you have another server that has a full version of SQL, I'd honestly recommend you stop all Orion services, detach the database, copy the files manually, then move them to the full version of SQL.  Once moved, attach the files, then run the Orion Configuration wizard to point to the new full version of SQL.  Once done, you shouldn't have issues with backing up the database.

Regards,

Matthew Harvey

Loop1 Systems

http://www.loop1systems.com

[ampeh12]

Thanks for your help...i have manage to backup my database as what mharvey told here.

[jozef_franc]

Hi Azfar,

when you need just backup your database you can do it two ways. Both are standard database backup.

1. use standard backup command:

     something like this (of course change the path)

     BACKUP DATABASE SolarWindsOrion

     TO DISK = 'Z:\SQLServerBackups\SolarWindsOrion.bak'

     WITH FORMAT;

2. use Microsoft SQL Server Management Studio

     click on database SolarWindsOrion->in local menu choice Tasks and Back Up... ->Setup parameters of your backup->OK to run backup.

[DanielleH]

Have you followed the steps on each of these docs?

Upgrading Orion Network Performance Monitor

Creating Database Backups

Here's also a KB on Compatibility of SolarWinds Orion Products for Installation and Upgrade

[ampeh12]

no one reply my post...hmm