Re: Restoring data

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

anonymous_at_discussions.microsoft.com
Date: 03/22/04 

Date: Mon, 22 Mar 2004 09:35:35 -0800

Can I apply SQL 2000 tranaction logs to the original
database?
>-----Original Message-----
>Hi,
>
>No you can't restore a SQL 2K database onto a SQL 7
database. You can use
>DTS to move data OR BCP the data out of the 2K database
>and into the SQL 7 database.
>
>Reason:
>
>Information in the data files changed in sql 2000, so SQL
7 will not
>recognize
>a backup from SQL 2000. SQL 2000 is able to convert the
files from the SQL 7
>format to the
>SQL 2000 format, but it doesn't go the other way.
>
>Thanks
>Hari
>MCDBA
>
>
>
>"bbitzer" <juniper2000@hotmail.com> wrote in message
>news:11a6701c4102a$4ed2b880$a101280a@phx.gbl...
>> I am planning on restoring and converting a 6.5
compatable
>> DB on SQL Server 7.0 to SQL Server 2000. Both servers
are
>> identical in hardware and we will be switching the IP
>> addresses between the existing production server and the
>> conversion server, in order to launch the conversion as
>> the Production server. I will have down time to work
with
>> to run my conversion scripts. Both production DB's will
>> have the same data at this point. My question is, If
>> somthing goes horribly wrong where users are having
issues
>> with the connecting applications on the upgraded
database,
>> and I switch IP address back to the original production
>> server, what is the best way to apply any changes made
in
>> the SQL 2000 database during this time to the old
>> production database before bringing it back oline to the
>> users? I will have Trans log backups, can they be
restored
>> to a 6.5 compatible DB on a 7.0 server. What happens
after
>> Full and/or differential backups are applied to the SQL
>> 2000 database? Could I still revert then?
>
>
>.
>

Relevant Pages

  • Re: CREATE AGGREGATE failed because type Concatenate does not conform to UDAGG specification due to
    ... Go to the Database tab and click on the browse button next to the connection string. ... In the New Database Reference dialog, enter the details for the database where you want to deploy the assembly and create the user defined aggregate. ... I'm trying to do some CLR integration with sql server 2005. ...
    (microsoft.public.sqlserver.programming)
  • RE: help with emergency--sql server 2000 sp4
    ... I told my myself, I need to take a look at my testing database, I suddenly I ... some my production program gives invalid object error messge. ... We have two database instances on our server. ... Your ASP program failed to execute DML operations on your SQL Server after ...
    (microsoft.public.sqlserver.odbc)
  • CREATE AGGREGATE failed because type Concatenate does not conform to UDAGG specification due to meth
    ... Now register the assembly and the aggregate in the SQL Server database you want ... I'm trying to do some CLR integration with sql server 2005. ...
    (microsoft.public.sqlserver.programming)
  • Re: dbdebunk Quote of Week comment
    ... > a lot of really bad SQL programmers. ... But SQL does not have a pointer data type or the ... > being told to design a database. ... But why is little Cindy Lou Who employee ...
    (comp.databases.theory)
  • Re: DBMS and lisp, etc.
    ... Naively implemented with SQL, again for 10 ... (1 query for the initial orders, 1 query for each order for its ... soon as you upgrade to the SQL database. ... (eq (order-customer orderA) ...
    (comp.lang.lisp)