ADP SQL Database Backup

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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.
 
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
 
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
 
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.
 
Back
Top