What will happen when we run Rebuild Indexes on Primary Database will it replicate it to Subscriber? or we need extra maintenance plan for Subscriber Database?

Just right click Database and select 'New Database...'

run this t-sql

select name, language from syslogins

check this:

ms-help://MS.SQLCC.v10/MS.SQLSVR.v10.en/s10de_4deptrbl/html/64b2a53d-4416-4a19-acc0-664a61b45348.htm

Not getting your problem 🙁

I guess you have connectivity issue. You can check the seting of TCP/IP & Port in SQL Server Configuration Manager.

Also if no. of members are more than you can create application role and grant permission to perticular role for easy and uniform administration. and assign the db user specific...

Ajay,

following link might help you:

http://www.sqlservercentral.com/About/AboutUs/

Cheers

Hello Vivien,

Ideal recomendation for cluster is 1 instance on one box i.e. in your environment two instance which will be active / active / passive. Which itself is good combination...

One more thing Mirroring is related to specific Database where Cluster is happening related to SQL Instance.

Also generally Cluster server & failover cluster server should be at the same...

Hello Elisabeth,

Thanks a lot for quick turn around. Your answer is perfect that's what I was looking for.

I have the same openion like you but customer make me confuse :w00t:....

You can refer the following site:

http://www.tech-archive.net/Archive/SQL-Server/microsoft.public.sqlserver.clustering/2007-02/msg00023.html

Try this link:

http://support.microsoft.com/default.aspx/kb/215340

In case, if you are changing fillfactor to lower digit surely mdf file will increase. e.g. current fillfactor is 0 or 100 and you define it to 80 surely mdf...

I guess you need to execute

RECONFIGURE [ WITH OVERRIDE ]

to take the effect and restart.

Also /3gb swithch itself notifies that initial pagefile size for sql database is 3 GB.

I fully agreed with FNS.

As I have experience the same thing in my environment. As soon as wintel teams reboot the server works fine and after while again sink. 🙁