we are not seeing any blocking and we are not seeing any queries at that particular time 11:10:22:270AM.

I spid is looks different 1236s. Can you provide some DMVs to find the Querys which is causing this

How can we find out which transaction was running still 30 th july ??

Can we please provide the update asap .......

when i try to run the dbcc opentran() on that particular database its showing the below open transaction

Transaction information for database

Oldest active transaction:

...

Yes , Every weekend we are running rebuild index and update stats.

2.Mdf file intial size is 31,642 auto growth 200MB unrestricted growth.

LDF file intila size is 16,376 by...

The database is in simple recover model but the mdf file size is 32 Gb and ldf file size is 15 gb .I try to shrink the file but...

Thanks ,

I already created tables in test environment ?Now can i created only indexes in that database ??

I tried the below scenario but its not creating indexes.

generate script: right click DB in SSMS -> Tasks-> Generate Scripts...

we don't have enough disk space to take the backup in prod. Every day backup is taking by using third aprty tool . So by using this backup file its...

Thanks Hadrian .

Could you please provide the script plz

Could you please confirm , the query which one i updated earlier is the correct one or not ??

By using the above query i found the query like

update table name...

Gila @: we had problem last week . Some one updated the table with out where class. So the particular column is updated with same data in all the ...

Thanks for the update. I am trying to do that but i am getting errors . I don't have in depth knowledge on coding style . If it possible...

Thanks Nagarajan.

So this issue is related to APP or DB??

at that time we are seeing the below error from the application side

ERROR [nucleusNamespace.atg.dynamo.servlet.dafpipeline.DynamoServlet]

java.lang.RuntimeException: CONTAINER:atg.repository.RepositoryException; SOURCE:org.jboss.util.NestedSQLException: No ManagedConnections available within configured bl

ocking timeout ( 5000 [ms] ); - nested...