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
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 |
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 |
What are the different types of backups that exist?
does physical index sort data
What is indexed view?
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?
What are the different types of Indexes available in SQL Server?
How to create a simple user defined function in ms sql server?
What is the dbcc command and why is it used?
What are the dmvs?
Explain differentiate between a having clause and a where clause?
What languages bi uses to achieve the goal?
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?
Explain comment on transactions?