Re: SQL 7 to SQL 2000
From: Keith Kratochvil (sqlguy.back2u_at_comcast.net)
Date: 02/08/05
- Next message: Dinesh Bhandare: "SQL hangs on NTBACKUP or thirdprty bakup or brestore a database"
- Previous message: Nimi: "SQL Mail"
- In reply to: Steve: "Re: SQL 7 to SQL 2000"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 8 Feb 2005 06:35:49 -0600
Great. You may find these articles helpful:
INF: Disaster Recovery Articles for Microsoft SQL Server
http://www.support.microsoft.com/?id=307775
INF: Moving SQL Server databases to a new location with Detach/Attach
http://www.support.microsoft.com/?id=224071
HOW TO: Move Databases Between Computers That Are Running SQL Server
http://www.support.microsoft.com/?id=314546
INF: Using the WITH MOVE Option with the RESTORE Statement
http://support.microsoft.com/?id=221465
PRB: User Logon and/or Permission Errors After Restoring Dump
http://www.support.microsoft.com/?id=168001
HOW TO: Transfer Logins and Passwords Between Instances of SQL Server
http://www.support.microsoft.com/?id=246133
PRB: "Troubleshooting Orphaned Users" Topic in Books Online is Incomplete
http://www.support.microsoft.com/?id=274188
How to Resolve Permission Issues When a Database Is Moved Between SQL
Servers
http://www.support.microsoft.com/?id=240872
SAMPLE: Mapsids.exe Helps Map SIDs Between User and Master Databases When
Database Is Moved
http://www.support.microsoft.com/?id=298897
Utility to map users to the correct login
http://www.dbmaint.com/SyncSqlLogins.asp
-- Keith "Steve" <Steve@discussions.microsoft.com> wrote in message news:A72D6C89-40CC-4D07-818B-B3A03F37B3B2@microsoft.com... > Keith; > > Thanks for the reply. Eventually I am going to upgrade the Existing server. > However I would like to copy the existing databases and import them into a > test SQL2K server first for testing purposes. > > I got a couple of ?? regarding that. > > 1.) Can one just use a BCP command to copy the dbs to an alternative > location or should I import the dbs. > > 2.) What do I have to do with the log files and transaction files after > copying the dbs into SQL2K? > > Thanks in advance. > Steve > > "Keith Kratochvil" wrote: > > > I have done it several times without any problems. Are you simply going to > > upgrade the existing SQL 7 machine to SQL Server 2000? The upgrade should > > go easy enough. As always, you should make sure that you have good database > > backups before you start anything like this. > > > > -- > > Keith > > > > > > "Steve" <Steve@discussions.microsoft.com> wrote in message > > news:E1C63A94-B419-4D77-BACB-7F78B927B95D@microsoft.com... > > > Hi all; > > > > > > Has anyone encountered compatability issues or the like with an upgrade > > from > > > 7 to 2K? > > > > > > I have a pretty "stock" SQL 7 server and wish to upgrade it to 2000. I > > have > > > read all the normal white papers on the upgrade but am sure there are some > > > "gotchas" out there. > > > > > > Any info would be appreciated. > > > > > > Thanks, > > > Steve > > > >
- Next message: Dinesh Bhandare: "SQL hangs on NTBACKUP or thirdprty bakup or brestore a database"
- Previous message: Nimi: "SQL Mail"
- In reply to: Steve: "Re: SQL 7 to SQL 2000"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
