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

Database file backup Expand / Collapse
Author
Message
Posted Wednesday, November 20, 2013 6:43 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, July 16, 2014 12:02 PM
Points: 46, Visits: 519
Currently have a database with two files, PRIMARY and FILESTEAM. We only want to backup the PRIMARY file. What is the proper way to backup the log file after the PRIMARY file backup and what is the proper way to restore the PRIMARY file backup around with the restoring the concurrent log file backup?

Thanks in Advance
Post #1516030
Posted Thursday, November 21, 2013 11:18 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Today @ 11:27 AM
Points: 238, Visits: 434
Well, you will want to back up the FILESTREAM data as well at some point. While I have not tried it, I suspect you will get a lot of errors about the FILESTREAm filegroup being out of sync with the PRIMARY file group. You can do a filegroup specific backup. Generally, when you restore you need to apply transaction logs until all of the filegroups are at the same LSN.
Post #1516531
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse