The reason I ask this is because it doesn't work. I haven't tried taking it offline yet because it is almost always in use. In the worst case I will attempt to take it offline and use "Copy Database" but I'm looking for alternatives first.
We want to make a copy to use in a test environment. Would it work if I did a one time Back Up/Restore? Or would there be some sort of error having two databases named the same on one SQL server? If not, would there be a way to change the name of database?
Even if the back up didn't work, we still have back ups of the primary database so we could always use those.
We are running MSSQL Server 2005