After warning users, I tend to just set the database offline with rollback and then online. Sure the database might refuse to come back online, but in that case it...

I had a similar problem some time ago. The Business was not happy to allow the Extended SP's to be enabled.

I use this to get the latest backup for a...

OS is covered. by enterprise...

Yes as you license by the core, so if you have licensed one machine or DB and SSRS on one machine your covered for that machine. If you...

But I already have a license for the original instance including SSRS, so does it matter where the SSRS for that instance lives?

Well, I'm thinking I'll leave the ReportServer and ReportServerTempDB on their respective instances and just have the SSRS service and web sites on this new one.

I'm not sure...

About what I thought.  gets rid of all the pain when instances fail over.

I get this quite often since our infrastructure guys frequently forget to install .Net 3.5 when building the machines (I have a checklist they're supposed to follow, but...)

It's no problem...

I really think SQL Server isn't bad actual value.. We get SSIS, SSAS and SSRS all in standard.

But bojemoi! over 100k for an Enterprise cluster... Even on mission...

I have an estate of 210 SQL Server instances ranging from 2000 to 2012.

I would love to have HADR wherever it's needed but the cost of upgrading to 2012 is...

I work for a large Theme park operator and I have 250 SQL Servers in the estate. I am the only DBA.

We still have a couple of legacy 2000 boxes,...

One thing I forgot to mention.. Since all the laptops are of the same manufacturer, hot desking is very easy.

Almost everyone has their own desk with pedestal drawers etc, but...

We all use Laptops exclusively here, but 99% of all work is done through RDP or Citrix.

There's very little local data other than purely personal stuff which arguably shouldn't be...

Ok, a bit more info has come to light.

Evidently the database that the view references is restored each night, and transaction logs are rolled on every hour.

(Why not use replication?...

I started, like most as a developer working in C#.

One day my manager said "We have 6.5 terabytes of census and mapping data coming in. Build a database server handle...