Viewing 15 posts - 4,891 through 4,905 (of 9,241 total)
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
ananda.murugesan (10/4/2012)
I have checked at 9 AM there is no table locking and blocking that particular table...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 4, 2012 at 3:47 am
saidapurs (10/4/2012)
Hi Scogeb,Database will not go off line....
Thanks
Satish
Incorrect, if you only have the primary and the witness and the witness goes down the principal...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 4, 2012 at 1:12 am
you're welcome
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 3, 2012 at 11:50 am
Viewing 15 posts - 4,891 through 4,905 (of 9,241 total)