[dba-SQLServer] Backup

Thanks Marty

Anyone want this when I have written it let me know. In theory

It will allow

User to select db to back up
Select local folder
Select network folder
Backup to both locations
Name the backup file with the db name plus the date and time of backup

of course have to do the reverse and allow them to restore as well.

Martin


----- Original Message ----- 
From: "MartyConnelly" <martyconnelly at shaw.ca>
To: <dba-sqlserver at databaseadvisors.com>
Sent: Thursday, May 06, 2004 9:26 PM
Subject: Re: [dba-SQLServer] Backup


> 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
>
>
>
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
>
>