Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2004

    Unanswered: MS SQL problems after host migration

    My reseller web host (DIY) migrated a few weeks ago to a new data center.
    Unfortunately, my MS SQL databases were not migrating properly. (as well as
    other things). I have multiple sites that are not functional due to
    problems with their migration.

    When I looked at some of the databases, the table structure had been
    migrated, but not the data and apparently something else.

    Some of the databases of this error when trying to access it:
    --- error ---
    Error for database: DATABASENAME
    Microsoft OLE DB Provider for SQL Server error \'80040e37\'
    Invalid object name \'TABLENAME\'.
    --- end error---

    Some of the databases I can actually access but get:

    Microsoft OLE DB Provider for SQL Server error '80040e2f'
    Cannot insert the value NULL into column 'TABLENAME', table
    'DATABASENAME.dbo.TABLENAME'; column does not allow nulls. INSERT fails.
    Everything in all databases worked perfectly before the migration.

    They tell me that they have done what they can. They tell me that they are
    at the mercy of Psoft who assisted with the migration.

    Does anyone know of anything that can my host that can help them figure out
    the problem.

    Any assistance will be GREATLY appreciated.

  2. #2
    Join Date
    Nov 2004
    anybody have any ideas on this? My host still has not resolved this issue.

    Thanks in advance.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts