How much data?

1,095 registered users | 0 active users | 0 LpH | Statistics
Login | Create New User

Welcome to IWETHEY!

Post #277,146 by crazy 1/1/07 6:09:20 PM Reply	How much data? How often will it run? Will the target system have new data that needs to be meshed? I can think of a couple of ways to do this, but need more info to determine a direction.
Post #277,235 by tangaroa 1/2/07 10:47:01 PM Reply	Re: How much data? About a gig uncompressed, transferred nightly. No need for incrementals if full backups are easier and less likely to cause corruption. It's an internal network so bandwidth is not a problem and we can completely wipe out and restore the database every backup. The MSDE2k system is only going to mirror what's on the SQL2005 system. It doesn't have any data of its own.

Backing up SQL Server 2005 to 2000 - (tangaroa) - (5) - Jan. 1, 2007, 05:41:33 PM EST

How much data? - (crazy) - (1) - Jan. 1, 2007, 06:09:20 PM EST

Re: How much data? - (tangaroa) - Jan. 2, 2007, 10:47:01 PM EST

You could export it via DTS - (ChrisR) - (2) - Jan. 1, 2007, 06:55:43 PM EST

I'd go with the last strategy - (tuberculosis) - (1) - Jan. 1, 2007, 07:17:58 PM EST

Thanks, both of you - (tangaroa) - Jan. 2, 2007, 11:43:47 PM EST

Hail entropy!
119 ms