Dear All,
I was reading the SQL Online help and doing practical work also as written Restorign a database to a prior state title i did all the steps as per Online SQL Server books Online..but I Failed to achive the result
Pl. look what i did
I took the database backup and log file backup at 1 pm as
backup database tt to disk='c:\bkup\bk1'
backup log tt to disk='c:\bkup\tlog1'
now I changed some tables and then took the transaction log backup on 1:15pm as
backup log tt to disk='c:\bkup\tlog2' with no_truncate
no i deletd tt database and tried to restore database as
restore database tt from disk='c:\bkup\bk1' with norecovery
go
restore log tt from disk='c:\bkup\tlog1' with norecovery
go
restore log tt from disk='c:\bkup\tlog2' with Recovery
SO As per Help I should get my actual database but I got the following message
Processed 1 pages for database 'tt', file 'tt_log' on file 1.
RESTORE DATABASE successfully processed 121 pages in 0.444 seconds (2.216 MB/sec).
Processed 1 pages for database 'tt', file 'tt_log' on file 1.
RESTORE LOG successfully processed 1 pages in 0.004 seconds (0.640 MB/sec).
Server: Msg 4305, Level 16, State 1, Line 1
The log in this backup set begins at LSN 6000000121100001, which is too late to apply to the database. An earlier log backup that includes LSN 6000000120500001 can be restored.
Server: Msg 3013, Level 16, State 1, Line 1
RESTORE LOG is terminating abnormally.
So pl. Suggest the solution( I am still learning )
regards
inder
I was reading the SQL Online help and doing practical work also as written Restorign a database to a prior state title i did all the steps as per Online SQL Server books Online..but I Failed to achive the result
Pl. look what i did
I took the database backup and log file backup at 1 pm as
backup database tt to disk='c:\bkup\bk1'
backup log tt to disk='c:\bkup\tlog1'
now I changed some tables and then took the transaction log backup on 1:15pm as
backup log tt to disk='c:\bkup\tlog2' with no_truncate
no i deletd tt database and tried to restore database as
restore database tt from disk='c:\bkup\bk1' with norecovery
go
restore log tt from disk='c:\bkup\tlog1' with norecovery
go
restore log tt from disk='c:\bkup\tlog2' with Recovery
SO As per Help I should get my actual database but I got the following message
Processed 1 pages for database 'tt', file 'tt_log' on file 1.
RESTORE DATABASE successfully processed 121 pages in 0.444 seconds (2.216 MB/sec).
Processed 1 pages for database 'tt', file 'tt_log' on file 1.
RESTORE LOG successfully processed 1 pages in 0.004 seconds (0.640 MB/sec).
Server: Msg 4305, Level 16, State 1, Line 1
The log in this backup set begins at LSN 6000000121100001, which is too late to apply to the database. An earlier log backup that includes LSN 6000000120500001 can be restored.
Server: Msg 3013, Level 16, State 1, Line 1
RESTORE LOG is terminating abnormally.
So pl. Suggest the solution( I am still learning )
regards
inder