Hi John..thanks for your reply.
Can you use Backup and Restore to Backup an exisitng databse but restore the database under a different name.
I know the last time I tried this I was having some difficulty but it could have been due
to my inexperience with SQL Serever
Regards,
Gerard
>I dont beleive the Copy Database wizard is available in SQL Server 2005 Express.
>
http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx>
>You could just use backup and restore or sp_detach_db, sp_attach_db.
>
>Any help?
>
>Jon
>
>
>>Hi.
>>I Sql Server Management Studio, there is an option to "Copy" a Database in Tasks.
>>I cant see this in Sql Server Express man Studio though.
>>Am I just not looking in right place or is this something that's not available in SSMS Express ?
>>
>>Regards,
>>Gerard