I did finally get it resolved but to be honest, I both can't remember exactly what I did a couple of years ago [think it had to do Enable Promotion...

Database Health

http://stevestedman.com/category/database-health/

link[/url]

There really isn't a whole lot of information to go on here.

Is this a mirrored system? Always On is a great feature if you have the enterprise version of 2012

OLAP...

If this is something you have to do on a regular basis, how about merge replication?

Log shipping and replication aren't the same thing. Your log shipping machine will have the databases in standby/read-only mode and the database will be unaccessible when it is being updated

I'm very particular with how my desktop is set up but the desk it sits on is usually a mess

Dual monitors when I can although I find myself working from...

All of them?

Right now, I have 3 SQL books [and a bunch of non computer books] on my phone, about 15 SQL books on my tablet, a bunch of PDF...

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

But as someone else pointed out, installing the developers edition which has all of the features of the Enterprise edition cost around $50. The enterprise edition could end up costing...

We have around 10 people in development and one DBA [me] but the real question is how many DBAs take care of how many database/servers? We have around 130 servers...

Update to SQL 2012 from what? I haven't had any issues moving from SQL 2008R2 but have had a few issues with older editions.

What version of SharePoint? Again, I...

I don't have a problem setting up the linked server but can not query the LDAP which uses the Active Directory Helper Service

I inherited not just a database, but about 130 database servers with hundreds of undocumented databases. We have about 115 database servers should have the exact same database but I...