Generate a dynamic sql script or backup of particular items of data in asp.net

Question

I am working on a project with multi users who can store their individual data. I am confused on how to proceed if a user wants to save his own data from multiple tables as a backup and retrieve it any time if the data is lost or corrupted if anyone has any clue on how to do that would be a great help.

Possible duplicate of Backup a single table with its data from a database in sql server 2008 — Paweł Tajs
– Paweł Tajs, Commented May 15, 2017 at 8:25

samithagun · Accepted Answer · 2017-05-15 08:05:49Z

0

You cannot backup specific tables to a .bak file, but you can export them to a CSV or script them out. What you can do if you want to back up specific tables is move them into a separate file group and back up that file group.

See Back Up Files and Filegroups for the documentation.

Below is an example.

--Back up the files in SalesGroup1.
BACKUP DATABASE Sales
   FILEGROUP = 'SalesGroup1',
   FILEGROUP = 'SalesGroup2'
   TO DISK = 'C:\MySQLServer\Backups\Sales\SalesFiles.bak';
GO

answered May 15, 2017 at 8:05

samithagun

70311 silver badges27 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Generate a dynamic sql script or backup of particular items of data in asp.net

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related