|
database
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
How to take a BACKUP of a single or more Tables in Sql ServerI want to know that how to take a BACKUP of a Table in Sql Server.If
any one can help me with this issue. Thanks There is no way to backup a table per say. If you create a secondary file
group and place that table in the file group you can then do file group backups. But there are caveats to backing up at the file / filegroup level that you should be aware of. You can find more details about partial backup & recovery in BooksOnLine. -- Show quoteAndrew J. Kelly SQL MVP <ch.adila***@gmail.com> wrote in message news:1152829818.042798.264200@s13g2000cwa.googlegroups.com... >I want to know that how to take a BACKUP of a Table in Sql Server.If > any one can help me with this issue. Thanks > You could use DTS (SQL2000) or SSIS (SQL 2005) and export to a comma
delimited text file (or a *.mdb file). And the same file can then be imported into the same or a different SQL server file. WARNING: This method provides NO inherrent data security. NOT recommended for any form of production work. Only for weird, oddball, unusual, not normal situation. -- Show quoteArnie Rowland* "To be successful, your heart must accompany your knowledge." <ch.adila***@gmail.com> wrote in message news:1152829818.042798.264200@s13g2000cwa.googlegroups.com... >I want to know that how to take a BACKUP of a Table in Sql Server.If > any one can help me with this issue. Thanks >
Other interesting topics
|
|||||||||||||||||||||||