[dba-SQLServer] Creating Multiple copies of a database

Arthur Fuller fuller.artful at gmail.com
Mon Jun 11 16:00:04 CDT 2007


I can think of several methods, Jeff. My first choice would be SMO (in SQL
2005), or DTS (in 2000). There are lots of good examples for SMO usage.
Google same and you'll be there in no time.

Arthur


On 6/11/07, Jeff Barrows <Jeff at outbaktech.com> wrote:
>
> I have a need to create 35 copies of a SQL database, all with different
> names on the same server.  Is there a quick and easy way to do this?
>
> Jeff Barrows
> MCP, MCAD, MCSD
>
> Outbak Technologies, LLC
> Racine, WI
> jeff at outbaktech.com
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
>
>



More information about the dba-SQLServer mailing list