"Mauro D." <mauro.destro@spamsystems.com> wrote in message
news:zvVuc.84477$Qc.3343976@twister1.libero.it...
> Hi, I have a production database in MSSQL 2000 Standard Edition with about
> 2Gb of data.
>
> My problem is the weekly backup of the entire database: every sunday night
i
> copy all the data to another db (24 minutes) and after i made a normal
> complete backup (11 minutes) in a .bak file...
>
> There's any way to improve performance while copying data?
>
> Thanks a lot
>
> Mauro
>
>

"Mauro D." <mauro.destro@spamsystems.com> wrote in message news:<tw0vc.31747$Wc.1070299@twister2.libero.it>...
> "John Bell" <jbellnewsposts@hotmail.com> ha scritto nel messaggio
> news:8bXuc.1036$dw6.9496771@news-text.cableinet.net...
> > Hi
> >
> > It is not clear how you are copying the data! I assume this is a DTS job,
> in
> > which case a quicker solution may be to copy that backup file and restore
> > that onto the other server see:
> > http://support.microsoft.com/default.aspx?scid=kb;en-us;Q314546#9
> >
> >
> > John
>
> I make a copy of all db object with a VBscript inside a job.
>
> Can i make backup of a running db that archive 10 rows per second in 8
> different tables without losing any data?
>