HPE Community read-only access December 15, 2018
This is a maintenance upgrade. You will be able to read articles and posts, but not post or reply.
Hours:
Dec 15, 4:00 am to 10:00 am UTC
Dec 14, 10:00 pm CST to Dec 15, 4:00 am CST
Dec 14, 8:00 pm PST to Dec 15, 2:00 am PST
Server Management - Systems Insight Manager
cancel
Showing results for 
Search instead for 
Did you mean: 

Moving SQL Express Server 2005 for SIM 6.2

 
SOLVED
Go to solution
JonBelanger
Occasional Visitor

Moving SQL Express Server 2005 for SIM 6.2

Hello,

I recently installed SIM 6.2 in our environnement and every is working pretty good so far. I noticed that SQL was installed on my C:\ drive and would like to move it to another drive on my server.

I searched a little and I can't seem to find any info on this topic. I know I could move the database but how do I tell SIM where it will reside from now on.

Any ideas?

Thanks
1 REPLY
shocko
Honored Contributor
Solution

Re: Moving SQL Express Server 2005 for SIM 6.2

Yes, you should be able to export the express DB and move it elsehwere. I used SQL 2008 express as it has a complete management studio which is very handy for such things.

Steps:
- Stop all SI services
- Backup DB
- Export or move
- Modify this file \config\database.props (in the Systems Insight Manager installaion directory)

- Start services and test
If my post was helpful please award me Kudos! or Points :)