Siberian Khatru (12/14/2016)

---

I have a new SQL Server 2014 instance that I need to import many older SQL 2012 databases to in an effort to refresh a development environment. ...

tazzman (12/7/2016)

---

If you have different Windows Server versions (like Win 2012 with SQL2012 and Win2016 with SQL2016)? you need to change cluster context to include SQL2016 node to the Win2012...

remove the rows based on your required date range and trim them ongoing would be best idea

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...

How much ram on the server?

What is the max server memory set to?

in full recovery a log backup will cure this issue

Have you installed into a Failover Cluster Instance or is it a standalone instance to be...

RonMexico (12/5/2016)

---

Sue - I must not be setting it up correctly when trying to follow your advice. What permissions do I grant at the database level that won't apply...

I asked if they were on separate sites, not domains.

Please provide more detail on the mirroring configuration

dajonx (11/21/2016)

---

Hi,

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...

There shouldnt be any reason why you cannot restore...

homebrew01 (11/17/2016)

---

Looks like I got budget approval for SQL 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...

DBA_007 (11/17/2016)

---

We are receiving the below Error message in Mirroring and principal server is failovering automatically to Mirror Server.

Database mirroring connection error 4 'The connection was closed by the remote...

can you supply more detail on the placement of the principal, mirror and witness instances, are they on separate sites for instance?

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...