While backing up your BizTalk databases, you should also back up the master and msdb databases. These contain valuable operational and historical information regarding all databases that run under the same SQL server. It will save you a great deal of time if you do not have to rebuild these databases.

If a disk pack now ceases to exist, do not panic. Check to see if the SQL server is still running, using the Enterprise Manager. If so, you can still back up the open transaction log, which saves all finished transaction since the last backup of the transaction log. The only transactions you lose are the ones that were not committed when the failure took place.

The backups you make to disk should be done to the storage of another server.What is the point in making a backup if you put it on the same disk on which your database is residing? If the disk fails, your backup files will disappear with it. Restoring the database is a reverse process:

1. Restore the full backup.

2. Restore all the incremental backups since the last full backup.

3. Replay all the transaction logs since the last incremental backup.

Was this article helpful?

0 0

Post a comment