• State Verified Answer
  • Locked Locked
  • Replies 5 replies
  • Subscribers 39 subscribers
  • Views 587 views
  • Users 0 members are here
Options
Related
This discussion has been locked. The information referenced herein may be inaccurate due to age, software updates, or external references.
You can no longer post new replies to this discussion. If you have a similar question you can start a new discussion in this forum.

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

Parents
  • 0

    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

Reply
  • 0

    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

Children

SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 195,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process.

SolarWinds Customer Success Center Certification Media Vault Link Accounts
About THWACK Blogs For Government Edit Settings Free Tools & Trials
Legal Documents Terms of Use Privacy California Privacy Rights Security Information
©2024 SolarWinds Worldwide, LLC. All Rights Reserved.