Viewing 15 posts - 6,946 through 6,960 (of 9,241 total)
Pei Zhu-415513 (7/11/2011)
I was wrong the example mentioned could cause data loss. I was thinking raid 50 I guess. single failed disk can be recovered from mirror. If the whole...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 11, 2011 at 3:43 pm
gary.strange-sqlconsumer (7/11/2011)
Great Article Perry,Is it possible to achieve the same result using ORacle VM VirtuaBox instead of VM ware?
Thanks,
Gary
Never used Oracle virtual box so i wouldnt know unfortunately. I do...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 11, 2011 at 3:26 pm
pmcalister (7/11/2011)
(ONLINE = ON)
Also, with Standard edition this will be ignored
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 11, 2011 at 3:05 pm
Pei Zhu-415513 (7/11/2011)
The example I gave0 0 1 1
0 1 1 1
would not cause data loss.
Pei
please explain why you think this does not cause data loss?
Red are the first mirrored...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 11, 2011 at 2:46 pm
Pei Zhu-415513 (7/11/2011)
you can have0 0 1 1
0 1 1 1
(0 indicates failure drive)
This too, is wrong. You may lose any 4 drives out of the 8 as long as...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 11, 2011 at 2:03 pm
i'm asking because the log copy operation is taken care of by a job on the secondary server. I understand log shipping perfectly but do not understand why you say
nathanr...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 11, 2011 at 1:56 pm
parts 2 and 3 follow shortly 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 11, 2011 at 12:58 pm
nathanr 81822 (7/11/2011)
or isolate any load that may be occuring when the backup process copies the bak files off to another server.
exactly what do you mean by this? What is...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 11, 2011 at 7:45 am
mmcginty
are builtin admins definitely in the sysadmin role, please execute the following against your instance and advise the results
EXEC sp_helpsrvrolemember 'sysadmin'
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 11, 2011 at 5:38 am
nathanr 81822 (7/11/2011)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 11, 2011 at 5:18 am
TBH it shouldnt be too much of an issue as the service is normally set to retry 3 times by which time the DC should be available. Its best to...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 11, 2011 at 3:21 am
Hi Mohammed
no problem, if you hit any problems feel free to post back here and ask (or create a new thread in the forum).
This is actually a 3 part...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 11, 2011 at 3:18 am
dont shrink, just increase the log backup frequency is the message here!!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 11, 2011 at 3:09 am
anthony.green (7/11/2011)
if so dont power on the sql servers until ad is back online.
our server guys have fallen into this trap many a time,...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 11, 2011 at 3:08 am
you can increase the frequency of the LS backup job without issues.
You could run the backup job every 15 mins as Gail suggested and the copy and restore jobs once...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 10, 2011 at 12:59 pm
Viewing 15 posts - 6,946 through 6,960 (of 9,241 total)