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
How to create a login account in ms sql server to access the database engine using "create login" statements?
How ssrs maintain security?
Is it ok to shrink transaction log?
Can the query output be sorted by multiple columns in ms sql server?
Explain what are commit and rollback in sql?
What does normalization do to data?
What is stored in the mssqlsystemresource database? : sql server database administration
Give an example of why you would want to denormalize a database
Is null in sql server?
How many categories of data types used by sql server?
What happens if null values are involved in datetime operations?
Why variables called the most powerful component of ssis?
Your table has a large character field there are queries that use this field in their search clause what should you do?
What is the difference between for xml raw and for xml auto?
What are policy management terms?