Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
bogey
Posting Yak Master
166 Posts |
Posted - 2008-10-02 : 22:35:34
|
I'd appreciate any feedback that the group members could provide me. One of the groups we support purchased a document management system for a considerable amount of money. The system stores the doc's outside the database e.g. file system. Because of this the database and file system could be out of sync if something happens in the file system or we lose a record in the database.If I'm doing full backups nightly and transaction backups hourly. For the file system to be in sync as best as it possibly could you would have to have the file system mirror what I'm doing as far as backups are concerned.Our "Network" fellows told me that's impossible to do and the best solution is to take one backup a night and no transaction log backups hourly. Live with loosing a days worth of work.If anyone out there has a document management system running or has knowlege of the correct procedures to run I'd appreciate your insight as to how "you" do it or know how to do it.thanks. |
|
|
|
|