Transfer DB to different server | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Transfer DB to different server

What is the quickest way to transfer an 80GB database from on server to another?
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.
Thanks a lot. My consern is performance wise. What would be the fastest way?
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.
]]>

Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |