How to: Force a full backup in SQL server management studio
BizTalk MgmtDb : Configuratie database
BizTalk Msgbox DB: Messagebox
BizTalkDTADb: Tracking database
Right click the database, new query;
EXEC sp_ForceFullBackup
Next time the backup job starts, a full back up is forced. If you want to start the back up immediatly, go to the job agent and choose "start job at step".
Open Job Activity monitor to check the status.
To view the results: Right click on the Backup BizTalk Server job and choose "view history" to find out if the job has done it's work.
By opening the job and viewing the command line of BackupFull to find out where the backups are created.
Modify Backup: Set specific time: Go to jobs, backup, steps, backup full.
You can set a time parameter (look up the position/name etc. in the stored procedure)
You can set a time parameter (look up the position/name etc. in the stored procedure)
Maak jouw eigen website met JouwWeb