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

DB backup/restore without filestream Expand / Collapse
Author
Message
Posted Thursday, November 08, 2012 4:33 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, April 02, 2014 9:12 PM
Points: 215, Visits: 542
Dear All

I have DB with Filestream. Recovery model for this is set to FULL.

I need to backup only primary group. No need of backing up filestream folder as it will be taken care by the filesystem back up.

I am taking backup using following command-
BACKUP DATABASE 'dbname ' FILEGROUP = 'PRIMARY' TO DISK = 'C:\xx.bk' WITH INIT, NAME= 'xx', NOSKIP, NOFORMAT

How do i do restore the primary group??


Thanks and Regards
Shilpa
Post #1382407
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse