Is it possible to restore a SQL Server 7.0 database backup to MSDE?

• Paul Brennaman

  SSC Journeyman

  Points: 79

  More actions

  May 3, 2005 at 12:11 pm

  #110871

  I'm trying to restore a backup of a SQL Server 7.0 database to MSDE 7.0.  The error that I'm receiving states: "The database you are attempting to restore was backed up under a different Unicode locale ID (33280) or Unicode comparison style (0) than the Unicode locale ID (1033) or Unicode comparison style (196609) currently running on this server".  Does anybody know what the problem is?  Can you even restore a db backup from SQL Server to MSDE?

• adamcrv

  Hall of Fame

  Points: 3056

  More actions

  May 4, 2005 at 1:09 am

  #556671

  yes you can restore SQL server backups to MSDE

  sql server7.0 can only have one locale/collation, you may be able to install msde7.0 with a specific collation...

  maybe also think about UPGrading to SQL server 2000 or 2005 when it comes out...!!

  
  ------------------------------
  Life is far too important to be taken seriously

• Allen Cui-55137

  SSC Guru

  Points: 51650

  More actions

  May 4, 2005 at 7:15 am

  #556749

  MSDE only supports database that is less than 2 GB.

• Ajay Sharma

  Old Hand

  Points: 325

  More actions

  May 5, 2005 at 6:07 am

  #557021

  you right

• Jason Hall

  Hall of Fame

  Points: 3906

  More actions

  May 5, 2005 at 6:28 am

  #557026

  Are you trying to restore the master database? You can only restore the master database if it is the exact same build level (source and destination).