SQL Server 2000 Backup

I have a SQL Server 2000 database backup that is about 204,996,89 kb in size.
I have been asked to copy this backup from a production server to a QA box, but it's taking me hours upon hours to copy; now was told to findout how to break the backup into small chunks before copying to the destination server box (QA).

My question, how do you break backups into smaller chunks or what tool to use?
FavorableAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

calinutzCommented:
I would recommend Total Commander that can split a file into equal files that can be regrouped at the destination.
"Split File" and "Combine Files" in the File Menu of the Total Commander.
You can use the trial version... or you can buy it. It's not that expensive

Also FreeCommander has a split file function in the File Menu. And it generates and executable file followed by the rest of the parts of the file... and upon destination you just place all the chunks in the same folder and run the executable.
This one is free
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Scott PletcherSenior DBACommented:
There are a number of Windows file splitter tools than you can use, I think some of them are free even for business use.

Of course you can also compress the backup prior to sending, then de-compress on the receiving end.  That will take a while also, but not as long as copying that much across a network.
0
25112Commented:
20GB backup- you can break into 4 DVDs, and take them across.. The DVD recording tool will take care of the details for you..
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Windows 2000

From novice to tech pro — start learning today.