Thanks

How should I use in my code...if I am doing automated Restoration.

Like Kill the processes used by Restoration DB and then restore it

Kill Process how do I know which login ID I need to KILL before resotoring automatically through job.

Thanks all for your valuable information.

What about Snapshot is it worth using that, how does it work? I need this basically for reporting purpose that to on same server. I...

Thanks Alex,

Yes I am using the Virtual IP address seperate from NODEA and NODEB.

So I can use it the same hearbeat IP? or do you want me to use the...

Sorry I got this error below when I did run AS USER Demon\App_login then password

---------------------------

C:\Program Files\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE\SqlWb.exe

---------------------------

C:\Program Files\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE\SqlWb.exe

The directory name is invalid.

---------------------------

OK

---------------------------

Thanks

That solve my problem

Nita:D

The AD account was created

I went to SQL server and through Management studio I went to Security and created a New Login through which was already created through Windows...

How about log shipping or mirroring is that the alternate choice for Clustering

As I said only 8% grow in a year and only 200 per transaction per day

Do you think spending this much money is worth for clustering...or use log shipping or...

It is been called by java application and looks like the developer has open 15 pools. Now he want to leave the pool open. Is there any way I can...

Thanks for your reply, this is occuring suddely it was not happen so far.

When I do sp who2

In Hostname I am getting sms.corp.com

In programName I see blank

DBName SMS

I don't think you can attach/deattach for System Database?

Thanks

Nita

You are the King yes it is used in that SP which is called by that DTS.

EXEC @Details = sp_OACreate 'SQLDMO.SQLServer', @ids OUT

Now what should I do to...