sql server dts:

kindly provide a solution for taking backup on multiple machine,
schedule based.

*** Sent via Developersdex http://www.developersdex.com ***

Where does DTS fit in to this?

That said you could use DTS using ExecuteSQL tasks against many SQL Server
connections (1 per Task) and execute a Backup Database statement. You would
then use SQL Server Agent to do the scheduling.

You can, and this is the more traditional approach, use Agent on each server
and schedule a job to backup your databases. This could be a job you create
yourself or through a maintenance plan.

You can also use Master/target servers to manage backups through a central
MSX server.

I presume this is what you are looking for. If not then please clarify

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"Preet Kanwaljit Singh Shergill" <preetsinghasr@hotmail.com> wrote in
message news:%232IWvQw8DHA.1596@TK2MSFTNGP10.phx.gbl...
[quoted text, click to view]

Hi,

From a central server you can create a batch file and use OSQL and SQL Agent
to schedule the job.

How to do:
--------------
Say you have server SQLA and SQLB

1. SQLA has database HRMS
2. SQLB has database Finance

From SQLA server you have to schedule backup of both servers, then in SQLA
server do

1. Create a BACKUPSQLA.SQL inside that

BACKUP database HRMS to disk='d:\mssql\backup\HRMS.BAK' with init

2. Create a BACKUPSQLB.SQL inside that

BACKUP database Finance to disk='d:\mssql\backup\Finance.BAK' with init

3. Create a batch file inside that (BACKUP.BAT)





OSQL -Uuser -Ppassword -SSQLA -iBACKUPSQLA.SQL -o'd:\mssql\backup\backup.log
'




OSQL -Uuser -Ppassword -SSQLB -iBACKUPSQLB.SQL -o'd:\mssql\backup\backup.log
'

4. Schedule this BACKUP.BAT file using SQL Agent Jobs to run at a specific
time.

Thanks
Hari
MCDBA





"Preet Kanwaljit Singh Shergill" <preetsinghasr@hotmail.com> wrote in
message news:#2IWvQw8DHA.1596@TK2MSFTNGP10.phx.gbl...
[quoted text, click to view]

I already have backup scheduled for 4 different times of the day, I was
looking for transfering this backup to multiple machines automatically,
so that in case the main server crashes, i still have copies of backup
on different machines.



*** Sent via Developersdex http://www.developersdex.com ***

Log Shipping? This is available in SQL Enterprise Edition, but you can also
implement your own in any edition, or perhaps just an additional section in
the job that copies the file to another server. Easy to do in T-SQL.


--
Darren Green
http://www.sqldts.com



"Preet Kanwaljit Singh Shergill" <preetsinghasr@hotmail.com> wrote in
message news:%23bZp7eV9DHA.1804@TK2MSFTNGP12.phx.gbl...
[quoted text, click to view]