Help with SQL Server 2000 database restore

[vivek_vdc]

Hi all,



We tried to restore our database from a full backup. Although the TDP says the restore has completed, EM shows that the database is in Loading state.



We need to restore only the full backup, no diff's or logs to be applied.



We need to restore a full backup that is in Inactive State.



Restore Tab Options -

Backup Type - FULL

State - Inactive



Restore Options

View - Show Active and Inactive: Checked

Stipes - 1

Recovery - Checked (I think this box is the problem...we need to uncheck it, am I right?)

Replace - Unchecked (The database is deleted. So there is no question of a Replace)

Wait for Tape Mounts for Restore - Checked

Wait for Tape Mounts for File Information - Checked



Please provide me with the correct Restore Options that would resolve the loading state in EM.





Thanks,



Vivek

 

[CBell]

Yes, I'm thinking uncheck Recovery. But don't hold me to it!