Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

move and upgrade SQL server 7.0 to 2K

Status
Not open for further replies.
gc

gc

MIS
Mar 8, 2001
68
0
0
US
We will move our SQL server 7.0 to another NT server and upgrade to SQL server to 2000. What is the best way to do it? Upgrade first then move or move first then upgrade and we don't want interrupt users?
Please help and thanks a lot in advance!
george
 
Sort by date Sort by votes
Are you gonna have a new sql server machine..

If so..May be you can backup and restore on the new 200 machine...

The minutes you apply the last transaction log will be the time users will be down...

Are there users 24 hours...
 
Upvote 0 Downvote
Make sure and decide which version you want to go to (there are distinct differences between Standard and Enterprise edition for SQL 2000). It is a pain to have to change this later
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

V
  • Question
xp_cmdshell vs psexec - this SQL server forgets credential to an W10 share
Replies
0
Views
200
Volvere
V
gbaughma
  • Locked
  • Question
SQL Performance
Replies
11
Views
161
pjw001
pjw001
Auguy
  • Locked
  • Question
Move From SQL 2014 Express To Newer Version
Replies
2
Views
58
Auguy
Auguy
elly00
  • Locked
  • Question
create sql view using batch file
Replies
5
Views
116
Mike Lewis
Mike Lewis
Cpreston
  • Question
Seconds to minutes 2
Replies
5
Views
270
Chris Miller
Chris Miller

Part and Inventory Search

Sponsor

Back
Top