|
Posted by KR on 05/18/06 17:03
Where we store these documents are not under our control - the
application is designed by a third-party. So we have to go with their
decision - what we are trying to do is to analyze any problems that
may present due to this and devise a solution or go to the software
vendor with recommendations.
The documents in the file system are backed up separatley from the
database. We cannot do Log shipping on our databases since we have SQL
Standard edition. We backup our transaction logs periodically to a
network 'store' and restore the transaction logs periodically on the
two standby server using a stored procedure.
What we are also concerned here is the possible effect on the size of
transaction log due to updates and inserts on these BLOB fields, the
backup and restore time.
Navigation:
[Reply to this message]
|