If the database cannot be down, you need to backup, compress, ship, uncompress, and restore. There are tools like SQL LiteSpeed that can do this for you transparently. You should check them out if you need to do this a lot. If you are copying the file, look at robocopy. It's fast and free. RAR tends to shrink the backups better than zips. Derrick Leggett
If you don't want to depend on the third party tools then only way is to use BACKUP/RESTORE methodology by copy the file between the servers. If not ensure the second server SQL services are controlled by a domain account that has privileges on first server, so that you can try restoring the database directly on the network. DTS can be a partial solution to transfer data but not all the objects in a database. Satya SKJ Moderator http://www.SQL-Server-Performance.Com/forum This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
THen go for SQLLiteSpeed as suggested. Satya SKJ Moderator http://www.SQL-Server-Performance.Com/forum This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
Reading up on SQL Litespeed I have agreed to test it out. For anyone that has used it before can you please give me some pros and cons of the software. Thanks
I would transfer this thread to Third Party tools as you lean towards third party tool and will get required references. Satya SKJ Moderator http://www.SQL-Server-Performance.Com/forum This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
I don't know of any negative reasons not to use SQL Litespeed. It works great! ----------------------------- Brad M. McGehee, MVP Webmaster SQL-Server-Performance.Com
Check the latest version and more features round 64 bit version. Satya SKJ Moderator http://www.SQL-Server-Performance.Com/forum This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
