Backup SQLExpress database

I have installed the community preview version of SQL Express (I think the April preview version). I can't find a way to backup a database created with the SQL Express UI tools. Can you point me in the right direction? Thanks, Leo

Hi,

I'm not very familar with Express Manager Tool. But if you do not find anything like dts or export/import function of dbs. I woul just write a small script that takes all tables into a dataset and would then write that dataset into a different database base or write it to a xml-file, using the writexml method of the dataset class.|||

You should be able to use the same T-SQL BACKUP syntax that works with any other database.

Something like:
SQLCMD -S machine\instance
SQLCMD> BACKUP DATABASE [foo] TO DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\foo.bak'
Books Online has the full syntax of the BACKUP DATABASE command.

|||thanks

Backup Software

Hi all
I have just installed my first sql (2000) server & have now to think about
what backup software to use.
Can anyone recommend what backup software works best with sequal? I have
Arcserve & BackupExec on my other servers.
Regards
AaronI think the best recommendation is to use SQL Servers own backup function to
backup the database to a file. Then you can use what ever backup program to
backup the file.
Regards
Steen
Aaron S wrote:
> Hi all
> I have just installed my first sql (2000) server & have now to think
> about what backup software to use.
> Can anyone recommend what backup software works best with sequal? I
> have Arcserve & BackupExec on my other servers.
>
> Regards
> Aaron|||You might find this useful:
http://www.microsoft.com/technet/pr...in/sqlops0.mspx
Andrew J. Kelly SQL MVP
"Aaron S" <aaron@.domain.com> wrote in message
news:OdnsfcnGFHA.588@.TK2MSFTNGP15.phx.gbl...
> Hi all
> I have just installed my first sql (2000) server & have now to think about
> what backup software to use.
> Can anyone recommend what backup software works best with sequal? I have
> Arcserve & BackupExec on my other servers.
>
> Regards
> Aaron
>|||It could be a matter of personal preference as they both will do the job.
Base on my personal experience (with the 200+ servers at our location), I
would go for Arcserve. I find Arcserve more reliable but not faster than
BackupExec.
Here is an article which compares BackupExec 9.0, Netvault 7, Acrserve v9,
and tretrospect 6.5:
http://sartryck.idg.se/Art/Backup_5_NOK122003e.html
Sasan
Senior DBA
"Aaron S" wrote:

> Hi all
> I have just installed my first sql (2000) server & have now to think about
> what backup software to use.
> Can anyone recommend what backup software works best with sequal? I have
> Arcserve & BackupExec on my other servers.
>
> Regards
> Aaron
>
>

Backup Software

Hi all
I have just installed my first sql (2000) server & have now to think about
what backup software to use.
Can anyone recommend what backup software works best with sequal? I have
Arcserve & BackupExec on my other servers.
Regards
AaronI think the best recommendation is to use SQL Servers own backup function to
backup the database to a file. Then you can use what ever backup program to
backup the file.
Regards
Steen
Aaron S wrote:
> Hi all
> I have just installed my first sql (2000) server & have now to think
> about what backup software to use.
> Can anyone recommend what backup software works best with sequal? I
> have Arcserve & BackupExec on my other servers.
>
> Regards
> Aaron|||You might find this useful:
http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/sqlops0.mspx
--
Andrew J. Kelly SQL MVP
"Aaron S" <aaron@.domain.com> wrote in message
news:OdnsfcnGFHA.588@.TK2MSFTNGP15.phx.gbl...
> Hi all
> I have just installed my first sql (2000) server & have now to think about
> what backup software to use.
> Can anyone recommend what backup software works best with sequal? I have
> Arcserve & BackupExec on my other servers.
>
> Regards
> Aaron
>|||It could be a matter of personal preference as they both will do the job.
Base on my personal experience (with the 200+ servers at our location), I
would go for Arcserve. I find Arcserve more reliable but not faster than
BackupExec.
Here is an article which compares BackupExec 9.0, Netvault 7, Acrserve v9,
and tretrospect 6.5:
http://sartryck.idg.se/Art/Backup_5_NOK122003e.html
Sasan
Senior DBA
"Aaron S" wrote:
> Hi all
> I have just installed my first sql (2000) server & have now to think about
> what backup software to use.
> Can anyone recommend what backup software works best with sequal? I have
> Arcserve & BackupExec on my other servers.
>
> Regards
> Aaron
>
>sql

Backup Software

Hi all
I have just installed my first sql (2000) server & have now to think about
what backup software to use.
Can anyone recommend what backup software works best with sequal? I have
Arcserve & BackupExec on my other servers.
Regards
Aaron
I think the best recommendation is to use SQL Servers own backup function to
backup the database to a file. Then you can use what ever backup program to
backup the file.
Regards
Steen
Aaron S wrote:
> Hi all
> I have just installed my first sql (2000) server & have now to think
> about what backup software to use.
> Can anyone recommend what backup software works best with sequal? I
> have Arcserve & BackupExec on my other servers.
>
> Regards
> Aaron
|||You might find this useful:
http://www.microsoft.com/technet/pro...n/sqlops0.mspx
Andrew J. Kelly SQL MVP
"Aaron S" <aaron@.domain.com> wrote in message
news:OdnsfcnGFHA.588@.TK2MSFTNGP15.phx.gbl...
> Hi all
> I have just installed my first sql (2000) server & have now to think about
> what backup software to use.
> Can anyone recommend what backup software works best with sequal? I have
> Arcserve & BackupExec on my other servers.
>
> Regards
> Aaron
>
|||It could be a matter of personal preference as they both will do the job.
Base on my personal experience (with the 200+ servers at our location), I
would go for Arcserve. I find Arcserve more reliable but not faster than
BackupExec.
Here is an article which compares BackupExec 9.0, Netvault 7, Acrserve v9,
and tretrospect 6.5:
http://sartryck.idg.se/Art/Backup_5_NOK122003e.html
Sasan
Senior DBA
"Aaron S" wrote:

> Hi all
> I have just installed my first sql (2000) server & have now to think about
> what backup software to use.
> Can anyone recommend what backup software works best with sequal? I have
> Arcserve & BackupExec on my other servers.
>
> Regards
> Aaron
>
>

backup schedule

SQL server 2005 is installed but can not schedule a backup job.
In the maintenance plan when selecting a new maintenance plan or maintenance plan wizard an error is produced which is:
'Agent XPs' component is turned off as part of the security configuration for this server.
I can see that the SQL Server Agent (Agent XPs is disabled). When trying to start this by right clicking on it in object explorer, the error message is 'unable to start service SQLAgent$SQL2005 on server serverName'. Service Logon failure

How can I scedule a back up job on this server?

Any thoughts please?

"Service Logon Failure" message means that user name and pwd provided for the service are incorrect. You can fix them in services snap-in (type services.msc in commnd line or try My Computer -> Manage -> Services And Applications -> Services -> double click on SQLAgent$SQL2005 service -> Log On tab )|||

Hi,

Went to the Logon Tab.

There is already a log on setup as admin

What next?

Thanks

|||

There is already a log on setup as admin

Then provide a correct password for him.

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
> >
>

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 Herstad
Please try Using
Litespeed and SQL backtrack from BMC software.
Thanks
Ajay Rengunthwar
MCTS
On Feb 26, 4:38Xam, Erling Herstad
<ErlingHers...@.discussions.microsoft.com> wrote:
> Dear Sirs.
> I'm not an expert on SQL, and have a few questions. A friend has installeda
> software using Microsoft SQL server desktop engine X 8.00.761, and i'm trying
> to help him setting up a backup to disk for him. The software using sql isa
> 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. XI'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
|||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.
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...
>
|||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:
>

Backup Maintenence plan question

I have recently installed some maintenace plans to perform database backups for an application database. The database is in full recovery mode so I have setup a full backup to be run once per day and then transaction log backups to run every 2 hours throughout the day. My question pertains to the coordination within SQL Server with respect to the database backup and the transaction log backups.

Let's say the full database backup is in progress and at the same time a trasnaction log backup is fired. What happens? Does SQL Server just skip the tran log backup since it won't be needed? or does it do the backup of the tran log anyway (in case the backup fails).

Another question would be when is it safe to delete the transaction log backup target file? Can it be assumed that after a SUCCESSFUL full backup that the transaction log backup can be deleted?

Since I have seperate maintenance plans in place here I am really trying to find out how/if these tasks are integrated within SQL Server. I'm more familiar with Oracle and the use of RMAN. Specifically for cleanups, RMAN knows what is safe to delete and what isn't and so it will keep a backup on disk if it feels it is needed. Is there similar functionality in SQL Server?

Hello,

You're correct: a full backup will block a tran log backup (until the blocking backup cmd completes), and vice-a-versa.

Following a successful full backup, you can safely delete all tran log backups taken prior to the full backup.

There is no equivelant RMAN functionality provided by SQL Server. There is, however the EXPRIEDATE and RETAINDAYS clause you can make use of in the backup command. Check out BOL for more info, but it may help you...

Cheers,

Rob

|||

Actually, that was the case in SQL 2000.

In SQL 2005, you can concurrently run database backup and tran-log backups. The tran-log backup would simply contain the range of LSNs that span the time of the full backup. It would be used as the starting point for rolling forward from restoring that full backup.