found the solution to the problem

Cluster Availability Group Policy

http://blogs.msdn.com/b/arvindsh/archive/2012/03/09/failover-cluster-group-maximum-failures-limit.aspx

Thanks Andrew, will try it sometime today and get back to you with outcomes.

Cody

I was surprised on reading this article which covered almost all other jobs and industries as well. I do agree to what is written in the article. DBAs do lead...

Sorry for the late reply, this value is taken from VMWare network utilization chart.

on researching, i found it is nvarchar(max)

http://msdn.microsoft.com/en-us/library/ms187358(v=SQL.90).aspx

i cant figure it out then why the step is failing? any suggestions??

thanks for the explanation 🙂

recordid even if is not an identity, is it a primary key, if so then get the max(recordid) and programitically insert records incrementing recordid with the number of records. as...

thats...

Lazy DBA (2/15/2011)

i ran select GETDATE(), SYSDATETIME() on the server and it gave me...

i am interested in your findings

which version of OS and sql server are you using?

this sounds something fishy to me, it shouldnt happen. i think SQL Server uses SYSDATETIME () in background when the backup...

right click database --> task --> import data.

search google on how to import data in sql server, you'll definitely find many links

http://www.google.com.au/#hl=en&biw=1327&bih=683&q=sql+server+2008+import+data+from+excel&aq=1&aqi=g6g-v3&aql=&oq=+sql+server+2008:+import+data&fp=929406e309228aa7

once you have upgraded it to 2008, try refershing data sources by opening the data source and test the connection. if you have successfully tested the connection, deploy and test...

i havent run the profiler. i tried restoring tran log manually in SSMS but it threw same error. by the time i wrote the query to alter db with single...

thanks for the reply, i am aware of the alter database command and it will ensure that all connections have been dropped.

my point is, if SQL Server is saying database...