al4629740
asked on
Copy database and rename in SQL 2008
I have a database named CAPRegisters. I would like to create a copy of this database with all the structure and data and rename the new database as CAPRegisters2012.
How can I do this?
How can I do this?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Just Restore Database with Different name and Source is DAtabase not Backup file
OR
Copy database option is also there.
OR
Copy database option is also there.
ASKER
Or should I just restore direct from database?