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.
I'm guessing your format for specifying the stopat time was incorrect. Here
is a format that works:
STOPAT = 'Apr 15, 1998 12:00 AM'
What format did you use?
There reason your database is still loading is because your restore failed.
After you restored your full backup you probable specified norecovery, so
you could restore your transaction log. Then since your transaction log
failed SQL Server still thinks your transaction log backup needs to run
before anyone can get into the database. Hope this make sense.
----
-
Need SQL Server Examples check out my website
http://www.geocities.com/sqlserverexamples
"vishal" <compaq@.smil.co.in> wrote in message
news:OCRoVCUpEHA.3464@.TK2MSFTNGP14.phx.gbl...
> 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,
You are supposed to restore the backup in a new database, not with existing
database.
Steps to do the point in time restore :
1. Ensure that Northwind database is set to FULL Recovery model
2. Restore the FULL database backup with norecovery
3. Restore the transaction log backup one by one with NORECOVERY
4. Restore the last transaction log backup with RECOVERY and STOPAT option
See the below link
http://support.microsoft.com/?kbid=297468
Thanks
hari
MCDBA
"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.
>
>