February 18, 2005 at 12:56 am
When I am restoring the database production server, it’s restoring but still it's showing as loading. When I restore the same database in other server, it’s restoring properly.Working fine. What is the problem? Any body can tell the solution.
February 18, 2005 at 5:39 am
Have you given the database sufficient time to restore onto your production server. It's possible that the restore is simply taking longer than you'd like. I would also check you sql logs or event logs for a restore failure partway through the restore that may have left your database in loading.
February 18, 2005 at 10:04 am
When I restore the database other server .It's restored with in 20 min.But production server after 1 hour.It's showing status "loading".But message showing that restored successful.
February 19, 2005 at 12:51 pm
If you are sure, that you restored all backups (data and logs), try to run this command in Query Analyzer:
RESTORE DATABASE DB_NAME WITH RECOVERY
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply