none
(Sumber: milist SQL Server) restore database error running version RRS feed

  • Pertanyaan

  • Rekan - rekan ada yang pernah mengalami restore database muncul error seperti ini

     

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

     

    .bak sepertinya dari sql express, di restore di sql 2008

     

    cari2 di google tidak ketemu.. mungkin rekan2 ada info

     

    terima kasih 

    Selasa, 23 Agustus 2011 05.47
    Moderator

Jawaban

  • Sepertinya database engine yang akan dipakai untuk restore versinya lebih kecil dari file database backupnya.

    Kalau lihat errornya, file backup-nya dibackup menggunakan SQL 2008 R2 sedangkan yang versi yang terinstall adalah SQL Server 2008 (bukan R2)

    Dijawab oleh: Deni


    Agnes Sannie [MSFT]
    MSDN Community Support | Feedback to us
    Get or Request Code Sample from Microsoft
    Please remember to mark the replies as answers if they help and unmark them if they provide no help.
    Selasa, 23 Agustus 2011 05.48
    Moderator
  • Betul kata mas deni, versi database server-nya beda.

    Solusinya, setting backup ke SQL 2008 atau upgrade SQL 2008-nya ke SQL 2008 R2. Kalau mau generate SQL script yang bisa di-setting versi SQL server-nya, bisa dibaca di sini.

     

    Dijawab oleh: Tony Dermawan

     


    Agnes Sannie [MSFT]
    MSDN Community Support | Feedback to us
    Get or Request Code Sample from Microsoft
    Please remember to mark the replies as answers if they help and unmark them if they provide no help.
    Selasa, 23 Agustus 2011 07.02
    Moderator

Semua Balasan