Viewing 15 posts - 4,876 through 4,890 (of 9,244 total)
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 5, 2012 at 8:39 am
For an add file to be seamless you need to ensure the paths on both instances match
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 5, 2012 at 7:57 am
Jeff Moden (10/5/2012)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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,...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 5, 2012 at 6:28 am
you're welcome
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 5, 2012 at 5:52 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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 5, 2012 at 5:17 am
query the sysjobs table in the MSDB database for the info you need
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 5, 2012 at 2:01 am
Well done, thanks for posting back
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 4, 2012 at 11:43 pm
Generally I think that experience is a better measuring stick, sure you'll have exceptions but overall experience counts.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 4, 2012 at 11:42 pm
lptech (10/4/2012)
But you'd have to make sure that you issue the 'with move' while you restore the log with the add file command.
You are correct. When you are aware...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 4, 2012 at 4:54 pm
I dont use it as its a pile of doggy doo doo 🙂
What options are you using during the copy?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 4, 2012 at 4:40 pm
Viewing 15 posts - 4,876 through 4,890 (of 9,244 total)