Tuesday, March 20, 2012

Data recovery problems

I restored a backup and latest trasnsactions files for one
of my db (hrMasterData), now I have a messages that says
HrMasterData (loading).
It is a long time I am waiting for, what is happening, and
what can I do?If you restored all your transaction log files already, maybe you just
forgot to use the WITH RECOVERY in your last tlog. Use the following command
to solve this problem:
RESTORE DATABASE dbname WITH RECOVERY
Carlos E. Rojas
SQL Server MVP
Co-Author SQL Server 2000 programming by Example
"FREDY COREA" <anonymous@.discussions.microsoft.com> wrote in message
news:105bb01c40df9$d8bd9f20$a401280a@.phx
.gbl...
> I restored a backup and latest trasnsactions files for one
> of my db (hrMasterData), now I have a messages that says
> HrMasterData (loading).
> It is a long time I am waiting for, what is happening, and
> what can I do?
>

No comments:

Post a Comment