Dump of databasse

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,
JerryI would just backup the database so the far-away can restore it on his
side.|||Jerry (notmyspam@.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, esquel@.sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx