Less Than Dot is a community of passionate IT professionals and enthusiasts dedicated to sharing technical knowledge, experience, and assistance. Inside you will find reference materials, interesting technical discussions, and expert tips and commentary. Once you register for an account you will have immediate access to the forums and all past articles and commentaries.
Total Post History
7-Day Post History
- New Posts:
- New Topics:
- Active Topics:
Our newest member
All times are UTC [ DST ]
But it fails. I get the following message text.
Can anyone help me please. I thought restoring a 2008 database to the later version 2012 would be possible.
Here is the error message. Thanks.
TITLE: Microsoft SQL Server Management Studio
Restore of database failed. (Microsoft.SqlServer.Management.RelationalEngineTasks)
System.Data.SqlClient.SqlError: The database was backed up on a server running version 8.00.2039. That version is incompatible with this server, which is running version 11.00.3128. Either restore the database on a server that supports the backup, or use a backup that is compatible with this server. (Microsoft.SqlServer.SmoExtended)
- Posts: 1
- Joined: Sun Jan 12, 2014 6:40 am
Also keep in mind that Enterprise Edition functionality if it has been used, you won't be able to restore to an express version
Also Express only supports up to a certain size, if the DB is 200 GB, you won't be able to restore it either
Personal and/or non database related blog
- LTD Admin
- Posts: 21784
- Joined: Wed Oct 10, 2007 6:43 pm
- Location: Princeton, New Jersey, USA,World, Solar System, Milky Way, Universe and Beyond
But the point stands, SQL Server 2000 database can not be directly restored on SQL Server 2012 (and sometimes it's a PITA).
Donald Knuth, repeating C. A. R. Hoare
- Senior Sage
- Posts: 1754
- Joined: Thu Mar 26, 2009 5:46 am
- Location: WI