[dba-SQLServer] SQL Server 2005 - Copying a database

I've never had to do this, but I think that this approach would work. The
whole Management Studio UI (and Enterprise Manager before it) are nothing
but front ends that hide T-SQL commands. Whenever I want to know what SSMS
is doing under the covers, I execute the command of interest using the GUI
and then view the query syntax (include query with results).
Arthur

On Thu, Sep 10, 2009 at 8:24 AM, jwcolby <jwcolby at colbyconsulting.com>wrote:

> I need to programmatically copy a database to a new name (make a copy), and
> specify where the data
> file and log file goes.  Can anyone give me help in figuring that out?  I
> want to write a stored
> procedure to do this and call that from Access.
>
>