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 |
|
Digital.Mind.1977
Starting Member
2 Posts |
 Posted - 2009-07-26 : 09:17:44
|
| We have a web application that stores files in a separate folder outside the database, we want to do real time backup (while the users are connected to the application). If we run a scheduled task to backup the database and then the files, then the database and files will be out of sync, because if the database backup takes 5 mins for instance, then we will be backing up the files that are related to some records that were not added to backup. What is the best way to do real time backup for database and external files so that we have them both in synch? |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2009-07-26 : 18:06:37
|
| schedule them to run at the same time |
 |
|
|
Digital.Mind.1977
Starting Member
2 Posts |
Posted - 2009-07-27 : 02:57:35
|
| Good idea, but even if we do this, how can we guarantee that during the backup that the database records and files are in synch? because the application will be used during the backup process? (example a user committed a record and a file, the record might be backed up but not the file). Also what tools can be used to trigger backing up the database and files at the same time? |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2009-07-27 : 10:02:20
|
| nothing can guarantee it except kicking users out of the application.that's one of the reasons for taking periodic transaction log backups.use a SQL Agent job to schedule both |
|
|
|
|
|
|
Backup database and external files