Good for you.

you might think about scanning a folder in the package for .bak files, working out the latest one, and then grabbing the name for use in the...

The case is that you don't have any instance logins, only contained ones in your database. You can migrate all your users (windows are easy) to contained, and then you...

You should get an error.

AFAIK, Windows 7 is not an acceptable OS for SQL 2008 R2 enterprise, or any version.

http://msdn.microsoft.com/en-us/library/ms143506(v=SQL.105).aspx

This is only supposed to run on Server OSes.

+1.

Set a max memory, but SQL will take all it can get if you let it.

I like derived (staging) tables as an intermediary, and I'd probably use SSIS to move the data regularly. No reason a stored proc can't work, but I tend to stick...

Is it way behind? Have you looked in BOL for the "Monitoring Mirroring Status"?

It could be always slightly behind, depending on how your system is setup and your network.

In a...

I've tended to keep 2-3, similar to what I do for user databases. These rarely change, so you could argue you need less backups, like 1/week, but since they're small,...

The distributor must be the highest version. then publisher, then subscriber.

http://msdn.microsoft.com/en-us/library/ms143699.aspx

I would start to suspect timing (check computer times) or some other Kerberos/SPN issue from this machine to others.

I might try changing the service account, restarting, then changing it back...

If you ran uninstall from the Control Panel, then the services should be gone, and the binaries removed. However the logs, database files, etc. are not necessarily deleted. You'll have...

you have have mutliple instances of reporting services, but I don't believe that means on one database engine.

http://msdn.microsoft.com/en-us/library/ms403426(v=sql.90).aspx

ConnieOI (7/12/2013)

---

Wow -- that whole 2 weeks a year vacation thing is something that I do not miss about living in the USA! I'm American, but have lived in the...

OCTom (7/12/2013)

---

I must be missing something. I'm sure someone can put me straight. This link says that you need to restore both the DEK and the certificate http://msdn.microsoft.com/en-us/library/bb934049.aspx. I chose...

IgorMi (7/12/2013)

---

Nice question!

What if you already have a master key that is used by a certificate aimed for another database (dbA) on the instance you're moving the dbB?

Just for clarification.

I...

If you don't have contained users, or collation issues, you get zero benefit from contained databases. There's no point to changing to partial containment, moving the db, and changing it...