August 3, 2007 at 11:04 am
Hi to every one,
I have a case to recover database.
case: i have a database HR. In HR database i have 3 file groups like HR_group1,HR_group2,HR_group3. in HR_group1 i have 2 .ndf files. in that two file(hrgp1.ndf,hrgp2.ndf) one data page is corrupted in one hrgp1.ndf. how do i recover to only that data page.
simply one data page is corrupted in one ndf file.i found it at 11:30 am. how do i recover that data page.
i have backup of full backup on (saturday) every day diff backup
every one hour log backup
my questions are:
is it possible to recover database?if yes,then how to do it?
can i do recovery while database is running.
(means take ndf offline and perform recovey).
August 6, 2007 at 4:19 am
1. Did you try to fix it with DBCC CHECKDB with REPAIR_REBUILD option. Please read the recommendation to run a dbcc checkdb from BOL.
2. If this does not solve only one option left restore the full backup and apply the other diff backup till the date the page was fine.
Minaz
"More Green More Oxygen !! Plant a tree today"
August 6, 2007 at 9:43 pm
In SQL Server 2005, you have the option to perform page-level restores. See Performing Page Restores in SQL Server 2005 Books Online for details.
SQL BAK Explorer - read SQL Server backup file details without SQL Server.
Supports backup files created with SQL Server 2005 up to SQL Server 2017.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply