topic Re: How do you move the MSDE Database? in Server Management - Systems Insight Manager

How do you move the MSDE Database?

Lenny Davis — Wed, 18 Aug 2004 06:53:22 GMT

Recently installed HP SIM using the MSDE database instead of a using full SQL version. How Can I move the MSDE database from the C: drive to a newly installed D: drive or do I have to re-install HP SIM on the D: drive?

Thanks

Lenny

Re: How do you move the MSDE Database?

Lenny Davis — Thu, 26 Aug 2004 04:05:57 GMT

Disappointed not to have received any replies to this, as I would have thought this is a very common problem.

The only article I can find on MS Website relating to moving MSDE databases applies to SharePoint Services, and I don't want to risk trying to apply similar steps to the HP SIM database unless someone can verify that it can be moved and still work.

Lenny

Re: How do you move the MSDE Database?

So Def — Thu, 26 Aug 2004 09:42:53 GMT

I would simply re-install HP SIm on the D and after copy the database from C to D. Easy does it. If you don't want to reinstall you can probably change the ODBC settngs.

Re: How do you move the MSDE Database?

Rob Buxton — Thu, 26 Aug 2004 19:10:22 GMT

Do you just need to move the MSDE Databases or the HPSIM installation as well?

You might need to get the MS SQL Server Admin tool to move databases for MSDE.
It's really a DBA Question as HPSIM will just communicate with the Database Server.

The standard MSDE tool certainly doesn't permit moving databases.

Re: How do you move the MSDE Database?

Lenny Davis — Tue, 31 Aug 2004 02:55:26 GMT

We really only need to move the database onto the D: drive which has 16G or so free whereas the C: drive where the SIM installatioin is only has 1.5G free. Guess I need to find that SQL Admn tool then.

Thanks

Lenny

Re: How do you move the MSDE Database?

Rob Buxton — Tue, 31 Aug 2004 16:05:07 GMT

Lenny,

If you have MS SQL Server anywhere you'll have the SQL Enterprise Manager Tool.
You'd need to Register the Server that has the MSDE Database. Then Stop and disconnect the database. Copy the DB and Log files to D: and then reconnect it.
You'll probably not be able to move the Master and other files but you should be able to move the Insight Manager Database files.

Probably a good idea to shutdown HPSIM while you're doing it!

Re: How do you move the MSDE Database?

Lenny Davis — Fri, 03 Sep 2004 09:18:56 GMT

Thanks. I'll give it a go in a coupe of weeks as I'm away for a while.

Lenny