"DavidM" <scandal_123@cox.net> wrote in message
news:5nmCb.31876$8y1.136165@attbi_s52...
> Hello --
>
> I have employee that frequently needs to copy SQL Server databases from
one
> server to another. The problem is, this employee doesn't know SQL Server
and
> doesn't seem to care about how he gets the database copied and moved over,
> as long as it works.
>
> I've emphasized to the employee that he should
>
> A) backup the current database to a disk file, move to the new server and
> restore..
>
> B) Detach the database, copy to another file, then re-attach both the
> original and new database.
>
> His methods are simply shutdown SQL Server and copy the .mdf and .ldf
files
> and re-attach on the new server.
>
> Is this acceptable?
>
> Will/can this cause problems?
>
> Sounds kind of corny to stop/restart SQL just to copy a database.
>
> Thanks
>
>
> --
> ...david
> http://www.micro-mess.com
> http://www.va-mustang.com
> If you wish to reply to me personally, please remove
> the "underline" from scandal_123@cox.net. The is done to avoid SPAM!
>
>

"DavidM" <scandal_123@cox.net> wrote in message
news:5nmCb.31876$8y1.136165@attbi_s52...
> Hello --
>
> I have employee that frequently needs to copy SQL Server databases from
one
> server to another. The problem is, this employee doesn't know SQL Server
and
> doesn't seem to care about how he gets the database copied and moved over,
> as long as it works.
>
> I've emphasized to the employee that he should
>
> A) backup the current database to a disk file, move to the new server and
> restore..
>
> B) Detach the database, copy to another file, then re-attach both the
> original and new database.
>
> His methods are simply shutdown SQL Server and copy the .mdf and .ldf
files
> and re-attach on the new server.
>
> Is this acceptable?
>
> Will/can this cause problems?
>
> Sounds kind of corny to stop/restart SQL just to copy a database.
>
> Thanks
>
>
> --
> ...david
> http://www.micro-mess.com
> http://www.va-mustang.com
> If you wish to reply to me personally, please remove
> the "underline" from scandal_123@cox.net. The is done to avoid SPAM!
>
>