Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

File group backup Expand / Collapse
Author
Message
Posted Thursday, August 13, 2009 3:03 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Thursday, August 14, 2014 1:36 AM
Points: 241, Visits: 1,196
Hi Every body,

In my database 3 file group is there, every day we will take t-log every one hour to day at 11:30 2nd file group was corrputed

How can i restore can any body suggest me

Regards
Raj
Post #769991
Posted Thursday, August 13, 2009 2:19 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, September 24, 2013 2:59 AM
Points: 174, Visits: 336
Have you got a full backup?
Post #770486
Posted Thursday, August 13, 2009 6:58 PM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Yesterday @ 11:47 PM
Points: 3,135, Visits: 11,481
Restore the database from the last full backup using the NORECOVRY option, and then apply the transaction logs to roll forward to the point in time that you want to recover to.

Post #770611
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse