Viewing 15 posts - 3,886 through 3,900 (of 9,241 total)
shindle 17293 (11/14/2013)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 14, 2013 at 9:16 am
why rename the job?
For each instance you want to monitor an LSAlert_instancename job is created.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 14, 2013 at 8:29 am
A single instance can be used to monitor multiple log shipping plans
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 14, 2013 at 2:20 am
RTaylor2208 (11/13/2013)
On each node you've a SQL server installation you...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 14, 2013 at 2:17 am
The setup account requires administrator permission to carry out the install. The service account should be a basic user account.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 14, 2013 at 2:02 am
Running multiple instances on sql on the same node is not uncommon or bad, in fact its a good way to get the most from your hardware as long as...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 13, 2013 at 12:25 pm
just query this from each instance and compare the values, no need for reams and reams of code
SELECT SERVERPROPERTY('Computernamephysicalnetbios')
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 13, 2013 at 9:41 am
Grant Fritchey (11/7/2013)
GilaMonster (11/6/2013)
Restoring or recovering?A DB will go restoring if someone runs BACKUP LOG ... WITH NORECOVERY ....
In what might be an epic role reversal, don't you mean RESTORE...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 13, 2013 at 7:12 am
Ryan007 (11/11/2013)
But disk might get full due to huge transactions. So to prevent this, is there anything that can be done so that LUN does not go offline if...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 11, 2013 at 10:16 am
Reg_Mayfield (11/8/2013)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 11, 2013 at 8:10 am
at the Netapp filer level if the LUN space depletes the LUN goes offline, this in turn will take the disk offline in Windows.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 11, 2013 at 8:05 am
That is correct
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 8, 2013 at 11:28 am
muthukkumaran Kaliyamoorthy (11/8/2013)
> Need a Shared disk
> Need a Third server/node
> create a new...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 8, 2013 at 4:33 am
muthukkumaran Kaliyamoorthy (11/7/2013)
Thanks Perry Whittle. I understand that, i need to run the wizard on passive node/server or do i need one more server for the third instance.
No, you dont...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 8, 2013 at 4:30 am
anoop.mig29 (11/7/2013)
Perry Whittle (11/6/2013)
Where firewalls are in place and you wish to connect via the instance name...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 7, 2013 at 9:19 am
Viewing 15 posts - 3,886 through 3,900 (of 9,241 total)