This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(140.8, 75%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESR%3C/text%3E%3C/svg%3E)
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
How about backup and restore . will the backup store at same location where server is installed or how we can change it and after restoring bak file . will it store existing records or overwrite it
(1) 176 GB is a small data file which implies a small database
In most cases we are using tapes of 8TB and backup files of 6 TB (the databases can be tens of TB but personally I found it useful to split to 6TB files for the sake of the the backup)
I am not speaking about specific name of file and I do not care if the file name extension is .mdf or .ldf or .ronen. This is not relevant to the discussion. SQL Server can use any name for the files. With that said, it is common to use extension of .mdf for the main file and .ldf for the other files. A database can include multiple files and filegroups.
Again, you cannot learn a full course in one thread in the forum! We can only give you a glance and in most cases it will do more bad than good since you get the feeling like you understand while the true is that it is not more than a glance.
I HIGHLY recommend NOT to do it, but if you want t jump from one topic to the other then search more information about SQL Server files and filegroups. I recommend to take a full ordered course (free or paid / online or offline -but full course in ordered steps)
I am sry but you are jumping from one topic to the other while you do not have the base. It is like asking someone in the Elementary School which did not learned math ask question about Quantum physics. We can keep answering but each answer will just open a new set of questions :-)
Start with these documents if you must and you don't want to learn in an ordinary course:
Hi Expert,
i just need a insert statement to be store in file where i will get following records for a table that sit
insert into table2
values('2022-02-02',22)
,('2022-02-03',22),
('2022-02-04',22)
i just need a insert statement to be store
What type of file? Who manage the file? how do you plan to read the file?
By the way, this is what database server do. All database servers do exactly this -> they store the data in a file and manage that file for you.
so you need to INSERT the data to the database and the server will add it to the file(s) (the database related files)
You question is not clear :-(
Hi Expert,
How can i export insert statement from database table into file
Expected output
insert into table2
values('2022-02-02',22)
,('2022-02-03',22),
('2022-02-04',22)
i tried this
https://www.mytecbits.com/microsoft/sql-server/auto-generate-insert-statements
but no luck
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(278.4, 12%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJL%3C/text%3E%3C/svg%3E)
Why a simple generate script task does not work for you? Does your table have a lot of data?
Do you run into any error by doing it?