Export table back up and restore

Question

Hi Expert,

How i can take table backup and restore again in sql server when more data is available at the time of import

create table table2

(col1 date, col2 char)

insert into table2
values('2022-02-02',22)

then took backup
at the time of restore found 2 more incremental records in table2

insert into table2
values('2022-02-03',22),
('2022-02-04',22)

how it will restore and backup with dates with new records

how it will restore and backup with dates with new records

Answer 1

you can create script for this table

right click your database --->>genarate script--->>choose specific database object(tables)-->>advanced(type of database script-->>schema and data)

Answer 2

Hi @Shambhu Rai ，

If you want to table level backup, a better approach is export the table data to a CSV file or other you can, and then reload the tables
or you can try to use the bulk cou utility

You better show clearly the errors you encountered, then we will be better able to help you, sometimes the script will probably crash due to the size
In general, it is recommended not to script the data, better script objects and import data

-------------

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 3

Hi Expert,
Is there any query or script to get data as below

Expected output
insert into table2
values('2022-02-02',22)
,('2022-02-03',22),
('2022-02-04',22)