How do I copy a database and all it's properties including data to another database

  • How do I copy a database and all it's properties including data to another database? Any suggestion will be appreciated.

  • You could use backup and restore.

  • My vote is for backup and restore.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • Backing up the current database and restoring it to the new database?

  • Yes

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • I get this errors while trying to restore to the new database:

    "Restore failed for sqlserver 'Servername"

    "System.data.sqlclient.sqlerror: The backup set holds abackup of a database other than the existing 'newdatabase' database"

    Please help!

  • Let's step back - what is the state of both databases? Are these two databases already in existence and do they serve production data?

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • Hi Jason,

    I got it situated now. I was probably doing the wrong thing. Thanks for your help 🙂

  • You're welcome. Thanks for posting back.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

Viewing 9 posts - 1 through 8 (of 8 total)

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