Much appriciated your helping with different solutions on time..
I need help:
Issue: Backup is happening on dialy basis to server A under F:\ drive.Need to move backup files on daily basis to Server B to F:\ drive. I need automation script which will copy backup from server A to Server B.[Windows Mechines both][Need to create a job][Backup files used for mirror purpose only] Any clarification please let us know.
what part of the process are you having the most trouble starting?
Do you want advice on automating it (setting up a sql server agent job / other auto task manager)
or the copying from server a to server b?
Transact Charlie Msg 3903, Level 16, State 1, Line 1736: The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION http://nosqlsolution.blogspot.co.uk/
There are a number of ways of doing this depending on what is available to you. You could use powershel, dos command file, ssis - the aove uses xp_cmdshell but that is disabled by default now and is often not allowed.
========================================== Cursors are useful if you don't know sql. SSIS can be used in a similar way. Beer is not cold and it isn't fizzy.
Not really - just make the package genric. Most people think of SSIS as hard coded values and controlling processing, once yoou get away from that it becomes a lot simpler. In some companies it's the only solution allowed so it is worth getting familiar with it. If yoou stick to one operation per package unless there is a very good reason not to then you have something that could be considered component based implementation and easy to enhance - and don't end up with everything in ssis just because you want one operation there.
========================================== Cursors are useful if you don't know sql. SSIS can be used in a similar way. Beer is not cold and it isn't fizzy.
SCRIPT REQUIRED
Posted - 05/28/2012 : 05:58:38
