Viewing 15 posts - 4,876 through 4,890 (of 9,253 total)
a logical read is the pages that are read in memory, a physical read is when the page is brought in from disk
October 6, 2012 at 3:39 pm
October 5, 2012 at 4:07 pm
yeohbk (10/5/2012)
Can anyone share with me the information on how to configure SQL Mirroring and MS Clustering for SQL? I need to configure them and it would be...
October 5, 2012 at 1:16 pm
SQLCrazyCertified (10/5/2012)
Hi All,If you have mirroring or logshipping setup as a DR solution......Do you need have a backup policy/plan on top of it?
Yes you do!
It sounds like you haven't so...
October 5, 2012 at 12:18 pm
MysteryJimbo (10/5/2012)
That's correct if you want minimal overhead but you can manually move files if you have different drives.
Yes, but if you read the post the user wants to...
October 5, 2012 at 9:30 am
Jeff Moden (10/5/2012)
CptCrusty1 (10/5/2012)
A caveat to this, Sir Moden, is that someone could actually have 10 years exp, but the question is the quality/type of exp they have.
That's precisely the...
October 5, 2012 at 8:43 am
CptCrusty1 (10/5/2012)
Sir Moden
😀 he should defo get a pork chop in the boat for that one
October 5, 2012 at 8:39 am
For an add file to be seamless you need to ensure the paths on both instances match
October 5, 2012 at 8:33 am
shiv-356842 (10/5/2012)
We are going to re-name the server name 'A' ,'B' on this server we have sql server 2008 R2 default instance and 3 named instance configured...
October 5, 2012 at 8:30 am
If you ever had to restore the principal back to a prior point in time the mirror state would no longer match the principal.
If anything happens to the principal...
October 5, 2012 at 7:57 am
Jeff Moden (10/5/2012)
October 5, 2012 at 6:52 am
TJ-356724 (10/5/2012)
I was just curious if any type of data was being passed to the mirror via a trn log backup or full db backup
No, that's not how mirroring works,...
October 5, 2012 at 6:36 am
TJ-356724 (10/5/2012)
And by the way Perry there is no witness
you generally won't have in asynch mode 😉
October 5, 2012 at 6:28 am
Be very careful with this file, because unlike the actual database files it can be deleted accidentally, once that happens you'll encounter issues with the LS scenario.
ACL the folder where...
October 5, 2012 at 5:17 am
Viewing 15 posts - 4,876 through 4,890 (of 9,253 total)