Make the copy of a SQL backup

Copy SQL backup files from one server to another server

[Aleyali]

Has anyone copied SQL backup files from one server to another server.

I have 2 windows 2000 servers that are not networked together. I would like to make the copy of a backup of the other server. Has anyone done this before?

[tomasz]

You can do it in two different ways.
First make backup one server one then do RESTORE (in SQL Enterprise) from device and point it to your bkp file.

Second is to stop SQL service or your db copy both db files (yourdbname_data.mdf and yourdbname_log.ldf) to new server and use ATTACH command in SQL Enterprise.

Use first method if your db is big.