Viewing 15 posts - 4,666 through 4,680 (of 9,241 total)
OK, just tested it myself. If your mirror instances all run as the same service account leaving the boxes blank is fine, you won't see any GRANTs as the service...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 5, 2012 at 1:21 pm
scogeb (11/5/2012)
That returns the user that was used to connect to the pincipal, mirror and witness when mirroring was set up using the wizard.
Yes, that's what I'm expecting 😉
Are...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 5, 2012 at 8:22 am
CuriousDBA (11/4/2012)
I have created maintenance...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 5, 2012 at 6:37 am
yes, from SQL Server 2012 mirroring is superseded by AlwaysOn
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 4, 2012 at 11:31 am
deebabat (11/4/2012)
I don't really know what information you want me to provide
This will do for starters
Whay...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 4, 2012 at 9:51 am
Perry Whittle (11/4/2012)
Can you supply more detail about your mirror setup?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 4, 2012 at 6:33 am
Can you supply more detail about your mirror setup?
Can you post details of this query run against the principal
Select name, user_access_desc, state_desc,
recovery_model_desc
from sys.databases
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 4, 2012 at 4:53 am
Mac1986 (11/4/2012)
Then can I drop and recreate the DB with My choice of data files?
Are you referring to the source database??
Mac1986 (11/4/2012)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 4, 2012 at 2:56 am
What is the failure message in the sql server error log?
Have a read through this
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 4, 2012 at 2:46 am
Books online should tell you all you need. Have you had a look on google. I seem to remember there was a whitepaper from Microsoft on the HA technologies.
Once you...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 4, 2012 at 2:34 am
scogeb (11/2/2012)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 2, 2012 at 2:25 pm
The mirroring wizard states
Database Mirroring Wizard
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 2, 2012 at 1:26 pm
How are the disks presented to the OS, (iscsi, fibre channel, local raid,etc)?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 2, 2012 at 12:47 pm
Furthermore, the script targets files with ".ldf" extension. What happens if a DBA creates a database and gives one of the data files on a database the ".ldf" extension 😉
At...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 2, 2012 at 12:13 pm
OK, you're joking right??
Firstly, TRUNCATEONLY does not apply to T-log files!
A wholesale shrink of all log files on the instance, and you believe this will be beneficial?
What do you do...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 2, 2012 at 12:06 pm
Viewing 15 posts - 4,666 through 4,680 (of 9,241 total)