Backup and restore to another Server
-
Hi
My company will not spring for a real DBA or spend any money on managementr solutions and so I have been landed with the job of pseudo DBA. Now I know how to backup and restore a database, but I would like to know an elegant solution to automate the following.
We have 4 SQL 2000 STD Servers in remote offices. These are connected to head office by between 256k and 512k Frame Relay.
We have one central development database in head office and what I would like to be able to do is backup a database in the regions, compress it and then copy it to the head office server and then uncompress and restore it to 1 of 4 databases hanging of the head office server. (One for each region).
Each backup uncompresssed is about 2 GB
Does anyone have any idea's about how to do this?
-
What I do in a similar situation is I use schedualed jobs incorporating WINRAR (freeware)
"c:\program files\winrar\winrar.exe" a -m3 -o+ -rr8 z:\mssql\backup\History\sls_bwproduction_db_%1_prior.rar
then
xcopy "z:\mssql\backup\history\*prior.rar" "I:\QArchive\Quantum\Prod\"
all steps in a scdualed job. All you will have to do is add the step onm the other side to call winrar and unrar the file. then have a scripted job that does the resotre.
Hope this helps.
Hope this helps...
Ford Fairlane
Rock and Roll Detective
-
it should also be noted that winrar is much better option over the more "standard" compressions utils like pkzip and winzip - as these both have a limit of 4gb after that, the extractions become corrupt.
Although you did mention it was only a 2GB database, you may find it will grow, so its better to have that in place now, rather than having to firefight it later.
-- Alex
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply