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 8, 2012 4:33 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Sunday, April 27, 2014 7:55 PM
Points: 218, Visits: 556
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