Re: SQL Server 7.0 to 2000
From: Chip (anonymous_at_discussions.microsoft.com)
Date: 03/06/04
- Next message: Billy Yao [MSFT]: "RE: Hardware Requirements"
- Previous message: Tibor Karaszi: "Re: Howto Recover a Corrupt(Suspect) Database"
- In reply to: Tibor Karaszi: "Re: SQL Server 7.0 to 2000"
- Next in thread: Andrew J. Kelly: "Re: SQL Server 7.0 to 2000"
- Reply: Andrew J. Kelly: "Re: SQL Server 7.0 to 2000"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 5 Mar 2004 23:26:38 -0800
Hi Tibor,
hmmm..I missed out the "a" in my post :-). I think SP3
needs prior installation of SP2 and so after some time MS
released SP3a which can be directly applied as soon as the
SQL Server 2000 is installed freshly. Thanks for the help
especially on pointing msdb issues and information on
Update Statistics.
Sincerely
Chip
>-----Original Message-----
>Chip,
>
>2] Make sure it is the "a" version: sp3a
>
>3] You cannot restore msdb across versions, and often not
even between
>service packs. However, you can script job and alert
definitions
>(right-click Agent in EM).
>
>5] SQL Server keep statistics about the column values for
your indexed
>columns (and even not-indexed columns). This is so that
the optimizer can
>determine the selectivity of a WHERE clause. However, the
way this
>statistics is represented differs between 7.0 and 2000.
Hence it is a good
>idea to run sp_updatestats after restoring or upgrading
from 7.0 to 2000.
>--
>Tibor Karaszi, SQL Server MVP
>http://www.karaszi.com/sqlserver/default.asp
>
>
>"Chip" <anonymous@discussions.microsoft.com> wrote in
message
>news:7d2d01c4032e$e7796c90$a301280a@phx.gbl...
>> Hi,
>>
>> I have a Low-end machine which runs SQL Server 7.0 SP4 &
>> IIS 5.0 on Windows 2000 Server SP4 - (24 x 7)
>>
>> We purchased a high-end Machine and we want to upgrade
the
>> databases & a dozen of websites from the above setup to
>> SQL Server 2000 Standard, IIS6.0 on Windows 2003 Server.
>>
>> Here are my thoughts.
>>
>> 1] Install Windows 2003 server
>> 2] Install SQL Server 2000 + SP3
>> 3] move msdb from 7.0 to 2000
>> 4] move User Databases from 7.0 to 2000
>> 5] Update Statistics [ I am not able to follow this
>> concept. Any better explanation is higly appreciated]
>>
>> Do I miss anything?
>>
>> Also If any IIS gurus are around.. plz point me to a
>> source to restore IIS5.0 backup on IIS6.0.
>>
>> Regards
>>
>> Chip
>
>
>.
>
- Next message: Billy Yao [MSFT]: "RE: Hardware Requirements"
- Previous message: Tibor Karaszi: "Re: Howto Recover a Corrupt(Suspect) Database"
- In reply to: Tibor Karaszi: "Re: SQL Server 7.0 to 2000"
- Next in thread: Andrew J. Kelly: "Re: SQL Server 7.0 to 2000"
- Reply: Andrew J. Kelly: "Re: SQL Server 7.0 to 2000"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
