I am not sure why backpu is configure like this? msdb is system database and in SIMPLE recovery mode. But you are taking FULL and TLOG backup for the database....

There are multiple things to look for. In addition to above you can also check if tempdb is growing at the time of any maintenance?

HTH

Thank you and appreciate your overwhelming response.

Cheers!!

What I understood from above post is "Data gnerated at subscriber from 15 sites and replicated to central server". If this is the case central subscriber is the ideal option....

Please find following link which will give fair idea about SQL Server 2012 licence cost:

http://redmondmag.com/articles/2011/11/05/~/media/ECG/redmondmag/Images/2011/11/sql_server_2012_lic_lg.ashx

However get in touch with Microsoft for latest price; there may be differenct for the different...

Check information from DMVs'like sys.dm_repl_articles for article published and sys.dm_repl_tranhash for transaction being replicated.

Not getting exactly what's the issue. Provide error or screenshot for further investigation.

Check if you can rebuild index online.

What is the status of the database on old production server?

You can get the server configuration information by executing:

sp_configure

Other users and logins information can be obtained from catalogue views like sys.syslogins, sys.sysusers etc.

HTH

It all depends on how is your environment. It would be easy to maintain if you create a seperate job catagarize by the type of backup i.e. full, diffrential &...

Check if Change Data Capture (CDC) feature of SQL Server may help.

Good question for core DBA.

Try to capture error through profile.

Do you have any maintenance task for this database? If so track tlog during maintenance.

HTH