Recovering SQL Server 2005 Databases
-
We got a 2008 R2 that we tracked down. And they were able to get backup files rather than the original database files only, so looking like it will be much easier.
-
@dbeato said in Recovering SQL Server 2005 Databases:
@scottalanmiller said in Recovering SQL Server 2005 Databases:
@Obsolesce said in Recovering SQL Server 2005 Databases:
Why can't you restore the DB to a newer SQL server?
Officially, at least, MS says that that doesn't work. Or that it requires doing it many times. Hoping that there is a known, simpler solution
It does work, you need to mount it and as long as the newer SQL Server is a higher version it should work fine. You cannot go back to the old versions. Now the bigger question is what program used this Database or what was the interaction to this database. That is the biggest consideration here.
The application supports at least SQL Server 2017, which we have.
-
@scottalanmiller said in Recovering SQL Server 2005 Databases:
We got a 2008 R2 that we tracked down. And they were able to get backup files rather than the original database files only, so looking like it will be much easier.
Forget about the old OS and try restoring the old backup files directly into SQL Server 2017 then. It should work.
-
@Pete-S said in Recovering SQL Server 2005 Databases:
@scottalanmiller said in Recovering SQL Server 2005 Databases:
We got a 2008 R2 that we tracked down. And they were able to get backup files rather than the original database files only, so looking like it will be much easier.
Forget about the old OS and try restoring the old backup files directly into SQL Server 2017 then. It should work.
To restore the old backup I believe you need SQL Server Management Studio. I don't think you can do it with the command line tools. I haven't tried though.
-
I was thinking there's some kind of per-database compatibility mode that allows the backward compatibility with older applications that need to access the database. But it's also been a while since I've done much with SQL Server.
-
@NetworkNerd said in Recovering SQL Server 2005 Databases:
I was thinking there's some kind of per-database compatibility mode that allows the backward compatibility with older applications that need to access the database. But it's also been a while since I've done much with SQL Server.
There is. But that would have nothing to do with restoring.
It may prevent the legacy application from talking to the restored database though.
-
@scottalanmiller said in Recovering SQL Server 2005 Databases:
We got a 2008 R2 that we tracked down. And they were able to get backup files rather than the original database files only, so looking like it will be much easier.
Good news, much less pain than having to deal with mounting on 2005 and then backup/restore to current.
-
@scottalanmiller said in Recovering SQL Server 2005 Databases:
Anyone had any luck mounting SQL Server 2005 MDF/LDF to a new SQL Server version
You can move SQLServer 2005 to a new Server version by following this guide: https://solutioncenter.apexsql.com/restore-sql-server-backup-to-a-newer-version-of-sql-server/
