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
July 12, 2011 at 4:37 am
Is ABC.com your actual domain name?
Database mirroring error
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...
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...
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...
July 11, 2011 at 3:26 pm
pmcalister (7/11/2011)
(ONLINE = ON)
Also, with Standard edition this will be ignored
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...
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...
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...
July 11, 2011 at 1:56 pm
parts 2 and 3 follow shortly 😉
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...
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'
July 11, 2011 at 5:38 am
nathanr 81822 (7/11/2011)
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...
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...
July 11, 2011 at 3:18 am
Viewing 15 posts - 6,946 through 6,960 (of 9,244 total)