I am trying to restore a database from backup (Veritas)
The backup says it is restored successfully, but ....
in enterprise manager the database reads 'Data(loading)'
I tried two different distination names
two different sources.
With the same result.
I tried EXEC sp_delete_backuphistory '07/16/04'
based on something I found on the internet.
I am using SQL2000
Does anybody have any ideas?
Perhaps the Veritas software did not run recovery as the final step? This
will leave your db marked as loading, but you can run recovery manually.
RESTORE LOG mydb WITH RECOVERY
HTH
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"arniecds" <arniecds@.discussions.microsoft.com> wrote in message
news:113E17E0-6F53-4D9A-809F-F303063CC2F0@.microsoft.com...
> I am trying to restore a database from backup (Veritas)
> The backup says it is restored successfully, but ....
> in enterprise manager the database reads 'Data(loading)'
> I tried two different distination names
> two different sources.
> With the same result.
> I tried EXEC sp_delete_backuphistory '07/16/04'
> based on something I found on the internet.
> I am using SQL2000
> Does anybody have any ideas?
>
No comments:
Post a Comment