Post reply

Create another database (Copy from exisiting 1)

  • December 10, 2008 at 8:19 pm

    #126405

    Hi there,

    I have a database called A which is a master copy (readonly)

    I need another DB called B which users will access it

    how to do it?

    i need all objects(tables, triggers, SPs, views, indexex etc) to also be copied along with permission

    so bacially B should be exactly as A

    Cheers

    GB

  • December 10, 2008 at 9:14 pm

    #910805

    Two ways.

    1. script out everything in db A, including permissions and run it in B.

    2. Restore B from a backup of A, whack the data you need removed.

  • December 10, 2008 at 11:51 pm

    #910845

    Dear

    Backup the database A as normal.

    Restore the database and change the name to B.

    Thanx

    Thanks

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

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