It's a built-in BizTalk job which uses the below stored procedure to backup the databases from all of the 3 instances.

USE [BizTalkMgmtDb]

GO

/****** Object: StoredProcedure [dbo].[sp_BackupAllFull_Schedule] Script...

The database is backing up to local disk (clustered disk) only. But the job step requires the backup path should be in the format of network share.

Jon step:exec [dbo].[sp_BackupAllFull_Schedule] 'd'...

We are analyzing Blocking and MS recommended to enable Verbose logging and I did NOT find any option for that?

So I just wondering whether we have that option in Database...

It's in the NSService.exe.config under sql server installation folder under notificationservices folder

For each of the items in the <switches> node, set the logging level by changing the value attribute.

To apply...

But in my case, I need to create 3 maintenance plan task to...

Thank you Perry,

We have SQL Server 2005 with SP3

hi s.k

Could you please share your monitoring scripts for mission critical servers and from where they scheduled?

thanks

Thank you,

I ran the below query to schedule the job Test_Backup to run at 11:45 AM.

USE msdb

EXEC sp_add_jobschedule @job_name = 'Test_Backup',

@name = 'Full',

...

Hi,

I have performed the steps from 1 to 6 successfully. But I did not understand how to do step 7, Map Oracle database to SQL Server database schemas.

Could you advice...

Thank you,

I have downloaded the latest version of SSMA Microsoft SQL Server Migration Assistant for Oracle v4.2 (I believe this is the latest version) from the below link.

http://www.microsoft.com/downloads/en/details.aspx?FamilyID=9dfb1773-5594-44a9-869f-a891629f80a5&displaylang=en

Here, we...

What is the latest version of SSMA?

We are migrating Oracle 11g database to SQL Server 2008 R2. So which version of SSMA works best for us

Thanks for your help

Thanks,

So if we Use SSMA, then there is NO need to use SSIS?

I discussed...

I'm sorry!!!

My question is wrong. Actually, I'm trying to restore a SQL Server 2008 database backup into a SQL Server 2005 instance and getting the error above mentioned. Is restoring...

Currently, we do not have a problem with blocking. It occurs once in while and we are getting alarms for them using 3 rd party tool.

But on development and QA,...

I'm working on it parallelly and I post once I have working script. Thanks