sql

SQL Server 2014 General Availability

Today morning, Microsoft announced general availability for next major release of Microsoft SQL Server product which is called “SQL Server 2014”. I have listed below some of the key highlights of SQL Server 2014 release Up to 30x In-Memory OLTP performance gains New Cloud Migration Wizard Clustered Columnstore indexes – please find below official announcement from Microsoft SQL Product team blog http://blogs.technet.com/b/dataplatforminsider/archive/2014/04/01/sql-server-2014-now-generally-available.aspx SQL Server 2014 Datasheet

Backup failed–nonrecoverable I/O error occurred OperationsManagerDW

I was recently sent this error by a customer who was trying to backup their Operations Manager 2012 Data warehouse database.  I did some initial troubleshooting and found out that the database was around 130GB in size and the destination didn’t have sufficient space for the backup. I tried with an alterative location with more storage space, and I was able to successfully backup the database. I would also recommend looking at database grooming settings for Operations Manager data warehouse, as this database could be large in size with time.