Viewing 15 posts - 4,876 through 4,890 (of 9,241 total)
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
Jpotucek (10/4/2012)
Another dumb question.
There are never dumb questions, only ever dumb answers 😉
Jpotucek (10/4/2012)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 4, 2012 at 4:34 pm
As DNS is AD integrated it can take a short time to replicate across DCs. Remember you're dealing with a multi master replication model here and it gets even worse...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 4, 2012 at 4:26 pm
A great one is
"it's late and you're rebooting the SQL Server but it's taking forever to shutdown and restart, why shouldn't you hold the power button for 4 secs to...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 4, 2012 at 12:27 pm
Viewing 15 posts - 4,876 through 4,890 (of 9,241 total)