Viewing 15 posts - 2,221 through 2,235 (of 9,244 total)
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
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 1, 2015 at 4:16 am
Duran (3/31/2015)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 1, 2015 at 4:05 am
You're welcome 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 1, 2015 at 4:01 am
daniel.moody (3/27/2015)
Express Edition (64-bit
😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 27, 2015 at 11:28 am
ramyours2003 (3/27/2015)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 27, 2015 at 10:32 am
aprathour.89 (3/24/2015)
I am getting the following error while installing sql server 2008 r2
The cluster resource 'SQL Server (SQL2008r2)' could not be brought online due to an error bringing the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 27, 2015 at 7:02 am
Viewing 15 posts - 2,221 through 2,235 (of 9,244 total)