SQL 2005 Restore
Hello,
Yesterday at 1400 I started a restore of a very small database. It is now 0745 on the next day and it is still in the RESTORING state. It can't take this long. Does anyone know what I can do??? I need to get this database back up, even if it is the version before the restore.
Any help ASAP would be appreciated!!
Thanks so much.
Software/Hardware used:
Software/Hardware used:
ASKED:
January 24, 2007 9:43 AM
UPDATED:
January 26, 2007 9:41 AM
RELATED QUESTIONS
- How do you restore and recover RMAN incremental backup on a new Host in different HDD partition?
- Reducing SQL Server backup and restore time
- How do I restore my SQL .bak file over the existing database?
- SQL Server 2008 Restore Fails - There is insufficient system memory in resource pool 'internal' to run this query
- Restore SQL Server 2008 database backup error specified cast is not valid
Answer Wiki:
Did you set the restore to have RECOVERY option? Without that your database won't be available for use after restore.
What's the output like (any error message) for the restore job?
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
