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

Answers were Sorted based on User's Feedback



Restore database SQL2000, SQL2012 Backup of base is created in Microsoft SQL Server 2000 - 8.00.2..

Answer / 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

Restore database SQL2000, SQL2012 Backup of base is created in Microsoft SQL Server 2000 - 8.00.2..

Answer / gerrit

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

Restore database SQL2000, SQL2012 Backup of base is created in Microsoft SQL Server 2000 - 8.00.2..

Answer / gerrit

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.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL Server Interview Questions

How can windows applications connect to sql servers via odbc?

0 Answers  


Differences between logshipping and mirroring

1 Answers   Microsoft, Syntel,


How to select top 5 coloumn from a table without using coloumn name

5 Answers  


Do you know what is a trace frag? Where do we use it?

0 Answers  


Explain sql server authentication modes?

0 Answers  






What is the command used to get the version of sql server?

1 Answers  


What is difference between group by and having?

0 Answers  


What are exact numeric data types in ms sql server?

0 Answers  


What is indexing?

0 Answers   AOL,


What are the restraints imposed on the table design by a merge replication?

0 Answers  


Where can you add custom error messages to sql server?

0 Answers  


What is cursors? And what are the different types of cursor?

0 Answers  


Categories