471,889 Members | 2,337 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,889 software developers and data experts.

How do you "dump" a database with MS SQL?

Tried googling, but I guess I have the wrong terminology for MS
products.

Using PostgreSQL, or MySQL, if I wanted to tranfer a database from one
machine to another, I'd do a "dump" with a single command, such as:
mysqldump [databasename] > [path/filename]

Then I'd take the file generated and dump it back onto a new machine.

What's the process with MS SQL Server? Can someone point me in the
right direction to a webpage dealing with this?
--
[ Sugapablo ]
[ http://www.sugapablo.com <--music ]
[ http://www.sugapablo.net <--personal ]
[ su*******@12jabber.com <--jabber IM ]
Jul 20 '05 #1
3 40913
Take a look at the BACKUP and RESTORE commands in SQL Server Books Online.

BACKUP DATABASE <dbName> TO DISK = '<path>'
RESTORE DATABASE <dbName> FROM DISK = '<path>'

Thanks,
Ryan Stonecipher
Microsoft SQL Server Storage Engine.
"Sugapablo" <ru********@sugapablo.com> wrote in message news:sl***********************@dell.sugapablo.net. ..
Tried googling, but I guess I have the wrong terminology for MS
products.

Using PostgreSQL, or MySQL, if I wanted to tranfer a database from one
machine to another, I'd do a "dump" with a single command, such as:
mysqldump [databasename] > [path/filename]

Then I'd take the file generated and dump it back onto a new machine.

What's the process with MS SQL Server? Can someone point me in the
right direction to a webpage dealing with this?
--
[ Sugapablo ]
[ http://www.sugapablo.com <--music ]
[ http://www.sugapablo.net <--personal ]
[ su*******@12jabber.com <--jabber IM ]
Jul 20 '05 #2

"Sugapablo" <ru********@sugapablo.com> wrote in message
news:sl***********************@dell.sugapablo.net. ..
Tried googling, but I guess I have the wrong terminology for MS
products.

Using PostgreSQL, or MySQL, if I wanted to tranfer a database from one
machine to another, I'd do a "dump" with a single command, such as:
mysqldump [databasename] > [path/filename]

Then I'd take the file generated and dump it back onto a new machine.

What's the process with MS SQL Server? Can someone point me in the
right direction to a webpage dealing with this?
--
[ Sugapablo ]
[ http://www.sugapablo.com <--music ]
[ http://www.sugapablo.net <--personal ]
[ su*******@12jabber.com <--jabber IM ]

http://support.microsoft.com/default...&Product=sql2k

Simon


Jul 20 '05 #3
Hi

See http://support.microsoft.com/default...;en-us;Q314546 for the
various ways to move a database between two servers running SQL Server.

John

"Sugapablo" <ru********@sugapablo.com> wrote in message
news:sl***********************@dell.sugapablo.net. ..
Tried googling, but I guess I have the wrong terminology for MS
products.

Using PostgreSQL, or MySQL, if I wanted to tranfer a database from one
machine to another, I'd do a "dump" with a single command, such as:
mysqldump [databasename] > [path/filename]

Then I'd take the file generated and dump it back onto a new machine.

What's the process with MS SQL Server? Can someone point me in the
right direction to a webpage dealing with this?
--
[ Sugapablo ]
[ http://www.sugapablo.com <--music ]
[ http://www.sugapablo.net <--personal ]
[ su*******@12jabber.com <--jabber IM ]

Jul 20 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

43 posts views Thread by steve | last post: by
13 posts views Thread by Dave win | last post: by
59 posts views Thread by Jeff Bowden | last post: by
4 posts views Thread by jason.awlt | last post: by
53 posts views Thread by Sanders Kaufman | last post: by
reply views Thread by zermasroor | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.