Post reply

Using BLOB

  • May 17, 2006 at 9:09 am

    #168303

    Hi,

    One of our third-party software vendors is planning to implement BLOB in their database for storing certain documents.  We are not too thrilled about it, since it can be a drain on our resources, but I would like to get the expert opinion out there on the pros and cons of implementing this.

    Also, the database is in Full recovery mode and we back up the transaction log every 15 minutes.  We also do a process similar to log shipping.  We have two servers to which these transaction logs are restored to periodically.  What will the impact on the transaction logs due to changes to the BLOB fields.

    If you could also point me to any resources that talks in detail about performance, backup and recovery in relation to BLOB that would be great.

     

    Thanks in advance

    KR

  • May 17, 2006 at 3:15 pm

    #638571

    Here is a resource:

    SQL Server 2000 Resource Kit - Chapter 11: Using Blobs

    K. Brian Kelley
    @kbriankelley

  • May 18, 2006 at 8:02 am

    #638728

    Take a look at Forums Home » Programming » General » Binary data pros/cons.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply