Re: ADP SQL Database Backup

Hum, in the case of SQL-2005 Express, I would recommand using the Windows'
Task Scheduler in combination with the command-line SQLCMD tool to
automatically call your database backups:

http://blogs.orcsweb.com/jeremy/archive/2006/11/06/Automating-Database-Backups-with-Microsoft-SQL-Server-2005-Express-Edition.aspx

http://www.sqldbatips.com/showarticle.asp?ID=27

http://www.sqlmag.com/Article/ArticleID/93621/sql_server_93621.html
http://www.sqlmag.com/Articles/ArticleID/93004/93004.html

--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: sylvain aei ca (fill the blanks, no spam please)


"Greg" <AccessVBAnet@xxxxxxxxxxxxxxxxx> wrote in message
news:68216AF0-33FC-4D04-9DAB-5CFE8AC91834@xxxxxxxxxxxxxxxx
I want to setup the Backup processes to run from SQL Server, but our
clients
are running SQL Server 2005 Express. I was under the impression that SQL
Server Agent was not included with the Express Edition so i figured it
could
be handled by Access instead.

I'll check my clients SQL Server 2005 Express installation to see if I see
the SQL Agent there. If Express does not have the Agent, how would I
schedule
the Backup jobs otherwise?

Thanks, Greg

"Sylvain Lafontaine" wrote:

See:
http://msdn2.microsoft.com/en-us/library/aa221622(office.11).aspx
http://msdn2.microsoft.com/en-us/library/aa221164(office.11).aspx
http://office.microsoft.com/en-us/access/HA012263091033.aspx

I never used them, so I don't know if you will run into any issue.
Finally,
thing such as backups should be set up on the SQL-Server to be done
automatically at regular intervals using the SQL-Agent. These kinds of
things shouldn't be set up to be called manually from a client post and
you
should do like me: keep yourself away from these commands.

--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: sylvain aei ca (fill the blanks, no spam please)


"Greg" <AccessVBAnet@xxxxxxxxxxxxxxxxx> wrote in message
news:F03E08DA-D808-41D3-94B3-33A9EB890ECC@xxxxxxxxxxxxxxxx
From the Access ADE menu system you have an option under the TOOLS,
DATABASE
UTILITIES menu to Backup, Copy and Restore SQL Server Databases. I've
run
the
Backup and Restore options and find these will serve my needs. With
research
I found the Docmd.TransferSQLDatabase and Docmd.CopyDataFile commands,
but
these two do not perform a simple backup as I'm looking for. Basically,
these
commands are not giving me the same results as selecting backup.
Selecting
the Backup option creates a single .bak file that can be restored by
using
the Restore command.

How can I run these commands for SQL Server Backups and Restores from
Access
using code instead? I can't find the equivilant commands.

Thanks.





.

Relevant Pages

  • Re: ADP SQL Database Backup
    ... or if the database is reasonably small; they just use the BACKUP ... DATABASE command via SQL Server ... I found the Docmd.TransferSQLDatabase and Docmd.CopyDataFile commands, ...
    (microsoft.public.access.adp.sqlserver)
  • Re: osql command reference?
    ... Books online is the best option to learn all commands and usage. ... * the complete desciption of BACKUP and RESTORE ...
    (microsoft.public.sqlserver.msde)
  • Re: Backing up my settings and files - noob alert :)
    ... >find that I need to know how to backup my data in case it happens again. ... we simply boot using a floppy, connect to the file server, and pour the ... you'll have to run both those commands as root. ... Access: Sun Jan 30 18:38:32 2005 ...
    (linux.redhat)
  • Re: Backing up my settings and files - noob alert :)
    ... >find that I need to know how to backup my data in case it happens again. ... we simply boot using a floppy, connect to the file server, and pour the ... you'll have to run both those commands as root. ... Access: Sun Jan 30 18:38:32 2005 ...
    (alt.os.linux.redhat)
  • Re: Problems Backing Up
    ... commands, and when something goes wrong, you find it more difficult to hunt down the problem. ... > I didnt have time last night to continue my exploration of the BACKUP ... >> Tibor Karaszi, SQL Server MVP ...
    (microsoft.public.sqlserver.server)
Loading