Backup Microsoft SQL server desktop engine 8.00.761

Dear Sirs.
I'm not an expert on SQL, and have a few questions. A friend has installed a
software using Microsoft SQL server desktop engine 8.00.761, and i'm trying
to help him setting up a backup to disk for him. The software using sql is a
commercial, with very poor builtin backup system. It's an economy software,
and You need to make backup of each firm manually 1 by 1, and when You have
600+ companies this isn't acceptable. I'd like to set up an automatical
backup (Full) to disk each night, i've set up a rotating swapping of external
disk system for him. I've noticed that when ever he adds a new company to
the SQL database, a new table under USER is added. Any tips on any simple
software that can be used? Does Microsoft SQL server desktop engine 8.00.761
have any built in backup features? Can i install to Microsoft SQL Express
2005 and try to get the SQL database working with that?
I tried a software called DMT SQL Backup manager 2.3.1.0 but it took 19
minutes to backup a database consisting of 570MB data, is this normal?
With regards
Erling HerstadPlease try Using
Litespeed and SQL backtrack from BMC software.
Thanks
Ajay Rengunthwar
MCTS
On Feb 26, 4:38=A0am, Erling Herstad
<ErlingHers...@.discussions.microsoft.com> wrote:
> Dear Sirs.
> I'm not an expert on SQL, and have a few questions. A friend has installed= a
> software using Microsoft SQL server desktop engine =A0 8.00.761, and i'm t=rying
> to help him setting up a backup to disk for him. The software using sql is= a
> commercial, with very poor builtin backup system. It's an economy software=,
> and You need to make backup of each firm manually 1 by 1, and when You hav=e
> 600+ companies this isn't acceptable. I'd like to set up an automatical
> backup (Full) to disk each night, i've set up a rotating swapping of exter=nal
> disk system for him. =A0I've noticed that when ever he adds a new company =to
> the SQL database, a new table under USER is added. Any tips on any simple
> software that can be used? Does Microsoft SQL server desktop engine 8.00.7=61
> have any built in backup features? Can i install to Microsoft SQL Express
> 2005 and try to get the SQL database working with that?
> I tried a software called DMT SQL Backup manager 2.3.1.0 but it took 19
> minutes to backup a database consisting of 570MB data, is this normal?
> With regards
> Erling Herstad|||You can use the the native backup commands. You can install the client tools
and connect to it to use the GUI to set up jobs. Also, you ought apply SP4.
That is the RTM version and is open to the slammer worm.
--
Jason Massie
www: http://statisticsio.com
rss: http://feeds.feedburner.com/statisticsio
"Erling Herstad" <ErlingHerstad@.discussions.microsoft.com> wrote in message
news:6E7DC668-A458-463C-8AF7-D54C3A842410@.microsoft.com...
> Dear Sirs.
> I'm not an expert on SQL, and have a few questions. A friend has installed
> a
> software using Microsoft SQL server desktop engine 8.00.761, and i'm
> trying
> to help him setting up a backup to disk for him. The software using sql is
> a
> commercial, with very poor builtin backup system. It's an economy
> software,
> and You need to make backup of each firm manually 1 by 1, and when You
> have
> 600+ companies this isn't acceptable. I'd like to set up an automatical
> backup (Full) to disk each night, i've set up a rotating swapping of
> external
> disk system for him. I've noticed that when ever he adds a new company to
> the SQL database, a new table under USER is added. Any tips on any simple
> software that can be used? Does Microsoft SQL server desktop engine
> 8.00.761
> have any built in backup features? Can i install to Microsoft SQL Express
> 2005 and try to get the SQL database working with that?
> I tried a software called DMT SQL Backup manager 2.3.1.0 but it took 19
> minutes to backup a database consisting of 570MB data, is this normal?
> With regards
> Erling Herstad
>|||Hi.
i'll have a look into the software you suggested.
"Ajay Rengunthwar" wrote:
> Please try Using
> Litespeed and SQL backtrack from BMC software.
>
> Thanks
> Ajay Rengunthwar
> MCTS
> On Feb 26, 4:38 am, Erling Herstad
> <ErlingHers...@.discussions.microsoft.com> wrote:
> > Dear Sirs.
> >
> > I'm not an expert on SQL, and have a few questions. A friend has installed a
> > software using Microsoft SQL server desktop engine 8.00.761, and i'm trying
> > to help him setting up a backup to disk for him. The software using sql is a
> > commercial, with very poor builtin backup system. It's an economy software,
> > and You need to make backup of each firm manually 1 by 1, and when You have
> > 600+ companies this isn't acceptable. I'd like to set up an automatical
> > backup (Full) to disk each night, i've set up a rotating swapping of external
> > disk system for him. I've noticed that when ever he adds a new company to
> > the SQL database, a new table under USER is added. Any tips on any simple
> > software that can be used? Does Microsoft SQL server desktop engine 8.00.761
> > have any built in backup features? Can i install to Microsoft SQL Express
> > 2005 and try to get the SQL database working with that?
> > I tried a software called DMT SQL Backup manager 2.3.1.0 but it took 19
> > minutes to backup a database consisting of 570MB data, is this normal?
> >
> > With regards
> > Erling Herstad
>|||Hi.
Do You have a link for the Client tools? And a link to SP4?
"jason" wrote:
> You can use the the native backup commands. You can install the client tools
> and connect to it to use the GUI to set up jobs. Also, you ought apply SP4.
> That is the RTM version and is open to the slammer worm.
> --
> Jason Massie
> www: http://statisticsio.com
> rss: http://feeds.feedburner.com/statisticsio
>
> "Erling Herstad" <ErlingHerstad@.discussions.microsoft.com> wrote in message
> news:6E7DC668-A458-463C-8AF7-D54C3A842410@.microsoft.com...
> > Dear Sirs.
> >
> > I'm not an expert on SQL, and have a few questions. A friend has installed
> > a
> > software using Microsoft SQL server desktop engine 8.00.761, and i'm
> > trying
> > to help him setting up a backup to disk for him. The software using sql is
> > a
> > commercial, with very poor builtin backup system. It's an economy
> > software,
> > and You need to make backup of each firm manually 1 by 1, and when You
> > have
> > 600+ companies this isn't acceptable. I'd like to set up an automatical
> > backup (Full) to disk each night, i've set up a rotating swapping of
> > external
> > disk system for him. I've noticed that when ever he adds a new company to
> > the SQL database, a new table under USER is added. Any tips on any simple
> > software that can be used? Does Microsoft SQL server desktop engine
> > 8.00.761
> > have any built in backup features? Can i install to Microsoft SQL Express
> > 2005 and try to get the SQL database working with that?
> > I tried a software called DMT SQL Backup manager 2.3.1.0 but it took 19
> > minutes to backup a database consisting of 570MB data, is this normal?
> >
> > With regards
> > Erling Herstad
> >
>