June 3, 2006 at 12:16 pm
Greetings,
Please help me to resolve problem with restoring DB in v8.0:
my backup file is more then 2GB,
restoration wizard produces successful result, however DB is in 'loading' mode for almost 12 hours.
Appreciate any suggestions.
Thanks,
Vik
June 4, 2006 at 9:50 am
If it shows as still loading it sounds like you chose to leave the database in non-operational state in the wizard so the database will not have performed the recovery process as it is in a state where further backups can be applied to it e.g. transaction log backups
Anyway if the above is the case executing something like swhat below will force it to perform the recovery portion of the retsore operation and bring it on-line
RESTORE DATABASE MyDatabaseName
WITH RECOVERY
hth
David
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy