Thanks to everyone for the replies. Some good info.

Perfect! Thanks!

Yeah...I think the separate DB thing is probably gonna be the way we have to go. I'm 99% sure that they're not gonna go for taking the images out...

Thanks for the reply. However, I don't see how striping the backups across drives will help. Currently, space is not an issue for us. Also, due to...

see this:

http://social.msdn.microsoft.com/Forums/en-US/sqlreplication/thread/5bc36369-8c53-41aa-9304-0b9c7205ec3d

Awesome! Thanks!

Well, I ran this script (please forgive the formatting);

SELECT

s.database_name,

m.physical_device_name,

cast(s.backup_size/1000000 as varchar(14))+' '+'MB' as bkSize,

CAST (DATEDIFF(second,s.backup_start_date , s.backup_finish_date)AS VARCHAR(4) +' '+'Seconds' TimeTaken,

s.backup_start_date,

CASE s.[type] WHEN 'D' THEN 'Full'...

Thanks!

I mean, I know you can't give me a definitive answer about performance without knowing our system specs. I just want to make sure this is possible, and that...

Thanks for the reply. Our subscriber is only going to be used for testing against "near-production" data, in case something is suspicious on our publisher. The publisher will,...