SQL Server Replication in AWS

• RGP

  SSCarpal Tunnel

  Points: 4381

  More actions

  January 11, 2019 at 5:01 pm

  #376809

  Hi,
  We have a SQL server replication setup from a non AWS server to AWS SQL Server.

  The transitional log file of the AWS instance database is full and doesn't allow to shrink the file, the option of expanding the drive also not there at the AWS instance.

  We tried to stop replication and start again, but still after some time the log is getting full at the AWS server and drive space is running out. What are the options here? Any ideas, suggestions ? 

  thanks!

• RGP

  SSCarpal Tunnel

  Points: 4381

  More actions

  January 11, 2019 at 5:06 pm

  #2018740

  
  The image of the storage being full is attached, also I have no option to reboot the SQL Server instance, its grayed out