Hi,

Iam stuck in testing the restore scenarios. I need to generate the scenarios in developement and document. If anybody have some info on this plz help me

Thanks Todd,

node 3 is the preferred owner for INS2, INS3, and INS4 in Cluster administrator, and the failback option enabled.

But onething I observed that the Clustergroup has NO prefered owners...

Thank You,

We do not want to install the report server on any of the production servers. In that case I need to install the database engine along with reporting...

Thank You

what exactly meant by tail backups..is there any separate commands to take tail backups other than backup log db_name

when should we take the tail backups?

thank you...

Thank You,

Here is the scenario. Biztalk databases are spread across multiple sql server 2005(3 instances)

sql server instances

1.Msg

2.track

3.data

In all 3 instances BTSadmin has given sysadmin role while installation. So now we...

Yeah Lynn,

Thanks..Its worked. but small change..adding the square brackets to 2nd line, it worked..

ALTER DATABASE [SharePoint_AdminContent_1f7d4d63-662f-4180-a6b9-7d4b35b27435]

MODIFY FILE ( NAME = [ SharePoint_AdminContent_1f7d4d63-662f-4180-a6b9-7d4b35b27435_Log],

...

Hi Steve,

there are no users connected to that database. When I ran sp_who2 it showing the logins are in sleeping mode. and when Iam trying to put the database in...

Hi,

Iam also run into the same issue. can anybody give some ideas.

Hi,

Iam able to get some error message in email when the job succeeded/failed like

'The job succeeded. The Job was invoked by User ABC\sqladmin. The last step to...

Hi,

We are using the following method to send emails.

http://support.microsoft.com/kb/312839

In that CREATE PROCEDURE [dbo].[sp_send_cdosysmail]

@From varchar(100) ,

@To varchar(100) ,

...

hi,

The stored procedure 'msdb.dbo.sp_send_dbmail' is not exist in sql server 2000? So which procedure can we use instaed of that?

Thanks

Hello bhuvnesh,

I know its too frustating to ask the same question several times...

sorry to again ask you the same questions. I came in the middle of the project. The previous...

Hello bhuvnesh,

could you plz help me out..it a bit urjent

Thanks

Thank You bhuvnesh,

Where exactly I need to put this script. like as a job step or inside the procedure Failure_Notification'

What Iam guessing is I need to add the script...