topic Re: No server list after database migration in Server Management - Systems Insight Manager

No server list after database migration

Raymond Kim — Wed, 11 May 2005 07:51:37 GMT

HELP!!!

Last night, we migrated our SQL Server databases (including the HPSIM DB) onto a SAN/NAS. When I tried logging into HPSIM last night, it seemed to be working fine. When I tried it this morning, no entries came up in the list -- HPSIM seems to be working, but it's like it didn't find anything in the DB.

I ran a manual query on the DB (through Query Manager), and the data is all still there.

Anyone have any ideas?

Re: No server list after database migration

Bart_Heungens_1 — Wed, 11 May 2005 08:28:29 GMT

Did U check in ODBC Database Administrator that the connection to the database is correct pointing to the new SQL server with eventual instance correctly mentioned? U can do a check over there for correct DB connectivity...

Re: No server list after database migration

Raymond Kim — Wed, 11 May 2005 08:35:46 GMT

This doesn't help. The SQL Server name did NOT change; the only thing that changed was the location of the database files. They are now on a different drive designation.

Re: No server list after database migration

Raymond Kim — Wed, 11 May 2005 09:36:19 GMT

For anyone who comes across this and is looking for the answer . . .

Turned out the transaction log had filled. Apparently a setting had been missed when the DB files were moved over to the new location. Oops . . .

HPSIM is now back up and happy again!

Re: No server list after database migration

Raymond Kim — Wed, 11 May 2005 09:37:41 GMT

close thread