To Backup a Table in Ms SQL Server

India
December 2, 2006 6:09am CST
is there any option to Backup a Table from the DataBase in Ms SQL Server. if any one have idea post here.
3 responses
• India
2 Dec 06
I think there is no option to backup a table alone from a database..If u need the table structure alone, then u can generate a script for that table using Enterprise manager..If u want the data also means then u can export into an excel file and then import back...
• India
5 Dec 06
thank you prakash. i think its only a way to backup a table from a database. but we may ask to the manager he can give us a solution. am i right...?
• India
2 Dec 06
we should export the table contents to excel or access by that you can take BAckup of a table in mssql server
@exchange (949)
• Australia
2 Dec 06
i know there is a way but i cant think of it at the moment . unable to post content, please try again... thank you!
1 person likes this