[dba-SQLServer] Backup

I've written something like this but would happily view yours and steal
its best parts :)

-----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 5:22 PM
To: dba-sqlserver at databaseadvisors.com
Subject: Re: [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
>
>

_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com