[dba-SQLServer] Backup

Martin,
   Check out SQL-DMO as an object refrence.  You can do all that you ask 
via this interface, choose db, Backup/restore.


Martin Reid wrote On 5/6/2004 12:36 PM:

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


-- 
-Francisco