By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,419 Members | 1,609 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,419 IT Pros & Developers. It's quick & easy.

Dump of databasse

P: n/a
I have a sql 2000 database on my local machine that I need to get to a far
away server so he can make one like it on his server. The admin tells me I
need to make a dump of it and send it to him. I just don't know how to do
that. Can someone help me out?

Thanks,
Jerry
Jun 8 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a
I would just backup the database so the far-away can restore it on his
side.

Jun 8 '06 #2

P: n/a
Jerry (no*******@houston.rr.com) writes:
I have a sql 2000 database on my local machine that I need to get to a far
away server so he can make one like it on his server. The admin tells me I
need to make a dump of it and send it to him. I just don't know how to do
that. Can someone help me out?


BACKUP DATABASE db TO DISK = 'C:\temp\db.bak'
--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx
Jun 8 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.