Pablo Campanini-336244 (3/31/2015)

---

SInce they do not want to upgrade the current DWS servers. questions is:

Can I have the primary replica in SQL 2008 R2 EE, and the other secondary replicas...

Yes you are able to tell a sql server instance which IP address and ultimately which NIC to listen on. Check books online for more info

Duran (3/31/2015)

---

I was going to stop/disable the merge jobs on the distributor, detach the database, move the log file to another drive, reattach, and enable the merge jobs on the...

check with the vendor whether they support SQL Server 2014 at the ArcGIS product level you are intending to use

Grant Fritchey (3/30/2015)

---

Also, the log backups can, roughly, be taken anywhere and then combined later.[\quote]

Although, ideally, you'd store them all in a central location so they're available immediately upon requirement...

mahikero (3/28/2015)

---

Hi

If I try to connect to ServerName\I01, I get the error below.

"A network-related or instance-specific error occured while establishing a connection to SQL Server.

The server was not found...

😉

Adam Bean (3/30/2015)

---

Hey all,

I've seen a handful of posts, and even a couple built and ready to go...

You're welcome 😉

😉

This is on the primary server?

Where are the backups from...

ramyours2003 (3/27/2015)

---

Run the Validate a Configuration wizard to check your network configuration. If the condition persists, check for hardware or software errors related to the network adapter. Also check for...

You no longer need to have a dedicated heartbeat network, you don't push the heartbeat traffic through...

certain operations rely on the logical filename but mostly system stuff. It's a good practice to ensure your logical filenames are unique, having 100 databases on the server all with...

This is easier

IF OBJECT_ID('tempdb..#dbccoptions') IS NOT NULL

BEGIN

DROP TABLE #dbccoptions

END

CREATE TABLE #dbccoptions

(

[parentobject] VARCHAR(32)

, [object]VARCHAR(32)

, [field]VARCHAR(32)

, [value]VARCHAR(64)

)

INSERT INTO #dbccoptions

EXEC('DBCC DBINFO WITH TABLERESULTS')

SELECT field, value

FROM...

You can check it first, using the following against the chosen database

DBCC DBINFO...