>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
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham