the orig table will be truncated , after we get all the data out which is needed to be queried for analysis ..and those are logs..
hard part is since...

thanks. The changes are not that much ... `5-10 GB that's it per day on some DBs

Hi Keva,
Thanks for the message.
yes, this is for DR to start off and we are ok with 1-2 hours , EC2 DR instances being out of sync with...

Hi,
OK I used this query and then waitfor delay 00:01:00 and re run the same and got values.Subtracted 1st value from 2nd to get the transactions / second.

Thanks SSC Guru. they wanted to see some numbers to  justify increase of bandwidth, to move about 300 databases from one location to another geographical location.
What counters can justify...

Thank you Eirikur. I should have added , we don't use RDS but we will be using AMI's where I install SQL Server from scratch and will make a config...

yes, same table multiple databases

yes sir. I did it again to be safe.

Hi Jeff,

Yes I  rebuilt all indexes and updated all stats hoping that would help with this shrink file operation.

Thanks

Imran,

Thank you so much, That worked! Your great.

Any logic behind that?   I couldnt find this anywhere in google, most folks said recreate msdb, restore etc!...

dbcc shrinkfile (1,1024)
goal is to bring the data file back to 1 GB from the init size 6 GB.

Hi Jeff,
The initial size of msdb data file is 6 GB  and the tables are very small.

No matter what I do , to shrink the initial size...