Re: Planning to move SQL 7.0 to 2000 on to a new server

From: Andrew J. Kelly (ajkellynospam@attbi.com)
Date: 04/08/03 

From: "Andrew J. Kelly" <ajkellynospam@attbi.com>
Date: Tue, 8 Apr 2003 16:05:16 -0400

http://www.support.microsoft.com/?id=224071 Moving SQL Server Databases
to a New Location with Detach/Attach

http://www.support.microsoft.com/?id=314546 Moving DB's between Servers
http://www.support.microsoft.com/?id=246133 How To Transfer Logins and
Passwords Between SQL Servers
http://www.support.microsoft.com/?id=298897 Mapping Logins & SIDs after a
Restore
http://www.support.microsoft.com/?id=168001 User Logon and/or Permission
Errors After Restoring Dump
http://www.support.microsoft.com/?id=240872 How to Resolve Permission
Issues When a Database Is Moved Between SQL Servers 

-- 
Andrew J. Kelly
SQL Server MVP
"shyam venkatram" <shyam@vmware.com> wrote in message
news:OVhzN5f$CHA.1692@TK2MSFTNGP12.phx.gbl...
> Hi,
>
> I am planning to move a SQL 7.0 sp3 database to SQL 2K sp3 on a different
> server, and I have a few questions.
>
> I am thinking of using sp_detach_db and sp_attach_db. What databases to I
> need to do this other than user databases? (msdb, model etc.,)
>
> I am not sure if I can use msdb and model for sp_Detach _db and
> sp_Attach_db. if I dont then I will need to script the dts packages,
logins,
> jobs, alerts and operators.
>
> Any inputs is greatly appreciated.
>
> Thanks
> Shyam Venkatram
>
>

Relevant Pages

  • Re: Duplicating existing logins to a different domain
    ... > We are in the process of switching over to Active Directory and part of ... > switch involves creating a new domain with all the same logins as ... > SQL Servers and their databases and add the login, ...
    (microsoft.public.sqlserver.security)
  • Re: help on login issue
    ... http://www.support.microsoft.com/?id=224071 Moving SQL Server Databases ... Issues When a Database Is Moved Between SQL Servers ...
    (microsoft.public.sqlserver.server)
  • Restricting Access to BUILTINAdministrators
    ... I have a bunch of SQL servers that I inherited when I took over ... Grant that the System Administrator role to the NT Group and ... both accounts then you are denied access (Deny supercedes Grant). ... Looking at one of the databases my domain user is the owner and there is no ...
    (microsoft.public.sqlserver.security)
  • Re: Backup and Restore Databases
    ... How To Transfer Logins and Passwords Between SQL Servers ... Mapping Logins & SIDs after a Restore ... How to Resolve Permission Issues When a Database Is Moved Between SQL Servers ... > I'm restoring some databases and when i take a look in the> users that were created on these databases they do not> appear after the restore. ...
    (microsoft.public.sqlserver.server)
  • Migrating DTS to several locations
    ... I have over 182 DTS packages that reside on 54 SQL servers each is a diffrent ... server, the DTS packages pull data from SQL server databases, sybase & ... The plan is to move the databases to 4 SQL servers, ...
    (microsoft.public.sqlserver.dts)