Restore database SQL2000, SQL2012
Backup of base is created in Microsoft SQL Server 2000 - 8.00.2066, I can't restore on Microsoft SQL Server 2012 - 11.0.2100.60
Answer Posted / gerrit
Look for recommendations here.
http://www.filerepairforum.com/forum/microsoft/microsoft-aa/sql-server/1914-restore-the-sql-server-database
But if briefly, then do a backup restore using Microsoft SQL Server 2005. Then you will be able to open this base in Microsoft SQL Server 2012 - 11.0.2100.60. Or take the better use software to restore the Recovery Toolbox for SQL Server . https://sql.recoverytoolbox.com/
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
what are constraints? Explain different types of constraints? : Sql server database administration
What is mean by clustered index and non clustered index, give syntax of creation? : sql server database administration
How to modify an existing stored procedure in ms sql server?
What are approximate numeric data types in ms sql server?
What are rows and columns?
Define synonym?
How do we upgrade from SQL Server 6.5 to 7.0 and 7.0 to 2000?
Why are views required in the sql server or in any other database?
What is difference between standardization and normalization?
What is database dimension? : sql server analysis services, ssas
What is raid, and how it can influence database performance?
Can select statements be used on views in ms sql server?
How do we synchronize On-Premise SQL server with SQL Azure?
Explain security with sql azure?
What according to you is the difference between mysql and sql server performance?