No server list after database migration

[Raymond Kim]

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?

[Bart_Heungens_1]

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...

[Raymond Kim]

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.

[Raymond Kim]

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!

[Raymond Kim]

close thread