Re: On demand backups
From: Tom Moreau (tom_at_dont.spam.me.cips.ca)
Date: 08/13/03
- Next message: Everett: "Remote Procedure Call Service Termination"
- Previous message: _M_: "Re: On demand backups"
- In reply to: _M_: "Re: On demand backups"
- Next in thread: _M_: "Re: On demand backups"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Wed, 13 Aug 2003 14:52:31 -0400
Tom's can be modified. ;-) Just have it execute the proc instead of the raw BACKUP:
osql -SMyServer -E -Q"exec MyBackupProc"
-- Tom --------------------------------------------------------------- Thomas A. Moreau, BSc, PhD, MCSE, MCDBA SQL Server MVP Columnist, SQL Server Professional Toronto, ON Canada www.pinnaclepublishing.com/sql "_M_" <here@gone.com> wrote in message news:uofpKqcYDHA.2448@TK2MSFTNGP09.phx.gbl... I like both yours and Tom's responses... Can yours be modified to use Windows Authentication or can Tom's be modified to save each backup in the time-date file name like yours ??? I'm sort of new to this SQL server stuff but I have had a semester of DB in college... "Wayne Snyder" <wsnyder@computeredservices.com> wrote in message news:OVu5IfcYDHA.2524@TK2MSFTNGP09.phx.gbl... > Dbo does not have to have backup database permission. A dbo can do anything > to the database that he/she owns.. > > Here is something short I did > 1. create this proc ( you need to adjust the db name) > create proc dbo.bu as > declare @fname varchar(128) > select @fname = 'c:\' + > db_name() + '_DB_' + convert(varchar(100), getdate(),112) > + datename(hh,getdate()) + datename(mi,getdate()) > --select @fname > backup database northwind to disk = @fname > > create a dos batch job like this > OSQL -Ulogin -Ppassword -Q"exec dbname.dbo.bu" > > when the job is run the backup occurs.... > > Then put a shortcut to the job on their desktop > > I would create a new login for the database which has ONLY backup > permissions, since the login and password are easily found... > > > -- > Wayne Snyder, MCDBA, SQL Server MVP > Computer Education Services Corporation (CESC), Charlotte, NC > www.computeredservices.com > (Please respond only to the newsgroups.) > > I support the Professional Association of SQL Server (PASS) and its > community of SQL Server professionals. > www.sqlpass.org > > > "_M_" <here@gone.com> wrote in message > news:#KbMuEcYDHA.2464@TK2MSFTNGP09.phx.gbl... > > Have a client that needs to do an "on demand" back up of a database. How > > can this be done ??? > > > > The database in question is used by the accounting department and the > > application uses the SA login to access the database. > > > > Any insight would be greatful. > > > > TIA > > > > > >
- Next message: Everett: "Remote Procedure Call Service Termination"
- Previous message: _M_: "Re: On demand backups"
- In reply to: _M_: "Re: On demand backups"
- Next in thread: _M_: "Re: On demand backups"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
