Copy database

  • Hi,

    I'm trying to copy a SQL SERVER 2000 database and I can´t with the following error:

    Transfer Status: Creating Users on destination database

    [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot use empty object or column names. Use a single space if necessary.

    I tried on the following ways:

    restore backup.

    copy database wizard

    export/import.

    Only using attach database I can copy that.

    It's very odd...

    Thanks a lot

    JAIME

  • Can you provide more details? Your description only generally states the problem.

    I.e. If you run a restore, what script do you use or what do you check in EM to restore the db? What error exactly is retured? Where is this error from?

    Steve Jones

    steve@dkranch.net

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply