Backup data from database.

Hi all experts,
I would like to know if there are any method to generate an SQL
insert statements which contain all the data inside one of my database?
I do not want to backup the mdf files. Thanks alot.
Thanks
Rena.You can use bcp.exe or DTS to export just the data. If you really want
Insert statements, Narayana created a procedure -
http://vyaskn.tripod.com/code/generate_inserts.txt.
Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
More than just Training
www.SolidQualityLearning.com
"rena" <rena@.hotmail.com> wrote in message
news:%23yvXBvHFEHA.3132@.TK2MSFTNGP12.phx.gbl...
> Hi all experts,
> I would like to know if there are any method to generate an SQL
> insert statements which contain all the data inside one of my database?
> I do not want to backup the mdf files. Thanks alot.
> Thanks
> Rena.
>|||... and a few other options:
http://www.karaszi.com/sqlserver/in...rate_script.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si> wrote in m
essage
news:eHYiUBKFEHA.2416@.TK2MSFTNGP12.phx.gbl...
> You can use bcp.exe or DTS to export just the data. If you really want
> Insert statements, Narayana created a procedure -
> http://vyaskn.tripod.com/code/generate_inserts.txt.
> --
> Dejan Sarka, SQL Server MVP
> Associate Mentor
> Solid Quality Learning
> More than just Training
> www.SolidQualityLearning.com
> "rena" <rena@.hotmail.com> wrote in message
> news:%23yvXBvHFEHA.3132@.TK2MSFTNGP12.phx.gbl...
>

Backup data during production time

I need to take a data backup for 10 GB avery active database during
production time. Is it affect the server performance? generate locks....
thanks
Backup doesn't lock data or wais for locks. But it will consume resources (reading all data,
possibly from disk if not in cache and writing the data to backup media).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"mecn" <mecn2002@.yahoo.com> wrote in message news:%231RMCKNtHHA.4600@.TK2MSFTNGP03.phx.gbl...
>I need to take a data backup for 10 GB avery active database during production time. Is it affect
>the server performance? generate locks....
> thanks
>

Backup data during production time

I need to take a data backup for 10 GB avery active database during
production time. Is it affect the server performance? generate locks....
thanksBackup doesn't lock data or wais for locks. But it will consume resources (reading all data,
possibly from disk if not in cache and writing the data to backup media).
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"mecn" <mecn2002@.yahoo.com> wrote in message news:%231RMCKNtHHA.4600@.TK2MSFTNGP03.phx.gbl...
>I need to take a data backup for 10 GB avery active database during production time. Is it affect
>the server performance? generate locks....
> thanks
>

Backup data during production time

I need to take a data backup for 10 GB avery active database during
production time. Is it affect the server performance? generate locks....
thanksBackup doesn't lock data or wais for locks. But it will consume resources (r
eading all data,
possibly from disk if not in cache and writing the data to backup media).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"mecn" <mecn2002@.yahoo.com> wrote in message news:%231RMCKNtHHA.4600@.TK2MSFTNGP03.phx.gbl...

>I need to take a data backup for 10 GB avery active database during product
ion time. Is it affect
>the server performance? generate locks....
> thanks
>