restoring a SQL 7 backup to SQL 2000 database

• ksexton

  SSCrazy

  Points: 2790

  More actions

  June 3, 2004 at 5:57 am

  #359828

  Does anyone see a problem with restoring a backup made from a SQL 7 database to a SQL 2000 database.

  -Kevin

• Antares686

  SSC Guru

  Points: 125444

  More actions

  June 3, 2004 at 6:57 am

  #508817

  Other than sometimes needing to rebuild the indexes and updateing the stats I have had not particualr issue. However I have heard complaints of performance differences of 7 databases move to 2000.

• bluenose

  Newbie

  Points: 9

  More actions

  June 4, 2004 at 2:22 am

  #508959

  Restoring SQL7 backups to SQL2000 databases is fine, i've done it with quite large databases and have not encountered any problems so far. You just cant restore a SQL2000 backup into a SQL 7 db, thats all.

• Linda Johanning

  SSCertifiable

  Points: 6727

  More actions

  June 4, 2004 at 11:32 am

  #509062

  I would say "be careful".  We had a database that was originally created in 6.5 and then upgraded to SQL 7 with no problems.  When I restored it to a SQL 2000 server the size tripled.  I was eventually able to shrink it back down, but was lucky to have the disk space to accommodate it.

  Linda

• Reddyka

  Newbie

  Points: 7

  More actions

  August 26, 2004 at 1:06 am

  #520642

  Guys, i no that u cant restore a db that was backed up in sql 2000 to sql 7. But i need 2 move a datase from sql 2000 to sql 7. Do u guys have any idea on how to go about doing this. I've run out of ideas now so i really need your help.

  Thanks guys

  Kasavan