Friday, March 23, 2012

point in time restore

hello everybody
i just tried to do the exercise of point in time restore with northwind
database.
First i took a complete database backup of northwind
then after 10 min i took a transaction log backup of northwind
now when i try to restore the northwind database
while restoring i get this erros as
"invalid value specified for stopat parameter, restore log is terminating
abnormally
also now my northwind database is showing as loading & nothing inside this
database is showing
can anyone please suggest where i'm wrong & what needs to be taken care
about while doing point in time restore.Hi
Post the T-SQL code you used to do the restore.
Regards
Mike
"vishal" wrote:
> hello everybody
> i just tried to do the exercise of point in time restore with northwind
> database.
> First i took a complete database backup of northwind
> then after 10 min i took a transaction log backup of northwind
> now when i try to restore the northwind database
> while restoring i get this erros as
> "invalid value specified for stopat parameter, restore log is terminating
> abnormally
> also now my northwind database is showing as loading & nothing inside this
> database is showing
> can anyone please suggest where i'm wrong & what needs to be taken care
> about while doing point in time restore.
>
>

No comments:

Post a Comment