Joy Smith San (1/22/2014)

---

Experts,

Can someone help me with a query to find which all jobs will be running on 5th of next month from SQL 2000 and SQL 2005 SQL...

SQLSACT (12/12/2013)

---

Hi all

We are looking at implementing AlwaysOn AG combined with a Failover Clustered Instance of SQL Server. This is the setup:

>> 3 Nodes (A, B, C) joined to the...

PRR.DB (11/19/2013)

---

Hi all,

In My machine i have two instances i.e. one is default and named instance ,

How i can connect named instance by using port number

named instance name...

Thanks Perry Whittle. It helps me.

Thank you. Here is the steps:

> Need a Shared disk should be present in the nodes and must be a cluster resource.

http://blogs.technet.com/b/askcore/archive/2009/01/14/adding-a-new-disk-to-an-existing-windows-2008-cluster.aspx?Redirected=true

> Use “Install new SQL server failover...

I did some online searching. Here is the step I have to perform. Am I missing anything.

> Need a Shared disk

> Need a Third server/node

> create a new failover windows...

Perry Whittle (11/7/2013)

---

muthukkumaran Kaliyamoorthy (11/7/2013)

---

I have a 2 node cluster (2-physical servers) “instance1” is passive for “instance2” & “instance2” is passive for "instance1" vice versa.

I want to add/install 3rd...

PRR.DB (10/29/2013)

---

Hi All,

I have taken full backup of database yesterday(with Recovery Model=full ) from sql 2005

and taken differential backup today 5PM(IST)

now i am restored the full backup in sql2008r2...

Brian Seib (6/10/2013)

---

Very strange - so I am was looking at one of the servers that this is running on and failing - and after looking through the history...

Brian Seib (5/30/2013)

---

Looking at another server that is runnig the same script and the error it is getting is "COUNT field incorrect or syntax error [SQLSTATE 07002] (Error 0). ...

If that's case you can add additional condition within the script. Run a select statement one by one and check which is causing an issue.

Glad to hear...

Raise a case with MS for dump file analysis. You can also try Amit banerjee's articles.

Jpotucek (4/17/2013)

---

I have a Database (about 1GB) with 2 log files (one at about 4GB and one at about 13 GB)

The database had been set to Full recovery mode...

Check the sql error log . You can get some details over there. Also check is there any SQLDUMP* files are available in a log folder.