Hello: I have made backup of a data base in SQL 7.0 and I have been able it to recover in a SQL 2000 without problems, can this generate some kind to me of later problem in this restored database?You should be fine with the method you have chosen but you may have problems with logins. Also, double-check to make sure that customized objects have been restored as well - e.g. stored procedures, jobs, dts scripts ...
Check out the following article:
article1 (http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q246133&ID=KB;EN-US;Q246133&)
For an excellent in-depth article discussing moving databases from 7 to 2000, check out the following article - part 2 is more specific:
article2 (http://www.sqlteam.com/item.asp?ItemID=9066)|||For the login issues run SP_CHANGE_USERS_LOGIN REPORT which reports orphaned users and run WITH AUTO_FIX to fix the logins, refer to BOL for more information.
HTH
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment