Sign in
 
HomeLibraryLearnDownloadsTroubleshootingCommunityForums

none
Restore .bak file of 2000 sql server to 2012 sql server

 > 

    Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hello All,

    I have restore the .bak file of MS 2000 to MS 2012 but I am getting following error message:

    Restore of database 'XYZ' failed. (Microsoft.SqlServer.Management.RelationalEngineTasks)

    ------------------------------
    ADDITIONAL INFORMATION:

    System.Data.SqlClient.SqlError: The database was backed up on a server running version 8.00.0194. That version is incompatible with this server, which is running version 11.00.2100. Either restore the database on a server that supports the backup, or use a backup that is compatible with this server. (Microsoft.SqlServer.SmoExtended)

    For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=11.0.2100.60+((SQL11_RTM).120210-1846+)&LinkId=20476

    Any good suggestion would be highly appreciated.

    Regards

    Khem


    Wednesday, July 03, 2013 9:09 AM
    |
    |

Answers

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote

    buy the error show that are trying to Restore Backup which is from SQL Server 2000 (8.00.0194)

    run the below command  to check the verion of you SQL server

    select @@version


    Ramesh Babu Vavilla MCTS,MSBI

    Wednesday, July 03, 2013 9:12 AM
    |
    |
  • Question
    Sign in to vote
    0
    Sign in to vote
    Yes Babu,  its my mistake thanks to pointed me...how to resolve above issue?
    Wednesday, July 03, 2013 9:16 AM
    |
    |
  • Question
    Sign in to vote
    2
    Sign in to vote

    Hi,

    it seems like a SQL 2000 database backup. Unfortunately, restore to SQL 2012 is not supported (http://msdn.microsoft.com/en-us/library/ms186858.aspx). You have to restore your database on an instance of SQL Server 2005, 2008 or 2008 R2 first and then back it up from there.

    Cris

    Excent

    Wednesday, July 03, 2013 9:20 AM
    |
    |
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hello Cris,

    Thanks for ur reply. Hope this ll work for me, ll be able to check tomorrow only.

    thanks,

    k

    Wednesday, July 03, 2013 1:00 PM
    |
    |
  • Question
    Sign in to vote
    0
    Sign in to vote

     its worked ........:)

    thanks

    Thursday, July 04, 2013 6:23 AM
    |
    |