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
What is the minimum recommended amount of ram for sql server 2012 enterprise?
What is log shipping? Can we do logshipping with SQL Server 7.0 - Logshipping is a new feature of SQL Server 2000. We should have two SQL Server - Enterprise Editions. From Enterprise Manager we can configure the logshipping. In logshipping the transactional log file from one server is automatically updated into the backup database on the other server. If one server fails, the other server will have the same db and we can use this as the DR (disaster recovery) plan.
How would you add a section to a table?
Why are sql functions used?
Explain full-text query in sql server?
What’s the distinction between dropping a info and taking a info offline?
Do you know concepts and capabilities of sql server?
How can sql injection be stopped? : sql server security
Explain how many normalization forms?
Explain transaction isolation levels in sql server?
State a few properties of relational databases?
How to delete duplicate rows?
What is the difference between locking and multi-versioning?
Describe triggers features and limitations?
How to run sql server 2005 books online on your local system?