Re: point in time restore

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Gregory A. Larsen (greg.larsen_at_netzero.com)
Date: 09/28/04 

Date: Tue, 28 Sep 2004 06:28:48 -0700

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.
>
>
>

Relevant Pages

  • Re: Restoring from non-truncated transaction log
    ... The transaction log is there to support transactional consistency as well ... as supporting "incremental" backup. ... A database backup contains both data pages as well as the necessary log records (from the ... When your restore a database backup, ...
    (microsoft.public.sqlserver.server)
  • RE: Recovering Documents
    ... the blob. ... This is the only database I have that uses a blob field so I'me not ... If you're trying to get where you can restore just part of a document your ... > are wondering if transaction log will capture the information and be of use ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: Backend Exchange migrate to New Hardware (Server)
    ... Exchange mailbox stores and Exchange public folder stores. ... When you use Backup to restore Exchange databases, ... Storage Engine to restore Exchange database files and their ...
    (microsoft.public.exchange.setup)
  • Re: Restoring from non-truncated transaction log
    ... > That restore overwrites everything inside the database. ... This of a restore like applying a VM Ware image on a machine. ... When the restore was done it wasn't restoring the transaction log. ... > Are you saying that you saved something, somehow (backup, detach) before that restore was performed? ...
    (microsoft.public.sqlserver.server)
  • Backup and Restore Files
    ... What is the best way to backup and restore a runtime database file? ... pszDisplayName As String ...
    (microsoft.public.access.gettingstarted)