Viewing 15 posts - 1,246 through 1,260 (of 9,244 total)
sudhakar_1982 (5/21/2016)
Please give me a best solution with combined the below feature in sql server 2012. i.e. High Availability + Load balancing + Fail over.
At least 2 database servers, both...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 31, 2016 at 1:56 pm
Super_Grover (5/26/2016)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 31, 2016 at 1:55 pm
GilaMonster (5/31/2016)
A copy-only backup won't affect the size of differentials.What else happened around the same time? Index rebuilds?
or emptying and loading of large tables maybe
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 31, 2016 at 1:52 pm
Rechana Rajan (5/29/2016)
I have connected to the listener...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 31, 2016 at 1:50 pm
Roust_m (5/29/2016)
We are considering using availability groups for our solution. It will have 4 SQL Server 2014 instances running on 4 cluster nodes, spread across two cities (two nodes...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 31, 2016 at 1:48 pm
you could pause data movement at the secondary, either way just be aware of the impact on the transaction log on the primary as growth may become an issue, depending...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 31, 2016 at 1:46 pm
ramana3327 (5/27/2016)
I created a maintenance plan for backup. The job is failing with the error
The job failed. The owner (TestUser) of job MaintenancePlan.Subplan_1 does not have server access.
The TestUser...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 31, 2016 at 1:44 pm
Igor Micev (5/31/2016)
Grant Fritchey (5/31/2016)
TheSQLGuru (5/31/2016)
Igor Micev (5/31/2016)
My experience with SSDs on a write-intensive instance was very bad. The SSDs went out for 2 months.
What SSDs did you have? What...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 31, 2016 at 1:43 pm
what FailureConditionLevel do you have set for the Availability group
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 17, 2016 at 7:44 am
You only mention TempDB, is this the only system database you wish to move?
To move tempdb correct sequence is
tt-615680 (5/16/2016)
Use master
GO
...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 17, 2016 at 7:40 am
sqlfriends (5/16/2016)
3. My question is on server2, is it a third method to install only SSRS service on server 2 no db engine, and put reporting dbs on Server 1
yes...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 17, 2016 at 7:34 am
what operating system are you installing onto?
Refer this link for more detail
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 17, 2016 at 7:27 am
Bob JH Cullen (5/17/2016)
then 0x00 is clearly not the same as 0x0000, the way it is written.
I see it to be a single nothing or a whole bunch of nothing...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 17, 2016 at 3:46 am
Bob JH Cullen (5/17/2016)
which in any integer expression are irrelevant, surely?
This is not an integer expression.
The code first checks the binary values for @a and @b-2, do they match, well...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 17, 2016 at 2:04 am
good article
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 15, 2016 at 2:39 pm
Viewing 15 posts - 1,246 through 1,260 (of 9,244 total)