Wednesday, December 18, 2013

Index was outside the bounds of the array

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
clip_image001



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




4 comments:

  1. I feel very grateful that I read this. It is very helpful and very informative and I really learned a lot from it. oracle training in chennai

    ReplyDelete
  2. Infycle Technologies, the top software training institute and placement center in Chennai offers the No.1 Digital Marketing course in Chennai for freshers, students, and tech professionals at the best offers. In addition to Digital Marketing, other in-demand courses such as DevOps, Data Science, Python, Selenium, Big Data, Java, Power BI, Oracle will also be trained with 200% practical classes. After the completion of training, the trainees will be sent for placement interviews in the top MNC's. Call 7504633633 to get more info and a free demo.

    ReplyDelete