My SQL Server 2005 host died, but the database related LUNS were on a SAN and still exist. Is there a way to use my SQL Server 2012 host to recover that database or import it in some way?

  • Have you worked through the steps here: msdn.microsoft.com/en-us/library/ms177429.aspx – Yoda May 23 '14 at 13:45
  • you can use SLQ Server Manager Studio to restore your database to a new location. Here, msdn explain how to do it http://msdn.microsoft.com/en-us/library/ms186390.aspx – angel May 23 '14 at 13:49
  • 2
    Wll, you do have a backup, right? If not - what do you care about the data now? – TomTom May 23 '14 at 13:58

The absolute best way would be to restore onto 2012 from backups if you have them, but you can also attach the databases from the SAN files onto your 2012 instance.

Once you do that, be sure to run DBCC CHECKDB to make sure all your data is intact.


This shouldn't be a problem and is extensively documented online with Management Studio specific steps as linked by angel


Just to add that restoring a database from an older version (e.g. SQL Server 2005) to a newer one (e.g. SQL Server 2012), i.e. upgrading is usually smooth. The issues are encountered when restoring SQL Server 2000 and older databases to SQL Server 2012 and newer.

Downgrading - restoring a SQL Server 2012 database to a SQL Server 2005 instance is troublesome.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy