Thanks Hari [n/t]

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Leo (anonymous_at_discussions.microsoft.com)
Date: 09/22/04 

Date: Wed, 22 Sep 2004 12:37:54 -0700

>-----Original Message-----
>Hi Leo,
>
>Answers to your questions:-
>
>1. Yes SQL 6.5 databases wil be safe. The upgrade wizard
will keep all the
>SQL 6.5
>DAT file safe. So even after upgarde ur users can access
the SQL 6.5 box.
>
>2. You cant use detach and attach , as well as you can
not backup and
>restore the SQL 6.5 databases to SQL 2000. Only option to
upgarde is UPGRADE
>WIZARD.
>This is due to lots of system architecture changes.
>
>
>3. Even if the upgrade fails you can use SQL 6.5
databases. But still i
>recomemnd you to take the SQL 6.5 database backup
including system databases.
>As well as before upgrade stop sql 6.5 and copy all DAT
files to a safe
>location
>
>4. Ypu could see books online for the detailed step by
step procedures on
>Upgrade as well as recomemndations.
>
>See the topic "Preparing to Upgrade from SQL Server 6.5"
in SQL 2000 books
>online.
>
>Thanks
>Hari
>MCDBA
>
>
>
>
>
>
>
>
>"Leo" wrote:
>
>> Hello
>>
>> I need to do an upgrade of an SQL 6.5 database to SQL
>> 2000. These servers are on different machines. Ny
question
>> (s) are:
>>
>> 1) If I run the Upgrade Wizard from the SQL2K will my
SQL
>> 6.5 db still be functioning? The reason for asking that
is
>> because I want to doa test upgrade first before I do
the
>> final upgrade, so users will still be working with the
6.5
>> version for a week or so after the test upgrade.
>>
>> 2) Can I detach the database on the SQL 6.5 and copy it
>> over to another machine with SQL 6.5 installed, attach
it
>> there and mess around with that database rather than
>> directly with the production database?
>>
>> 3) What is the worst scenario if the upgrade Wizard
fails?
>> Will it impact my SQL 6.5 database?
>>
>> 4) Any recommendations, best practises, step by step
>> articles? I would really appreciate any of that sort of
>> information
>>
>> Regards,
>>
>> Leo
>>
>.
>

Relevant Pages

  • Re: return multiple rows from sql statement
    ... Concatening SQL ... strings from input values is almost certainly a safe path to SQL ... All characters that are entered in the fields make their way into the database unaltered. ... The insert of what surprisinlgly was NOT a syntax error, but a string called "mysql_insert_id" into an integer field resulted in the value zero being put in. ...
    (comp.lang.php)
  • Re: SQL CE 3 and CF 1.0 support
    ... > We have designed our application so that all data access logic is ... > using our automated upgrade mechanism and at the same time upgrade the ... > from the engine download and the database upgrade delay). ... > I also know of applications that have been using SQL CE databases in RAM ...
    (microsoft.public.sqlserver.ce)
  • Re: Database owner after SQL 2005 upgrade
    ... I don't believe this is new behavior with SQL Server 2005. ... upgrade a SQL Server 7 database to SQL Server 2000, ... database in the compatibility mode that matches the product version it came ...
    (microsoft.public.sqlserver.setup)
  • Re: Desperate - WSS2.0 upgrade to WSS 3.0 trashed DB no either won
    ... You could install SQL 2005 Studio Management Express and attach the database from your SQL environment. ... to upgrade the database, but as I have stated earlier, I can't upgrade using ...
    (microsoft.public.sharepoint.windowsservices)
  • RE: SBS 2003 Unable to connect to database STS_Config
    ... MSDE to store SharePoint uses the MSSQL$SharePoint database, ... SharePoint named instance to full SQL. ... You cannot upgrade the Monitoring instance to SQL ... What I see is the SQL server group and under ...
    (microsoft.public.windows.server.sbs)