from sql-server-performance article:

T

esting the Cluster Service

* Once the cluster is built, test it extensively before it goes into production. Test for the following:

...

post the exact error you are getting. Some one can help you.

1.Make sure the Distributed Transaction coodinator is running windows services (Start->Administrative tools->Services)

2.Enable remote connection on MSDTC as below:

Start->Administrative Tools->Component Services->Computer->Mycomputer->right click Mycomputer and select properties->goto MSDTC tab>security configuration->enablt network dtc...

Hi,

I resolved the issue as below:

1.Uninstall SQL server 2005 from node1.

2.Uninstall SQLXML4 from node1 and node2(if you do not uninstall sqlxml4 from both the nodes, the installation will fail)

3.reboot both...

Hi,

We have share point databases in sql server 2005 EE x64 and we do NOT have mirroing setup.

and No Index rebuilds and Integrity checks happening. But Still we are frequently...

I would like to know that how the dba's maintaing the share point databases doing the backups?

please advice

Yes, these are share point databases and we have log backups twice a day. It is in pre-production, later we will change the log backup schedule to every 1 hour.

This...

I think there will be some way to resolve this. Could you please explain me whats the best way I can approach to resolve the issue

Thanks,

As you saying may be I deleted the database without removing the log shipping configuration. Now I restarted the service and recreated the log shipping for another database. But still...

Because the content database size is 70 GB now and it will...

thanks Lowell,

Iam able to create a group abc@xyz.com(which consists all the DBA's email addresses) and database mail sending email when the job succeeded. But I want an email to send...

thanks Lowell,

Iam able to create a group abc@xyz.com(which consists all the DBA's email addresses) and database mail sending email when the job succeeded. But I want an email to send...

Could you give me some idea..

Thanks

Nobody Configured Log Shipping for Share point Databases in SQL Server 2005 yet.

Please let me know, if know nobody implemented so far, we will consider other methods for Disaster recovery.

thanks

Thank you,

Which one of the following is the best pratice:

1.Backup the transaction logs to Local to the primary server and then copy to Secondary server

2.Create network share On a 3rd...