[thelist] Differing SQL Server Versions and Backups

[Jay Turley]

Hi all-

A long-time client (heck my recent employer 'till I went freelance a few
months ago) is using a proprietary web application I built and continue to
maintain.

The database used is SQL Server.

Our in-house development and staging servers are SQL Server 2000 SP4.
Frequently I would use DTS to pull down the production data from our web
host, as they too used SQL Server 2000. This was critical to performing bug
analysis and fixes without affecting production data or code.

Recently they upgraded to SQL Server 2005. As a result, DTS no longer works.
I can get backups of the database using a tool they provide called
myLittleBackup.

However, I have no idea how to get this data into our testing and staging
servers since they are running SQL Server 2000 instead of SQL Server 2005.

Any ideas? I'm kind of stumped.

Thanks!

-Jay Turley