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

Backup database with file references. Expand / Collapse
Author
Message
Posted Tuesday, March 25, 2014 2:44 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, June 4, 2014 1:50 AM
Points: 4, Visits: 30
Hi,

we have database with a references to files (for a big data, one row referenced to files of data size of over 100MB). We are looking for solution to full backup without blocking application, it will be work in backgroud. How to synchronize database backup with a referenced files. The user can add/modify/delete record in between times. Someone knows any solution for this problem?
Post #1554320
Posted Tuesday, March 25, 2014 3:48 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, July 21, 2014 2:56 AM
Points: 2,603, Visits: 2,061
How about using FILESTREAM?

---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
Post #1554336
Posted Tuesday, March 25, 2014 4:37 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, June 4, 2014 1:50 AM
Points: 4, Visits: 30
It is for existing solution, we have file path in the table, we don't use FILESTREAM data type, unfortunately.
Post #1554361
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse