Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2002
    Location
    Lima - Perú
    Posts
    30

    Question Unanswered: Backup in SQL 7.0 and restored in SQL 2000

    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?

  2. #2
    Join Date
    Feb 2002
    Posts
    2,232
    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

    For an excellent in-depth article discussing moving databases from 7 to 2000, check out the following article - part 2 is more specific:

    article2

  3. #3
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    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
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •