Awal Perpustakaan Pelajari Kode Download Dukungan Komunitas Forums
Microsoft Developer Network >
> 
> 
Backup/Restore options

Answered Backup/Restore options

  • 22 Februari 2012 14:34
     
     
    Masuk untuk Memilih
    0

    I just realized that Backup and restore between different instances of MS SQL Server 2008 can fail:

    This is what I got when doing backup/restore between 2008 (64bit) and 2008 (32bit) servers. Is there an overview that shows the SQL Server versions where I can exchange backups (black list or white list) between?

    Are there backup options that I should use to get maximum compatability for restore?

    Any hints are greately appreciated, cheers Dirk

     

Semua Balasan

  • 22 Februari 2012 15:14
     
     Jawab
    Masuk untuk Memilih
    1

    Per MSDN  http://msdn.microsoft.com/en-us/library/ms186858.aspx

    • Backups created with Microsoft SQL Server cannot be restored to an earlier version of SQL Server.
    • The database being restored must be at least version 80 (SQL Server 2000) to restore to SQL Server 2008 R2. SQL Server 2000 or SQL Server 2005 databases that have a compatibility level less than 80 will be set to compatibility 80 when restored.

    Thanks
    Manish

    Please use Mark as Answer if my post solved your problem and use Vote As Helpful if a post was useful.

    • Disarankan sebagai Jawaban oleh Papy NormandModerator 22 Februari 2012 21:40
    • Ditandai sebagai Jawaban oleh KJian_ 28 Februari 2012 5:56
    •  
     
© 2013 Microsoft. All rights reserved.
|
Tanggapan Situs