How to take a BACKUP of a single or more Tables in Sql Server -- sql server (microsoft)

mrdenny
7/14/2006 9:44:22 AM

You can not backup just one table. You can only backup the database.
You can export a table by using DTS (SSIS if SQL 2005), The
Import/Export Wizzard in the GUI, or the BCP command line tool.

Denny

[quoted text, click to view]

Barry
7/14/2006 9:45:23 AM

[quoted text, click to view]

AFAIK, the only way to do this is move one or more Tables to a
different FileGroup and then Backup the FileGroup.

HTH

Barry

dbahooker NO[at]SPAM hotmail.com
7/18/2006 1:12:03 PM

or of course; you can use BCP in order to script the table out to a CSV
file; for example

-aaron

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server (microsoft)

sql server (microsoft) : How to take a BACKUP of a single or more Tables in Sql Server