Index was outside the bounds of the array

December 18, 2013     less than 1 minute read

I was trying to restore a database using SQL server 2008 management studio by connecting to SQL Server 2012 database, I was able to connect to server but I was getting below error when i use restore

Cause : Because SQL 2012 does not provide backward compatibility, so using SQL Server 2008 SSMS causing this issue

Resolution : Upgrade tools to higher version or download SQL 2012 Management studio and use that to open the server.

http://www.microsoft.com/en-us/sqlserver/editions/2012-editions/express.aspx