Perry Whittle (11/5/2014)

---

Parthipan-244146 (11/5/2014)

---

As i understand it you only have SQL Server backups of the databases, does this include system databases (master, model, mdsb)?

Will you be presenting new shared storage...

Thanks for the reference.

My main concern is that 'remote access' configuration is mandatory for applying replication transactions on the remote server?

We have security concern in enabling remote access configuration. Will...

Please check with exchange admin that SQL server IP has mail relay permission on SMTP exchange server.

Also you can verify login used for database mail profile creation has 'DatabaseMailUserRole'...

Hi John,

Sorry for the confusion..

I am learning on how to create error event handler in SSIS package.

Thanks for your support.

BR,

Parthi

Hi John,

Thanks for pointing the possibility of ignoring the error.

I did nt include any error event handler in this package.

I will learn more about this, and should i include all...

Hi All,

Apologies for late sorry and Thank you for your valuable information.

It seems migrating SQL database to new SAN involves less complexity than moving Quorum data as it contains disk...

Hi All,

Thanks a lot for your technical suggestion and information...

But what should I do for the below situation

* Take the complete image or backup of the server A that has...

How to execute these procedures if SQL server was already down,

sp_dropserver 'old server name'

sp_addserver 'new server name', 'local'

as per http://support.microsoft.com/kb/303774/en-us

BR,

Parthi

This is normal behaviour.

Only SQL database engine & analysis services are cluster aware SQL component i.e means the related data files is installed on shared drive and binary files is...

Sorry experts I solved the problem by

select Category, count(*) as TotalNumber from

(select

Case

when ITPolicyName is NULL then 'No Policy Assigned'

ELSE ITPolicyName

END as Category

from table1) as Temp

group by Category

order...

Chandu,

Can you share with us your script for automated unattended installation?

BR,

Parthipan.S

DNA

I have a doubt

=================

I'd say the best thing to do is download the service pack and carefully read the installation instructions! We've done several service packs on clusters and...

Hi Gianluca,

Thanks alot for technical information.

I will try from my side..

BR,

Parthi

No..SQL server service dont run in the passive node...

But windows cluster service always run on every member cluster node...

When the SQL cluster group failover to the passive node and becomes...

Gail Shaw,

Thanks alot for your information and suggestion..

Cheers,

Parthi