469,602 Members | 1,977 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,602 developers. It's quick & easy.

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 40798
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 suresh191 | last post: by
4 posts views Thread by guiromero | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.