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

I renewed my passport last year. There still was expedited service, but I didn't choose it. Got mine in under 4 weeks.

First hit of 2013. Mr November is back

http://espn.go.com/new-york/mlb/story/_/id/9468924/derek-jeter-return-new-york-yankees-thursday-brian-cashman-confirms

The Dixie Flatline (7/11/2013)

---

Brandie Tarvin (7/11/2013)

---

You ever have one of those days when you're trying to get information about a High Priority problem (so you can resolve the issue) and...