Hi,

It depends on the result set size of your Stored procedure. Like if the Stored procedure returns millions of rows or it returns only 1000 rows. There is no need...

ip_addressip_subnet_maskis_dhcpnetwork_subnet_ipnetwork_subnet_ipv4_masknetwork_subnet_prefix_lengthstate_desc

10.200.262.89255.255.255.0010.200.262.0255.255.255.024ONLINE

10.200.262.89255.255.255.0010.200.262.0255.255.255.024ONLINE

Can we have a setup something like this...

AlwaysOn Group [FB2014] has the following members;

Replica 'SQL2012-01\SQL2014' identified by Endpoint 'TCP://SQL2012-01.xxxx.com:5028 is set to Availability mode 'SYNCHRONOUS_COMMIT' with 'AUTOMATIC failover failover. Session timeout is 10 secs. Primary role connections...

Perry Whittle (8/27/2014)

---

I'm assuming this is your configuration

ServerA ...

Perry Whittle (8/27/2014)

---

yes you can, each instance must...

The blocking is by replication design. If the database is not growing, you can unschedule the job for that period. It should not cause any issues.

But i am seeing like thousands of thousands login failure for every sec, is this really expected behaviour?

They...

Gazareth (7/17/2014)

---

Expected behaviour, no?

The connection string specifies ServerName and FailoverPartner. So the app tries ServerName first, then FailoverPartner if unsuccessful.

The login errors you're seeing are the attempts of your...

Perry Whittle (7/17/2014)

---

muthyala_51 (7/16/2014)

---

Hi,

We have high safety with automatic failover setup in our Sql Server 2008 R2 environment, and automatic failover is functioning without any issues. All the applications are...

I guess you have to remove the mirroring and bring the database online or do as below

RESTORE DATABASE AdventureWorks2012

WITH RECOVERY

If the database is in restoring mode, you...

Eirikur Eiriksson (6/3/2014)

---

muthyala_51 (6/3/2014)

---

Eirikur Eiriksson (6/3/2014)

---

muthyala_51 (6/3/2014)

---

3.Microsoft XML Editor Information Disclosure Vulnerability (MS11-049)

-- This security patch is released on Feb 2012 before of the SQL Server 2008 R2 SP2(june 2012)....

Can the script.sql file can have a select statement with joins? or this can be only used to export for just plain tables?

Eirikur Eiriksson (6/3/2014)

---

muthyala_51 (6/3/2014)

---

3.Microsoft XML Editor Information Disclosure Vulnerability (MS11-049)

-- This security patch is released on Feb 2012 before of the SQL Server 2008 R2 SP2(june 2012). DO i need...

3.Microsoft XML Editor Information Disclosure Vulnerability (MS11-049)

-- This security patch is released on Feb 2012 before of the SQL Server 2008 R2 SP2(june 2012). DO i need to still apply...

I was able to run the BPA tool against stand alone instance successfully. But on cluster it's failing if I provide the virtual name at the sql instance tab. Can...