Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
seshagirirao
Starting Member
1 Post |
 Posted - 2012-05-28 : 05:58:38
|
| Hi Team,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.Regards,-Seshuseshu |
|
|
Sachin.Nand
2937 Posts |
Posted - 2012-05-28 : 09:34:36
|
| use Robocopy.After Monday and Tuesday even the calendar says W T F .... |
 |
|
|
Transact Charlie
Master Smack Fu Yak Hacker
3451 Posts |
Posted - 2012-05-28 : 12:35:15
|
| 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 CharlieMsg 3903, Level 16, State 1, Line 1736:The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION http://nosqlsolution.blogspot.co.uk/ |
|
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2012-05-29 : 09:58:29
|
| Here's an SP that will copy files - uses the filename format to get the latest to copy.http://www.nigelrivett.net/SQLAdmin/s_CopyLatestBackup.htmlThere 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. |
|
|
|
Sachin.Nand
2937 Posts |
Posted - 2012-05-31 : 02:30:40
|
| SSIS ???Its a nightmare to have those permutations combinations in the SSIS package when you have different set of of backups to be maintained.After Monday and Tuesday even the calendar says W T F .... |
|
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2012-05-31 : 03:39:51
|
| 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