RE: restore a SQL7 user DB to a SQL2k DB

From: Rand Boyd [MSFT] (rboyd_at_onlinemicrosoft.com)
Date: 04/28/04

  • Next message: Rand Boyd [MSFT]: "RE: Incrementing a field by one" 
    Date: Wed, 28 Apr 2004 21:14:29 GMT

    You can resore the user database but not the master. You will need to
    upgrade to get the master database to SQL Server 2000.

    Rand
    This posting is provided "as is" with no warranties and confers no rights.

  • Next message: Rand Boyd [MSFT]: "RE: Incrementing a field by one"

    Relevant Pages

    • Re: SP_ in Stored Procedure Name
      ... Master database can be accessed from any database with out giving any ... with name SP_ in any user database while execution it checks for the same SP ... Then Why SQl Server search for the Stored procedure ...
      (microsoft.public.sqlserver.programming)
    • RE: Lost sa Password
      ... Restore from a known good backup of the master database is your best bet. ... Kevin McDonnell ... Microsoft Corporation ... This posting is provided AS IS with no warranties, ...
      (microsoft.public.sqlserver.security)
    • RE: activate logins
      ... Did you execute sp_change_users_login from the user database? ... Cindy Gross, MCDBA, MCSE ... This posting is provided "AS IS" with no warranties, ...
      (microsoft.public.sqlserver.security)