Posted by Erland Sommarskog on 06/08/06 21:44

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/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

• Next in forum: Re: Scripting Databases
• Prev in forum: Re: Log Explorer vs. ApexSQL Log vs. SQL Log-Rescue
• Thread view: Re: Dump of databasse

[Reply to this message]