October 1, 2007 at 1:22 am
I've been asked to restore 2 databases (sql version 7) in a server with sql version 2000 just want to ask if there can be any error/problem restoring databases from 7.0 to 2000? I've tried migrating the whole server from 7 to 2000 but haven't tried restoring some databases(version 7) to sql version 2000. Anyone experienced this kind of restoration? can you help me if there are any problems with this or there are none thanks in advance.
"-=Still Learning=-"
Lester Policarpio
October 1, 2007 at 3:03 am
Do check your database's compatibility level after the restore, and set it if you are not happy with it.
see sp_dbcmptlevel
Regards,
Andras
October 1, 2007 at 4:34 am
The 2 databases(version 7) that will be restored in different server is 70 and those databases in the server with ms sql version 2000 is 80 any problem with it? thanks in advance...
"-=Still Learning=-"
Lester Policarpio
October 1, 2007 at 4:44 am
Lester Policarpio (10/1/2007)
The 2 databases(version 7) that will be restored in different server is 70 and those databases in the server with ms sql version 2000 is 80 any problem with it? thanks in advance...
Only in case you want to make use of some of the 2000 features in your restored databases 🙂
Andras
October 1, 2007 at 4:48 am
Ahhhh ok thanks very much question cleared 😀
"-=Still Learning=-"
Lester Policarpio
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply