Search code examples
sql-servervb.netbackupsmo

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

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.

Solution

  • 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.