Re: Attach DB from SQL7 into SQL2000

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

Date: Thu, 4 Nov 2004 12:56:07 +0100

This is all very strange, and something I've never heard of before. You should be able to attach and
restore 7.0 stuff into 2000. I also thought about database corruption. I suggest you open a case
with MS support and see if they can come up with anything. 

-- 
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"HugoSousa" <hugosousa@removethis.gestexper.pt> wrote in message
news:uN0foHmwEHA.3416@TK2MSFTNGP09.phx.gbl...
> CHECKDB found 0 allocation errors and 0 consistency errors in database
> 'ServiM2004Gco'.
>
> I didn't mention it before, but if i attach this DB to an SQLServer 7, all
> goes well.
>
> This is very odd to me...
>
>
> "Mike Epprecht (SQL MVP)" <mike@epprecht.net> wrote in message
> news:B6A99C34-781A-4437-A4F0-557D614DB803@microsoft.com...
> > Hi
> >
> > Looks like you have corruption in the DB on MSDE.
> >
> > Run DBCC CHECKDB on the database to see how bad it is.
> >
> > Regards
> > Mike
> >
> > "HugoSousa" wrote:
> >
> >> Hello all,
> >>
> >> We have one computer with MSDE 1.0 with one database. Now, we are moving
> >> to
> >> another server with SQL2000. When we try to attach the DB into the new
> >> server, an error message appears:
> >> --
> >> Server: Msg 8966, Level 16, State 4, Line 1
> >> Could not read and latch page (1:355872) with latch type EX. VerifyPageId
> >> failed.
> >> Server: Msg 8946, Level 16, State 1, Line 1
> >> Table error: Allocation page (1:355872) has invalid PFS_PAGE page header
> >> values. Type is 0. Check type, object ID and page ID on the page.
> >> Server: Msg 1813, Level 16, State 1, Line 1
> >> Could not open new database 'Aroma2004Gco'. CREATE DATABASE is aborted.
> >> Converting database 'Aroma2004Gco' from version 515 to the current
> >> version
> >> 539.
> >> Database 'Aroma2004Gco' running the upgrade step from version 515 to
> >> version
> >> 524.
> >> Database 'Aroma2004Gco' running the upgrade step from version 524 to
> >> version
> >> 525.
> >> Database 'Aroma2004Gco' running the upgrade step from version 525 to
> >> version
> >> 526.
> >> --
> >>
> >> This DB works fine in the old computer. We also tried a Backup/restore,
> >> but
> >> the error message is the same.
> >>
> >> I'm stuck. Any ideas of what can i do to overcome this situation?
> >>
> >> Best regards
> >>
> >> Hugo Sousa
> >>
> >>
> >>
>
>

Relevant Pages

  • Re: Problem adding new WFE
    ... On CA server version is 12.0.0.6020 ... The schema version of the database xxx_Content on xxx-xxx-m06 is not consistent with the expected database schema version on xxx-xxx-M01. ... The MOSS is pre SP1 and the current setup is 2 WFE, 1 Central Admin/Indexer, and SQL2K5 Cluster ... I am really confused by the last line in the error message which speaks to the MyComputer Zone???? ...
    (microsoft.public.sharepoint.portalserver)
  • Re: WSS 2.0 to 3.0 upgrade
    ... Well I ran the inplace upgrade and it didn't report any errors. ... time it took for the database to attach. ... Windows 2003 server, the SQL Server, restoring from backup to WSS 2.0, ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: NTDS ISAM DataBase Corruption
    ... I don't have any error messages when I restart the server. ... I don't have a systate backup. ... I get an error message database corruption using "esentutl /r ... Remove remnant entries of the corrupted DC from AD database. ...
    (microsoft.public.windows.server.active_directory)
  • Re: Event 1000 Windows SharePoint Services 2.0 Error
    ... First off what exact error message do you get? ... I've not seen Exchange pop connector get mangled by removing SQL so lets debug that separately. ... I had all SQL server instances to a complete stop. ... And this morning when I came to work, I discovered that when I try to access http://companyweb/, I receive the "Cannot connect to the configuration database." ...
    (microsoft.public.windows.server.sbs)
  • Re: Database Results Wizard Error - Urgent
    ... Results component on this page is unable to display database content. ... server that supports Active Server Pages."); ... I made the change you specified and the Error message it gives is as ... You may need to read Microsoft Knowledge Base Article 817029. ...
    (microsoft.public.frontpage.client)