| Author |
Topic |
|
pras2007
Posting Yak Master
216 Posts |
 Posted - 2010-03-23 : 13:02:03
|
| Hello All,I have 3 servers (prod, QA, dev)… The prod server has the following backups:- Full database backup- Differential database backup- Transaction log backupThe goal is to copy the backup’s files to the QA and dev environments. I was thinking to create a script that copies those files to the specified server… Does anyone know of a different way to accomplish this goal?Please advice.Thanks. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
pras2007
Posting Yak Master
216 Posts |
Posted - 2010-03-23 : 13:21:14
|
| Thanks for the quick response Tkizer! |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
DBA in the making
Aged Yak Warrior
638 Posts |
Posted - 2010-03-23 : 19:12:40
|
quote:
Originally posted by tkizer
You should only need to copy the full backup to the other servers.
Why?There are 10 types of people in the world, those that understand binary, and those that don't. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Kristen
Test
22859 Posts |
Posted - 2010-03-24 : 04:20:20
|
| Putting aside the needs of QA/DEV (I agree with Tara, I don't want DEV / QA data chaning every few minutes whilst I'm trying to work out how to fix a query!!)I think a lot of places they make Daily Full backup and Tlog backup every 15 minutes or so, but then copy them to tape once a day, so a failure of the disk may result in loss of a full day's data (maybe nearer to two days if the tape backup runs just before the SQL Full backup)I think copying backups to remote machine as soon as they are made is a useful failsafe.I'm interested to know how people do that?We do:MOVE Backups from FolderA (where they are created) to FolderB - this fails for any file that is "in use" - i.e. still being created (i.e. that file will be "moved", and then "copied", next time the bath job runs)COPY any file in FolderB to Remote-Server's-Drive and then MOVE the original file to FolderCOur database backup routine deletes "old" files (based on create date in database admin table); it checks if they exist in FodlerA or FolderCOur remote machine deletes all files that are older then 48 hours (assumed to have been copied to tape from MachineA by then) |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Kristen
Test
22859 Posts |
Posted - 2010-03-24 : 14:55:48
|
| Tara, is your tape backup once a day? and if so do you worry that Tlog backups during the day are "at risk" of disk failure?Maybe SANs or somesuch are more immune to disk controller failure or the like? |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2010-03-24 : 14:57:24
|
" We can't afford to move files around on the disks like that as our backup files are too large"Just a thought - would dedicated network card in each machine just to facilitate serverA-serverB file copy negate that? (plus a short piece of fibre optic cable connecting them, of course  ) |
|
|
|
|
How to copy backups to different server automatica