MartyConnelly
martyconnelly at shaw.ca
Thu May 6 15:26:32 CDT 2004
Here is VB6 source code to do a lot of these procedures via SQL-DMO from Andrea Montanari's DBAMGR MSDE SQL Server Manager tool. http://www.asql.biz/DbaMgr.shtm In case you get lost in the Italian Look for DbaMgr2k 0.7.0 # 26/03/2004 (832kb) VB source download, free but need to register You might want to give the full package a whirl. Martin Reid wrote: >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 >> >> >> >> > >_______________________________________________ >dba-SQLServer mailing list >dba-SQLServer at databaseadvisors.com >http://databaseadvisors.com/mailman/listinfo/dba-sqlserver >http://www.databaseadvisors.com > > > > -- Marty Connelly Victoria, B.C. Canada