Hi Guys,

I need to move a SQL2000 database to an overseas location. What would be the
best way to do this, bearing in mind that the database will be transported
on a CD.

Thanks

You nailed it in your Q. Backup the database to a file. Copy the file to
cd. Fedex

BACKUP DATABASE <<dbname>> TO DISK = 'Local Disk driver and file name'



--

----------------------------

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"Justin" <none> wrote

Thanks for the help. The guys here at my work feel that this solution is not
the best, and want me to 'package' the database. I was also origianlly
thinking of backing up the database, but they feel there is another
solution....

(this other solution should not include .csv files for each table)


"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote

There is NO better way.

The only other way I would even contemplate is

1. Exec sp_detach_db <<dbname>>
2. COPY the mdf and ldf file(s)
3. Put the original back. Exec sp_attach_db <<original db name>>,
<<original files>>
4. Cut the copies you made to CD
5. Fedex
6. Copy the files off from the CD at the client
7. Write a script that will do the sp_attach_db <<dbname>>, <<files>> at
the client



--

----------------------------

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"Justin" <none> wrote

Hi Justin,

Thank you for using MSDN Newsgroup!

I would like to follow up on this issue and see if you still have questions
about this issue. Should you have any questions, please feel free to post
here. Looking forward to your reply!

Best regards

Baisong Wei
Microsoft Online Support
----------------------------------------------------
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only. Thanks.

Hi Justin,

Thank you for using MSDN Newsgroup!

I would like to follow up on this issue and see if you still have questions
about this issue. Should you have any questions, please feel free to post
here.

For backup of SQL Server, you could refer to the article from the following
link:
HOW TO: Move Databases Between Computers That Are Running SQL Server
http://support.microsoft.com/?id=314546

Hope his helps!

Best regards

Baisong Wei
Microsoft Online Support
----------------------------------------------------
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only. Thanks.