I look at the system backup history tables to see what growth has been over time. It doesn't require any extra jobs or tables. I just run a script against...

If it's off line, it can't grow. Did you take backups before it went off line ? If so, you should have history.

If you don't have backups. Bring it online,...

Assuming you are doing regular FULL backups, you can look at the backup history and see the size of backups over time, which should give you a pretty good idea.

If...

Maybe I simplified the example code too much. There are actually 3 different WHERE clause variables, which complicates things:

if @location_id <>0

set @sql=@sql + ' and b._location_id = ' + @location_id

if...

The original post is much easier to understand. Consider someone looking at or modifying the code a year from now, and the risk of introducing bugs or errors. Simpler...

When you first setup the subscription, you have...

What types of transactions are occurring on the 2 databases ? Updates ?

What if PersonA updates Database_A.TableA.Cost = $25.00

while PersonB updates Database_B.TableA.Cost = $40.00

What should happen when you synchronize...

"...2. Shrink Database Task (All databases, Limit: 50 MB, Free Space: 10%)..."

Why ? Probably causes more problems than it solves.

Not sure if this applies, but I think when I set up replication across domains, I used a sql account in both domains with the same password, not Windows accounts.

Have you experienced problems ? or you're just curious ?

I have 32 bit everywhere except for 1 VM server running Windows 64 and SQL 64. No issues, although it's a...

Redgate, Idera & Litespeed give compressed, faster backups. You can get trial versions to test them out. I've used Redgate & Idera and have been satisfied with both. (mostly)

http://lmgtfy.com/?q=sql+scheduler

Did you not read your own thread on this same topic from the other day with many excellent replies ?

http://www.sqlservercentral.com/Forums/Topic813414-146-1.aspx

I would suggest you read them, then post specific questions in...

(Deleted due to posting error)

"nightly maintenance" sounds a bit on the too frequent side to me, unless there's an absolute need.