Hi,

Please do not forget to select right compatibility mode as you are restoring database from SQL2005 to Higher version, else could pain you in future.

As per your post, it seems the user is already member of AD (Domain\App$). According to me your Instance might be installed to use SQL Server authentications only.

Kindly check the...

After reading all the post and having around 6 years of experience as DBA (MSSQL and MySQL) below is the conclusion:

1. If you are running your databases on Windows environment...

According to my knowledge,

Login page of Facebook was using SoldiDB (IBM Product). But not sure for current Backend.

Hello Perry,

Windows OS: Windows Server 2012 64 Bit.

Client want us to first install SQL cluster with SQL 2005 as some of their applications are compatible with SQL2005 only. They will...

Hello Perry,

I just checked windows cluster is ready and they want me to install cluster with SQL 2005 first.

How should I start now ? I have 5 instances.

Should I...

Thanks Sunder and Perry !

I will try my luck with options given by you.

Just one more quest, If I wanna install multiple instance on SQL server 2005 with cluster, what...

Hello Ratheesh,

Hope below post will help you:

http://www.sqlservercentral.com/Forums/Topic1568841-386-1.aspx

Regards,

Jitendra.

Hello Jwiseh,

First go with Query execution plan, that is your query should be executed in minimum time. You can make your query better to have good execution time of your...

Hello Jwiseh,

I think you yourself given answer in your first post..!!!

All the possible causes that can make slow query performance are mentioned by you.

However, I would like to add one...

I think you will find the information of mirror disabling in SQL Logs OR Event log. Please check it.

Hello Sam,

I am able to installed DTC. It was timezone issue. I set correct time zone and it works.

Now I face new issue.. I installed MSSQL Server 2008 R2 cluster...

jitendra.padhiyar (6/24/2014)

---

Hello Sam,

Thanks a lot for reply. My next question is , IS DTC service mandatory to install on both the nodes ? Because I found that DTC service is...

Hello Sam,

Thanks a lot for reply. My next question is , IS DTC service mandatory to install ?

I read old post for Gilamonster and found Restores, taking a DB offline, some sp_configure option changes will cause those messages.

Can anyone let me know how can I know the...