1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

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

Question Posted / baldwin

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

What is difference between group by and having?

0 Answers  

Can another user execute your local temporary stored procedures?

0 Answers  

I am learning Testing, so i want to learn SQL also because SQL is important for Testing. I want to know which is best Institute in Ameerpet or SR Nagar or any other place in Hyd? Please help me.

7 Answers  

How to download and install microsoft sql server management studio express?

0 Answers  

How many types of local tables are there in sql server?

0 Answers  




What are different types of raid configurations? : SQL Server Architecture

0 Answers  

What are the different authentication modes in sql server? How can it be changed?

0 Answers  

which database is best to use in oracle and sql server? explain reasons?

5 Answers   TCS,

What are the different types of Indexes available in SQL Server?

0 Answers  

If we use where clause in the left outer join then how the query would behave/act?

1 Answers  

Write a SQL command to insert and update only a particular field?

0 Answers   ADITI,

How to retrieve error messages using mssql_get_last_message()?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories