[dba-SQLServer] Backup

Problem is I have to use an Access form and let the suer

1. Select db to back up
2. Select a folder for the backup both local and network
3. Name the backup with teh date and time it occured

Of course I also have to do a restore form these files as well. All in the
access interface.

Martin



----- Original Message ----- 
From: "Djabarov, Robert" <Robert.Djabarov at usaa.com>
To: <dba-sqlserver at databaseadvisors.com>
Sent: Thursday, May 06, 2004 7:17 PM
Subject: RE: [dba-SQLServer] Backup


> Create a stored procedure (wrapper) that does the backup, and call it
> with pass-through query from Access.
>
> Robert Djabarov
> SQL Server & UDB
> Sr. SQL Server Administrator
> Phone: (210)  913-3148
> Pager: (210) 753-3148
> 9800 Fredericksburg Rd. San Antonio, TX  78288
> www.usaa.com
>
> -----Original Message-----
> From: dba-sqlserver-bounces at databaseadvisors.com
> [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Martin
> Reid
> Sent: Thursday, May 06, 2004 12:33 PM
> To: dba-sqlserver at databaseadvisors.com
> Subject: [dba-SQLServer] Backup
>
> no response to the request re backing up SQL Server via Access -anyone
> any
> examples?
>
>
> Martin
>
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
>
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
>
>