Viewing 15 posts - 4,936 through 4,950 (of 9,244 total)
Jai-SQL DBA (9/26/2012)
I want to understand the Logshipping reestablishment Scenerio After a Failover.Below Mentioned are the details of the Environment for the Better Understanding.
Server A: Primary Server
Server B:...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 27, 2012 at 12:04 am
saidapurs (9/26/2012)
Hi Peery,I am using 1 cluster & multiple node. You mean multiple clusters are called active/active?
Please collaborate this one....
Thanks & Regards
Satish Saidapur
Microsoft now prefer the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 26, 2012 at 10:14 am
thanks I stand corrected
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 26, 2012 at 2:01 am
opc.three (9/25/2012)
(
DB SYSNAME,
LogSize FLOAT,
SpaceUsed FLOAT,
Stat BIT
);
INSERT INTO #LOGSPACE
(
...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 25, 2012 at 8:14 pm
Normally i would expect an error 5 if the backup couldn't be accessed during the restore part of the wizard. Haven't managed to recreate an error 2 yet.
What account...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 25, 2012 at 6:19 pm
opc.three (9/25/2012)
The SpaceUsedMB could be low if you ever switch the DB into the Bulk Logged Recovery Model and perform any minimally logged operations.
Yes, but bear in mind that log...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 25, 2012 at 6:14 pm
to TempDB
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 25, 2012 at 12:19 pm
Perry Whittle (9/22/2012)
When you set the details on the restore tab did you edit the restore options and enter different paths for the target\secondary data and log...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 25, 2012 at 12:18 pm
laurie-789651 (9/25/2012)
Perry Whittle (9/25/2012)
SQLSACT (9/25/2012)
I have a quick question regarding pages moving from disk into memory
If I select * from a table, are all pages that make up the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 25, 2012 at 9:22 am
scogeb (9/25/2012)
I am going to try to restart the endpoint per Perry's suggestion next time this happens. I will post back the results at that time.
This should be your...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 25, 2012 at 9:17 am
SQLSACT (9/25/2012)
I have a quick question regarding pages moving from disk into memory
If I select * from a table, are all pages that make up the table and indexes...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 25, 2012 at 9:15 am
opc.three (9/25/2012)
I realize that. That is my motivation for adding in the coulmn that implies it is the amount of memory allocated as a locked page, i.e. AWE memory.
The point...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 25, 2012 at 9:11 am
opc.three (9/25/2012)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 25, 2012 at 7:50 am
Kishore-132325 (9/25/2012)
ok, gotcha..but after the failover has happened, the Mirroring should establish connection back with New Principal and get synchronised rite?
What new principal?
The mirror session is created against the clustered...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 25, 2012 at 4:37 am
Kishore-132325 (9/25/2012)
Yes multi instance cluster...DB Mirroring is in Asynch mode and Manual failover...
If the cluster fails over and the failover time exceeds the mirror timeout (default is 10 seconds) the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 25, 2012 at 3:56 am
Viewing 15 posts - 4,936 through 4,950 (of 9,244 total)