SQL server

[EternalOptimist]

Whats the best way to create a new db that is based upon an extant one.

create from a backup
or
detatch , rename, attach



tia

[spoons]

Restore backup to new database name?

[JoJoGabor]

Yeah just restore. But if you are moving to another DB instance remember that you will have users in the database that dont exist in the master DB (orphaned users)

There is a stored proc you can use to link these up after you create the new logins.

Something like sp_restore_orphaned_users

[EternalOptimist]

thanks both
merci bow coops.



someone has been sh itting me