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
Suppose you want to implement the one-to-one relationships while designing tables. How would you do it?
Explain subquery and state its properties?
How to create an identity column?
What is the temp table?
How is a full-text index updated?
Your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files?
What are the different subsets of sql?
What is a hint?
Explain difference between cross join and full outer join?
What is sql or structured query language?
Describe and explain about SQL native client?
Mention the uses of stored procedures.
What is a transactions?
What do you mean by table and field in sql?
What are the approximate numeric data types?