Viewing 15 posts - 4,891 through 4,905 (of 9,244 total)
Jpotucek (10/4/2012)
Another dumb question.
There are never dumb questions, only ever dumb answers 😉
Jpotucek (10/4/2012)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 4, 2012 at 4:34 pm
As DNS is AD integrated it can take a short time to replicate across DCs. Remember you're dealing with a multi master replication model here and it gets even worse...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 4, 2012 at 4:26 pm
A great one is
"it's late and you're rebooting the SQL Server but it's taking forever to shutdown and restart, why shouldn't you hold the power button for 4 secs to...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 4, 2012 at 12:27 pm
TJ-356724 (10/4/2012)
The mirror will be using asychn.
This only alters the way the data is committed between the Principal and Mirror.
TJ-356724 (10/4/2012)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 4, 2012 at 12:06 pm
Windows 2003 or Windows 2008 domain?
Each virtual network name would be registered in Active Directory and would also have a DNS host (A) record created.
Is your DNS zone AD integrated?
Do...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 4, 2012 at 11:59 am
TJ-356724 (10/4/2012)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 4, 2012 at 9:43 am
Jpotucek (10/4/2012)
I am in stalling SQL Server 2008 R2 Standard Edition and I would like to Slipstream in the latest Service Pack and CU Package.
I tested this successfully with...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 4, 2012 at 9:07 am
On the 2008 server make sure to run DBCC CHECKDB WITH DATA_PURITY this will check for any column to data mismatches, which it sounds like you have here.
Perform a select...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 4, 2012 at 8:30 am
In a typical replication topology the Publisher and Subscriber are separate physical machines, probably with large distances between them.
You can integrate the Publisher and Distributor on the same instance but...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 4, 2012 at 7:50 am
TJ-356724 (10/4/2012)
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'AssignmentRoot' (ID 1286229770). Missing or invalid key in index 'idx_AssignmentRoot_RepName' (ID 70) for the row:
Server: Msg...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 4, 2012 at 7:26 am
TJ-356724 (10/3/2012)
We are migrating from our current production environment from sql 2000 to 2008 r2 in about two weeks. Like the old environment...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 4, 2012 at 7:23 am
thanks for the reply Gail
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 4, 2012 at 6:24 am
See Gail Shaw's article at this link[/url] for more info
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 4, 2012 at 5:24 am
GilaMonster (10/3/2012)
Anyway, read committed snapshot has the lower tempDB impact, snapshot isolation is usually more impact.
Is that absolutely true?
The way i understand it is that with snapshot isolation you first...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 4, 2012 at 5:20 am
Jai-SQL DBA (10/4/2012)
Date 2:A went Crashed and B was made as Primary .
Please provide details of the steps you took!
Jai-SQL DBA (10/4/2012)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 4, 2012 at 4:29 am
Viewing 15 posts - 4,891 through 4,905 (of 9,244 total)