Are you running log backups?

[/url]

And, I'm with Gail, turn off auto shrink.

The Import/Export wizard can work, but if you hit issues where you need to manually intervene it can be a pain. I'd say the best bet would be to build...

I'd go with the DENY approach and then make sure that only appropriate people have access to the system.

However, that's not even the scary thing. The scary thing is when...

You can usually access lower versions of SQL Server from higher versions of SSMS, but the other way around leads to errors. If you need to manage both 2005 and...

I would imagine that while you're looking at them those processes might be idle, but that they're not idle all the time. When they're not idle, they could be using...

The issue is around even older versions of SQL Server. You can't take a SQL Server 2000 backup and restore it to 2012. You have to convert it to 2005...

Personally, I think the blame lies mostly with the DBAs. Ten to Fifteen years ago, when all the modern development paradigms were starting to shake out, when object oriented programming...

I have not noticed a general slowdown with SQL Server 2014, so some more details are needed in order to understand what's happening. Although, it's possible that it's the version...

There's not a real way to say Plan A is better than Plan B. Instead, Plan A results in behavior 1,2,3 and Plan B results in behavior 4,5,6. It's the...

GilaMonster (6/10/2014)

---

Hang...

Jeff Moden (6/10/2014)

---

GilaMonster (6/10/2014)

---

Jeff Moden (6/10/2014)

---

Grant Fritchey (6/9/2014)

---

SQL Server prevents changes from occurring at the same time. It's part of the Atomicity, Consistency, Isolation, and Durabality (ACID) properties of the...

jasona.work (6/10/2014)

---

dax.latchford (6/10/2014)

---

Also as mentioned my colleague has created a domain account with the rights to backup to a UNC location. Is it safe for me to do the following...

It sounds like a good approach, but, one point. You do know that it's actually not likely to speed up your restore process. Assuming you script your restores, currently you...

Yep, John has nailed it. I'd add a +1 if we had that capability here.

Compatibility mode is supposed to be a temporary fix as part of the migration of your database to the new server, allowing time for the code and application to catch...