|
|
Posted by KR on 05/17/06 18:48
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
Navigation:
[Reply to this message]
|