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 is table constraint?
Why olap is used?
How to create new databases with "create database" statements?
Write a query for primary key constraint with identity key word?
When you use @@error and try-catch?
How to execute a stored procedure in ms sql server?
How to see existing views in ms sql server?
What are the new features in sql server 2016?
How to list all login names on the ms sql server?
What language is sql server written in?
Suppose you want to implement the one-to-one relationships while designing tables. How would you do it?
What is public role in sql server?
Explain system rowset functions?
Can you change the data type of a column in a table after the table has been created? If so, which command would you use?
What happens if you delete a table that is used by a view?