cancel
Showing results for 
Search instead for 
Did you mean: 

What time does a database created with BACKUP DATABASE begin?

Former Member
1,766

We use Sybase Anywhere 10 and schedule backups to take place using an event with: BACKUP DATABASE DIRECTORY 'D:\\BACKUP' TRANSACTION LOG TRUNCATE WAIT AFTER END

At what point does the database get 'frozen' when creating the backup .db/.log?

For example if we trigger the backup at 00:00 and it takes 45 minutes to finish does the backup db/log contain everything up to 00:00 or 00:45? We have had various results when testing this and would like a more definitive answer.

We would like these backups to contain all transactions up to midnight since we use these backups to form our monthly financial databases for reporting so having extra transactions after midnight can cause balancing issues.

Thanks

Accepted Solutions (1)

Accepted Solutions (1)

johnsmirnios
Advisor
Advisor

The database file will be as of the start of the backup and the log will be as of the end of the backup. To get the database to be up-to-date as of the end of the backup, you must apply the log (using -a or similar switch) to the database file.

If you want to use a copy of the database file as it existed at the start of the backup, take a copy of the backup database file, move the log file out of the way (so that the database cannot access it -- or use dblog -t to change the log name) then start the database with '-f'. The server will start then shut itself down again. You can then start it again without '-f'. Note that once you do this sort of thing to a backup database file, it can no longer be used to restore your database in the event of a failure so be sure to use a copy of the backup database file.

Former Member
0 Kudos

Thanks for the speedy reply, this is exactly what I was looking for.

We are only looking to use these databases without the transaction log for static reporting only databases for weekly/monthly/yearly reporting.

Answers (0)