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

What are the different types of backups that exist?

0 Answers   ADITI,


does physical index sort data

1 Answers  


What is indexed view?

0 Answers  


A user is a member of the public role and the sales role. The public role has select permission on all the tables. The sales role does not have select permission on some of the tables will the user be able to select from all tables?

0 Answers  


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

0 Answers  






How to create a simple user defined function in ms sql server?

0 Answers  


What is the dbcc command and why is it used?

0 Answers  


What are the dmvs?

0 Answers  


Explain differentiate between a having clause and a where clause?

0 Answers  


What languages bi uses to achieve the goal?

0 Answers  


Is it possible to have more then one foreign key in a single table? if possible, is this the good way to design the table?

2 Answers  


Explain comment on transactions?

0 Answers  


Categories