Viewing 15 posts - 2,221 through 2,235 (of 9,253 total)
Pablo Campanini-336244 (3/31/2015)
Can I have the primary replica in SQL 2008 R2 EE, and the other secondary replicas...
April 1, 2015 at 4:17 am
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
April 1, 2015 at 4:16 am
Duran (3/31/2015)
April 1, 2015 at 4:14 am
check with the vendor whether they support SQL Server 2014 at the ArcGIS product level you are intending to use
April 1, 2015 at 4:11 am
Grant Fritchey (3/30/2015)
Although, ideally, you'd store them all in a central location so they're available immediately upon requirement...
April 1, 2015 at 4:10 am
mahikero (3/28/2015)
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...
April 1, 2015 at 4:07 am
Adam Bean (3/30/2015)
(Perry, I'm sure you'll be my response, so thanks in advance!)
😉
Adam Bean (3/30/2015)
I've seen a handful of posts, and even a couple built and ready to go...
April 1, 2015 at 4:05 am
daniel.moody (3/27/2015)
Express Edition (64-bit
😉
March 27, 2015 at 4:07 pm
peacesam (3/27/2015)
So after my Sans storage that contains the MSSQL db files crashed, i had to rebuild the entire array.
This is on the primary server?
Where are the backups from...
March 27, 2015 at 11:28 am
ramyours2003 (3/27/2015)
March 27, 2015 at 11:14 am
jasona.work (3/27/2015)
OK, but do you have a dedicated heartbeat network for the cluster servers?
You no longer need to have a dedicated heartbeat network, you don't push the heartbeat traffic through...
March 27, 2015 at 11:13 am
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...
March 27, 2015 at 11:09 am
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...
March 27, 2015 at 10:46 am
gs1975 (3/27/2015)
Even so, I am going to explicitly add the option as Gail suggests.Thanks to you both.
George
You can check it first, using the following against the chosen database
DBCC DBINFO...
March 27, 2015 at 10:32 am
Viewing 15 posts - 2,221 through 2,235 (of 9,253 total)