To Backup a Table in Ms SQL Server
By smanipasu
@smanipasu (350)
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
@prakash784 (358)
• 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...
1 person likes this
@smanipasu (350)
• 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...?
@ssujithkumar (364)
• 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
1 person likes this