how to backup of specific tables from database sql server and save .bak file in computer using vb.net code

928 views Asked by At

I want to backup some specific data of SQL database by using vb.net code. In fact i want to save this file as .BAK file and then i want to restore it.

I couldn't find anything. all the solutions in the web was about full backup of database and there was not any method to backup some tables via code.

1

There are 1 answers

2
Ross Presser On BEST ANSWER

SQL Server does not permit backing up a single table. Full stop. No provision is made for this whatsoever.

It does permit restoring a single table from a complete backup, but this does not seem to be what you want.