1. SQL Server 2000 Point in time recovery
I performed a database restore using a full SQL database
backup and transaction logs to restore a test database to
a point in time.
After executing the restore, I received an error. I
reviewed the SQL server logs and there were a number of
log entries. The sequence of messages to the log were:
- starting up database 'BPT3'.
- bypassing recovery for database 'BPT3' because it is
marked IN LOAD.
- Database restored: Database: BPT3, creation date(time):
2001/08/28(13:05:13), first LSN: 3937:3933:1, last LSN:
3937:3938:1, number of dump devices: 1, device
information: (FILE=1, TYPE=DISK:
These messages were written to the log numerous times (for
each transaction log applied).
It looks like all the transaction logs where applied from
the restore. But I am a bite weary about what was reported
in the sql logs.
I checked MS site and this error is listed as a bug fixed
in SP2. Basically the bugs states that during a restore
if a transaction logs has zero entries (startlsn =
lastlsn), the database is opened and no additional logs
can be applied.
I was wondering if the messages I am seeing in the SQL
logs are informational; or is there a real problem?
Any comments would be great. Thanks...
2. System/4 (4GL) People?
3. SQL Server 7 point in time recovery
4. Student Programmer Needed for Summer Project
5. Point in time recovery: recreating relation files
6. EXISTS question
7. help on point in time recovery of a partition
8. Delphi, Delphi, and Delphi
9. Point-in-time recovery in a standby db ?
10. POINT IN TIME RECOVERY QUESTION
11. Point-in-Time Recovery on a Tablespace
12. Point in Time recovery
13. point-in-time recovery