Sorry the title was wrong- i am asking about AMAZON Web Services -EC2 and not RDS.

any suggestions????

Thanks for the reply. Can i know what is the difference between AWS EC2 and AWS RDS?

RIght now i am using Bastion server to RDP to SQL server.

FOr backup and...

I have tried Backup and restore from my local instance to AWS SQL instance and it worked.

Is i am missing something here?

Thanks.

Any particular ports need to be opened inorder to import data?

As from local SSMS i cannot connect to AWS SQL instance? then how can we import data into tables?

When I said files are growing what I mean to say is it's using the free space. I used the query

select

a.FILEID,

[FILE_SIZE_MB] =

convert(decimal(12,2),round(a.size/128.000,2)),

[SPACE_USED_MB] =

convert(decimal(12,2),round(fileproperty(a.name,'SpaceUsed')/128.000,2)),

[FREE_SPACE_MB] =

convert(decimal(12,2),round((a.size-fileproperty(a.name,'SpaceUsed'))/128.000,2)) ,

NAME = left(a.NAME,15),

FILENAME = left(a.FILENAME,30)

from

dbo.sysfiles...

I am really sorry if I missed something or I might not be able to convey the exact point. I never said there's a reduction in the file size....

As far as I know backup log truncates the log and we can reuse it. Log truncation cannot occur during a backup or restore operation or if we have replication...

I am sorry. There's no auto shrink enabled or no shrink job. There's log shipping setup on this database. The values captured at 9:53 AM clearly says both the...

Gila,

It's not working like that in our environment. Please find the attached document for the log sizes captured at different times.

Thanks,

I also agree with Gila. But the problem here is I am not observing the sequential increase in the file growth.

But the log is set to grow to 2TB. How come it's not growing to 2TB and then taking over the second log file.

:Whistling:

Please go through this article--

http://msdn.microsoft.com/en-us/library/ms152516.aspx

Delete rows in batches and don't forget to rebuild the indexes after deletes based on fragmentation percentage.