Create another database (Copy from exisiting 1)

• sqlcool

  SSC Eights!

  Points: 967

  More actions

  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

• Steve Jones - SSC Editor

  SSC Guru

  Points: 738632

  More actions

  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.

• forsqlserver

  SSCoach

  Points: 18902

  More actions

  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