It's not even an option and should not be considered if you want to ensure
the integrity of your database. Even if you did get it to reattach you
could not be guaranteed the data was in a consistent state.
Andrew J. Kelly
SQL Server MVP
"Sender" <userdomain.com> wrote in message
news:eJ1xmuJSDHA.2228tk2msftngp13.phx.gbl...Server> I use to attach and detach the database when I have to move my SQL Server
> database from one SQL Server machine (source machine) to another SQLand> machine (destination machine). On the source machine I detach the database
> (not through T-SQL but) through Enterprise Manager. Then I copy the .mdfto> .ldf files in a disk and copy them to destination machine and attach them..mdf> this machines SQL Server.
> My questions is:
> (1) What would happen if we don't detach the database and just copy thejust> and .ldf files and attach it to destination machine? Is detachment of
> database is done just to make sure that no body is connected to your
> database while you are copying the .mdf and .ldf files?
> (2) What are the other reason for which we detach the databases? Is it> done for one application that is to move (copy) database to another
> location (destination machine)?
> Thanks in advance.