SQL Server Performance Forum – Threads Archive

SQL database Copy

I am using SQL2000. I want to copy the entire database to another machine which is not connected to LAN. This will be on another location. How do I copy the entire database onto a CD? what is the procedure? Thanks
Issolla (moved from Analysis Datawwarehouse forum)

See, if this helps:
http://support.microsoft.com/default.aspx?scid=kb;EN-US;314546 ———————–
–Frank
http://www.insidesql.de
———————–

What is the size of the database?
If its more than 700MB then its not possible to port SQL backup on a CD media, you must search the alternative to transfer the files via LAN connectivity. The KBA referred by Frank highlights movement of database files from one server to another, if not you can use the SQL backup file and RESTORE on the target server in order to get the database files. You can use COPY DATABASE WIZARD between the servers in order to accomplish the task.
Also refer to this linkhttp://www.databasejournal.com/features/mssql/article.php/2228611 for logins movement. In future post your thread in relevant forums. 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.

One way is to backup database with n devices up to 700Mb each one to copy on CD. Luis Martin
Moderator
SQL-Server-Performance.com All postings are provided â€œAS ISâ€ with no warranties for accuracy.

Backup to one file, then compressing with rar with multiples volumes 700Mb each,with the fastest compression method.<br /><br />Or use a DVD-R media <img src=’/community/emoticons/emotion-5.gif’ alt=’;-)’ /> they’re pretty cheap nowadays.. <img src=’/community/emoticons/emotion-5.gif’ alt=’;-)’ /> <br /><br />

]]>