Viewing 15 posts - 1,066 through 1,080 (of 9,244 total)
tazzman (12/7/2016)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 14, 2016 at 7:28 am
remove the rows based on your required date range and trim them ongoing would be best idea
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 14, 2016 at 6:59 am
In SQL server 2014 max server memory no longer controls just the buffer usage it also now accounts for all other allocations, such as the old memtoleave which catered for...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 12, 2016 at 2:31 pm
How much ram on the server?
What is the max server memory set to?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 12, 2016 at 1:56 pm
in full recovery a log backup will cure this issue
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 6, 2016 at 9:43 am
Raghavender (11/30/2016)
Hi All,We have one Active Passive cluster with SQL Server 2014 installed on it.
Have you installed into a Failover Cluster Instance or is it a standalone instance to be...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 6, 2016 at 9:42 am
RonMexico (12/5/2016)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 6, 2016 at 9:38 am
DBA_007 (11/17/2016)
They are all in the same domain
I asked if they were on separate sites, not domains.
Please provide more detail on the mirroring configuration
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 6, 2016 at 9:32 am
dajonx (11/21/2016)
Here's a little background:
-SQL Server 2016 Enterprise on Windows Server 2016 Core
-Location A:
-Two servers
-Two SANs (one is 10 GbE/All Flash and the other...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 6, 2016 at 9:25 am
Guðjón Kr. Sigurðsson (12/6/2016)
Turns out removing the TDE before a new backup was the solution. 🙂We had not tried the detach/attach method.
There shouldnt be any reason why you cannot restore...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 6, 2016 at 9:13 am
homebrew01 (11/17/2016)
Can I restore SQL 2005 Master, model, msdb databases to 2016 ?
https://msdn.microsoft.com/en-us/library/ms190679.aspx
Or are there other considerations since 2005 is so...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 17, 2016 at 12:35 pm
DBA_007 (11/17/2016)
Database mirroring connection error 4 'The connection was closed by the remote...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 17, 2016 at 8:29 am
can you supply more detail on the placement of the principal, mirror and witness instances, are they on separate sites for instance?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 17, 2016 at 8:29 am
Kevin is correct it's the agent service that requires the access to the remote share to pull the backups locally to the secondary before then attempting top restore them.
Are these...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 17, 2016 at 8:26 am
DBA_007 (11/17/2016)
Database mirroring connection error 4 'The connection was closed by the remote...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 17, 2016 at 8:08 am
Viewing 15 posts - 1,066 through 1,080 (of 9,244 total)