January 5, 2012 at 9:22 pm
create database FRIDAY
on primary
(name = FRI1,
filename = 'C:\test\test1.mdf'),
(name = FRI2,
filename = 'C:\test\test2.ndf'),
filegroup group2
(name = FRI3,
filename = 'C:\test\test3.ndf'),
(name = FRI4,
filename = 'C:\test\test4.ndf')
log on
(name = FRI_LOG,
filename = 'C:\test\test_log.ldf')
alter database FRIDAY set recovery full
use FRIDAY
GO
create table T1 (id int, name char(10))
insert into T1 values (100, 'sudesh')
go
create table T2 (id int, address char(10))
insert into T2 values (100, 'Gorgea')
use master
go
backup database friday
filegroup = 'group2'
to disk = 'C:\File_FG_BKP\group2_full.bak'
with init
drop table T2
backup LOG friday
to disk = 'C:\File_FG_BKP\fri_table_log.trn'
with init
create table T2 (id int, address char(10))
insert into T2 values (100, 'Gorgea')
backup LOG friday
to disk = 'C:\File_FG_BKP\fri_table_later.trn'
with init
backup LOG friday
to disk = 'C:\File_FG_BKP\fri_table_later1.trn'
with norecovery
-----------------------------------------------------
restore headeronly from disk = 'C:\File_FG_BKP\fri_table_log.trn'
-- backup finishdate : 2012-01-06 09:48:57.000
restore database friday
filegroup = 'group2'
from disk = 'C:\File_FG_BKP\group2_full.bak'
with norecovery, replace
restore LOG friday
from disk = 'C:\File_FG_BKP\fri_table_log.trn'
--with recovery
with recovery, stopat = '2012-01-06 09:33:39.000';
what's the error in it?
KINDLY ASSIST ..
Receiving the below error message -
Processed 8 pages for database 'friday', file 'FRI3' on file 1.
Processed 8 pages for database 'friday', file 'FRI4' on file 1.
Processed 6 pages for database 'friday', file 'FRI_LOG' on file 1.
RESTORE DATABASE ... FILE=<name> successfully processed 22 pages in 0.076 seconds (2.197 MB/sec).
Processed 0 pages for database 'friday', file 'FRI3' on file 1.
Processed 0 pages for database 'friday', file 'FRI4' on file 1.
Processed 6 pages for database 'friday', file 'FRI_LOG' on file 1.
This backup set contains records that were logged before the designated point in time. The database is being left in the restoring state so that more roll forward can be performed.
RESTORE LOG successfully processed 6 pages in 0.033 seconds (1.316 MB/sec).
Thanks.
January 8, 2012 at 4:52 am
It doesn’t look like an error. Do you have any procedure to crosscheck the restored data? If yes, please verify the restored data. IMO, it’s a clean point-in-time restore.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply