ADP SQL Database Backup

[Guest]

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.

 

[Sylvain Lafontaine]

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.

 

[Guest]

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]

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/arc...icrosoft-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

 

[aaron.kempf]

or if the database is reasonably small; they just use the BACKUP
DATABASE command via SQL Server


you can put it in a sproc if you want

 

[Wei Lu [MSFT]]

Hi Greg,

How is everything going? Please feel free to let me know if you need any
assistance.

Sincerely,

Wei Lu
Microsoft Online Community Support

==================================================

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.