Advanced Minds

  • Decrease font size
  • Default font size
  • Increase font size
  • default color
  • red color
  • green color
FireBoard
Welcome, Guest
Please Login or Register.    Lost Password?
FireBoard Programing ASP Programing
mssql server MSSQL server 7 upgrade to 2000 (1 viewing) (1) Guests
Go to bottom Post Reply Favoured: 0
TOPIC: mssql server MSSQL server 7 upgrade to 2000
#6163
Lena (Visitor)
Click here to see the profile of this user
Birthdate:
mssql server MSSQL server 7 upgrade to 2000  
Hi! I'm planning the SQL Server 7 upgrade to MSSQL Server 2000. My plan is to do fresh install of SQL Server 2000 on new box, then backup sql server 7 db and restore this db on new sql server 2000 box. Is this correct? My understanding is that I don't have to install sql server 7 first on new box, then restore my db, and then upgrade sql server 7 to 2000. Thank you, Lena
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
#6164
Tibor Karaszi (Visitor)
Click here to see the profile of this user
Birthdate:
mssql server MSSQL server 7 upgrade to 2000  
Correct. SQL2K can restore SQL7 data_base_s. But not system data_base_s...
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
#6165
anonymous (Visitor)
Click here to see the profile of this user
Birthdate:
mssql server MSSQL server 7 upgrade to 2000  
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
#6166
Tibor Karaszi (Visitor)
Click here to see the profile of this user
Birthdate:
mssql server MSSQL server 7 upgrade to 2000  
You probably want to run sp_updatestats after the restore.
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
#6167
anonymous (Visitor)
Click here to see the profile of this user
Birthdate:
mssql server MSSQL server 7 upgrade to 2000  
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
Go to top Post Reply
Powered by FireBoardget the latest posts directly to your desktop
 
authorization failed 905 nieautoryzowano brak autoryzacji sprawdz autoryzacje
samochody prl tax rebate news anchors news headline walking pneumonia