I have a question about SSAS2005 backups.

If a backup is initiated at 2:00AM and finishes at 4:15AM, when is the
backup current as of? Going under the assumption that processing (new
partitions) and dimensional updates are going on at the same time of the
backup.

Thanks!

Backup takes a read-lock on objects in the database. So processing etc. will
be blocked from committing until the backup is completed. The backup
contents will be based on the state when it acquired the locks at the
beginning...

Thanks,
Akshai
--
Try out the MSDN Forums for Analysis Services at:
http://forums.microsoft.com/MSDN/Sho...ID=83&SiteID=1

This posting is provided "AS IS" with no warranties, and confers no rights
Please do not send email directly to this alias. This alias is for newsgroup
purposes only.

"Jesse O." <jesperzz (AT) hotmail (DOT) com> wrote