>>Hi all, is there a way to copy all objects from one database to a new one without taking the database offline ? Pseudo code: Select * from mydatabase into mynewdatabase.
>
>You should be able to back up your database (without taking it offline) and then restore it under a different name.
>
>See this article which has the section showing how to do it.
>
>http://www.simple-talk.com/sql/backup-and-recovery/sql-server-2005-backups/
>
>HTH
Thanks Dmitry