Re: Restoring data

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Tibor Karaszi (tibor_please.no.email_karaszi_at_hotmail.nomail.com)
Date: 03/22/04 

Date: Mon, 22 Mar 2004 21:06:57 +0100

'Since you can't restore SQL2K db to 7,0, you won't have a starting point
for restoring SQL2K transaction log backups on to 7.0 either. 

-- 
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
<anonymous@discussions.microsoft.com> wrote in message
news:1170301c41034$156a2c40$a401280a@phx.gbl...
> 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: 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)
  • Re: LOB segment space usage
    ... SQL> SET SERVEROUTPUT ON ... SQL> SELECT * FROM V$VERSION ... PL/SQL Release 10.2.0.3.0 - Production ... You have UTF and your database charset that's why your LOBs have 2 ...
    (comp.databases.oracle.server)
  • Strings in UTF8 Database
    ... the only difference is that the first database is a UTF8 database and ... PL/SQL Release 10.2.0.2.0 - Production ... SQL> -- How long is a 40 charecter string? ...
    (comp.databases.oracle.server)
  • Re: Restoring data
    ... Can I apply SQL 2000 tranaction logs to the original ... database. ... >> addresses between the existing production server and the ...
    (microsoft.public.sqlserver.setup)
  • Fixed
    ... I also found this article that gives the proper way to move system dbs in sql 2008: ... The model exists where the master states it exists. ... This is the error log prior to detaching the model database. ...
    (microsoft.public.sqlserver.server)