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

differential restore Expand / Collapse
Author
Message
Posted Monday, April 28, 2008 6:09 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Wednesday, September 8, 2010 5:23 AM
Points: 81, Visits: 189
hi friends :O)
i wanna restore my backaup file differentially.
i know this TSQL:
RESTORE DATABASE TestDB
FROM DISK = 'C:\backup'

but it restore DB normally !how can i do it with TSQL ?
Thank for your notation
Post #491317
Posted Monday, April 28, 2008 6:24 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: 2 days ago @ 9:27 AM
Points: 5,364, Visits: 9,867
First of all, you need already to have a full backup and a differential backup of your database. If you do, then restore from the full backup with no recovery, then restore the differential backup with recovery. Books Online has the full syntax together with some good examples.

John
Post #491324
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse