Re: Upgrade Options - 7 to 2000
- From: "Andrew J. Kelly" <sqlmvpnooospam@xxxxxxxxxxxx>
- Date: Wed, 5 Oct 2005 09:50:56 -0400
If you do an upgrade in place all the data including Logins etc should be
intact. Just remember to backup up all databases (including master & msdb)
before you attempt this. These articles might be useful if you have to
restore or move any db's and recover logins.
http://vyaskn.tripod.com/moving_sql_server.htm Moving DBs
http://www.databasejournal.com/features/mssql/article.php/3379901 Moving
system DB's
http://www.support.microsoft.com/?id=314546 Moving DB's between Servers
http://www.support.microsoft.com/?id=224071 Moving SQL Server Databases
to a New Location with Detach/Attach
http://support.microsoft.com/?id=221465 Using WITH MOVE in a
Restore
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.dbmaint.com/SyncSqlLogins.asp Utility to map logins to
users
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
http://www.sqlservercentral.com/scripts/scriptdetails.asp?scriptid=599
Restoring a .mdf
http://www.support.microsoft.com/?id=307775 Disaster Recovery Articles
for SQL Server
--
Andrew J. Kelly SQL MVP
<tony.kennedy@xxxxxxxxxxxxxxxx> wrote in message
news:1128514146.173678.137160@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> Hi,
>
> I've read all the documentation about upgrading to 2000, but need some
> clarification on the options available. Currently we have a server with
> SQL Server 7 installed. We use SQL Server authentication extensively as
> the application utilising the database needs this.
>
> Am I correct in believing that if I overwrite SQL Server 7 install, I
> will lose logins,roles,users,jobs,operators and alerts?
>
> Will SQL Server 7 scripted jobs, operators and alerts update SQL Server
> 2000 correctly?
>
> How can I overcome the problem of losing logins,roles and users?
>
> While I understand that I can go with an online upgrade, having two
> instances is a complication that I could do without as this process
> needs to be carried out by non-DBAs on other servers.
>
> Thanks in advance for your help.
> Tony.
>
.
- References:
- Upgrade Options - 7 to 2000
- From: tony . kennedy
- Upgrade Options - 7 to 2000
- Prev by Date: Re: Log shipping
- Next by Date: xpsmtp
- Previous by thread: Upgrade Options - 7 to 2000
- Next by thread: Re: Log shipping
- Index(es):
Relevant Pages
|
