Viewing 15 posts - 6,946 through 6,960 (of 9,244 total)
I too, would uninstall MSXML and SQL Native client and let the installer re apply them
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 12, 2011 at 4:37 am
Is ABC.com your actual domain name?
Database mirroring error
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 12, 2011 at 4:34 am
switch to bulk logged recovery mode for the index rebuilds and back to full afterwards.
you should be using ALTER INDEX.. rather than DBCC DBREINDEX. Instead of blindly rebuilding indexes employ...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 11, 2011 at 4:00 pm
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
Viewing 15 posts - 6,946 through 6,960 (of 9,244 total)