June 3, 2004 at 5:57 am
Does anyone see a problem with restoring a backup made from a SQL 7 database to a SQL 2000 database.
-Kevin
June 3, 2004 at 6:57 am
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.
June 4, 2004 at 2:22 am
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.
June 4, 2004 at 11:32 am
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
August 26, 2004 at 1:06 am
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
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply