Forum Discussion

Mark_M's avatar
Mark_M
Level 4
21 years ago

restored sql database from Host A to Host B

I have restored a database sql with script command from HOST a to HOST B (create a move template).
The restore is ok and veritas put the file .mdf and .ldf in the position that I have choosed (E:\DATA\MSSQL\DATA where there are already some database sql).
The problem is that, when I open 'enterprise manager' in the HOST B i look my database restored with the label 'loading' and database is not yellow (as all others) but is grey.
Is it normally?

I have: veritas netbackup 5.0 MP3 (master server) with win 2000 server as OS.

thanks

Andrew

2 Replies

  • You have to select the status "Recovered" in the SQL GUI. Then it will be yellow again. It seems you have selected the status "Not recoved" before you changed the script.

    Best Regards

    Martin

    ------------------------------------------------------------------------
    http://www.netbackup-usergroup.de.vu
  • Thank's Martin.

    With your suggestion. I have resolved my problem.

    Andrew