locked
Recover uninstalled SQL RRS feed

  • Question

  • Hello guys,

    customer by mistake uninstalled SQL server 2005, we have all user datafiles, and maybe on some tapes also system DB's backups.  The thing is we have now only 2008 installation. So planning to use that and recover all users DB's.

    Question is can I restore also system DB's from 2005 on 2008 from backups? or is it possible to restore also just from mdf?

    Or not any chance to restore system DB's from 2005 on 2008?

    Thanks.

    Thursday, September 21, 2017 12:23 PM

Answers

  • An uninstall of SQL Server does normally not remove the database files. So check this first, then you may have the actual database files.

    You can normally simply attach a database file (*.mdf) to a new SQL Server instance. But depending on the recovery model there may be some data missing. When it was simple, then you should have the entire data.

    • Proposed as answer by Shanky_621MVP, Editor Thursday, September 21, 2017 1:40 PM
    • Marked as answer by PeterBB8 Saturday, January 27, 2018 3:15 AM
    Thursday, September 21, 2017 12:57 PM
    Answerer

All replies

  • You do not want to restore system databases between SQL Server versions.

    If you need something from them, you need to restore them to a SQL 2005 instance and copy the data you need to the SQL 2008 instance.

    Thursday, September 21, 2017 12:41 PM
    Answerer
  • An uninstall of SQL Server does normally not remove the database files. So check this first, then you may have the actual database files.

    You can normally simply attach a database file (*.mdf) to a new SQL Server instance. But depending on the recovery model there may be some data missing. When it was simple, then you should have the entire data.

    • Proposed as answer by Shanky_621MVP, Editor Thursday, September 21, 2017 1:40 PM
    • Marked as answer by PeterBB8 Saturday, January 27, 2018 3:15 AM
    Thursday, September 21, 2017 12:57 PM
    Answerer
  • Agree with Stefan search for *.mdf in windows search bar and locate your mdf files. Install SQL server 2005 and attach it

    Cheers,

    Shashank

    Please mark this reply as answer if it solved your issue or vote as helpful if it helped so that other forum members can benefit from it

    My TechNet Wiki Articles

    MVP

    Thursday, September 21, 2017 1:41 PM
    Answerer
  • I've heard rumors that you can "slide in" the database files for system databases from an older version of SQL Server. Obviously while SQL Server is stopped. And that SQL Server will happily upgrade them when you start SQL Server.

    This is, AFAIK, *not supported*. So if you go this route you are on your own. Make sure you do proper tests etc.

    Considering the boot sequence for SQL Server (location for master is in registry, location for other databases is in master database) you want to have identical path structure as on the prior install. Else your SQL Server won't boot when you start (as it won't find model where it used to be and possibly also won't be able to create tempdb where it should be).

    Basically, if you don't feel comfortable doing this and are pretty familiar with SQL Server, I'd stay away from it.


    Tibor Karaszi, SQL Server MVP (Web Blog)

    Thursday, September 21, 2017 3:19 PM