Database Reference
In-Depth Information
if you are restoring a 100 GB database, you will need at least 200 GB to continue
using the existing database while it is being restored.
If you host multiple databases on the same instance, you can run multiple
backup
/
restore
commands in parallel. However, you cannot process or make any
structural changes to the database being backed up since doing so will cause the
backup
command to fail.
Tip
Sadly, Microsoft does not provide any
DBCC
commands to check backup con-
sistency. The only way to verify the validity of your backup is to actually restore
from it. A reasonable practice is to have an automated job that restores produc-
tion database backups to a test (standby) instance. Contrary to popular belief,
SSAS databases can indeed get corrupted for various reasons. So, having mul-
tiple copies of the database and valid backups is highly prudent.
Search WWH ::
Custom Search