Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • René Andersen 238 posts 684 karma points
    Feb 19, 2015 @ 11:42
    René Andersen
    0

    MS SQL Backup / script

    Hi,

    I have generated a script from a online database and used the script on a local database and as far as I can see then it works without any problems. But I get these errors (about 50 errors) when I execute the script in SQL Express, see some examples below:

    1:
    There are no primary or candidate keys in the referenced table 'dbo.cmsContentType' that match the referencing column list in the foreign key 'FK_cmsContent_cmsContentType_nodeId'.

    2:
    Constraint 'FK_cmsContentXml_cmsContent_nodeId' does not exist.

    3:
    There are no primary or candidate keys in the referenced table 'dbo.cmsContentType' that match the referencing column list in the foreign key 'FK_cmsPropertyTypeGroup_cmsContentType_nodeId'.

    Are these errors normal or does it affect the new local installation?

    // René

  • Dave Woestenborghs 3504 posts 12134 karma points MVP 9x admin c-trib
    Feb 19, 2015 @ 11:44
    Dave Woestenborghs
    101

    I think that it is safer to just restore a backup of the online database on your local machine. That way you are sure all constraints are there.

    Using a generated script can miss some things.

    Dave

     

  • Osman Coskun 170 posts 404 karma points
    Aug 23, 2016 @ 14:37
    Osman Coskun
    0

    Hi Dave,

    What's the best procedure to restore a backup to online server? Do you know a tutorial?

    Cheers...

  • René Andersen 238 posts 684 karma points
    Feb 19, 2015 @ 12:17
    René Andersen
    0

    Hi Dave

    I tried your solution and it worked without any errors.

    Thanks!

    // René

Please Sign in or register to post replies

Write your reply to:

Draft