OK i'm going mad, i'm doing some testing and want to restore a full Marked
Transaction Backup of the Biztalk server to a clean database on a new
server.
using the article on msdn
http://msdn2.microsoft.com/en-us/library/aa546753.aspx
"How to Restore
Your
Databases"
there is reference to BTS Log ****pping Jobs as shown below, but i'm unable
to locate these jobs anywhere on my two testing Servers so does anyone
know
where this comes from?
a.. On the computer or computers you have identified as the destination
system, click Start, click Programs, click Microsoft SQL Server, and then
click Enterprise Manager.
a.. Open the appropriate server by clicking it. Double-click Management,
double-click SQL Server Agent, and then click Jobs.
a.. In the details pane, right-click BTS Log ****pping - Get Backup
History,
and then click Disable Job.
a.. In the details pane, right-click BTS Log ****pping - Restore Databases,
and then click Disable Job.
a.. In the details pane, right-click BTS Log ****pping - Restore To Mark,
and
then click Start Job.
SQL Server Agent jobs and BizTalk Server databases are restored to the
destination system.
a.. On the computer running BizTalk Server 2006, where you edited the
SampleUpdateInfo.xml file, open a command prompt. Click Start, click Run,
type cmd and then click OK.


|