SELECT a.ServerName,a.DatabaseName,a.DatabaseSize,b.DatabaseSize,a.TrackDate as TO_DATE,a.TotalSize as TO_DATE_TOTALSIZE,b.TrackDate as FROM_DATE ,b.TotalSize as FROM_DATE_TOTALSIZE,
(a.TotalSize-b.TotalSize) AS GrowthSizeDiff_MB
FROM 
    (SELECT ServerName, DatabaseName , DatabaseSize , LogSize , TotalSize...

procedure has been created and execute that with parameter like but no values are return and history table Database_Size_Tracking records are avilable.

Exec SP_DATAGROWTH_ANANLYSIS '02-03-2020','11-03-2020','PUXKPIREP'

CREATE PROCEDURE  [dbo].[SP_DATAGROWTH_ANANLYSIS]...

• This reply was modified 4 years, 8 months ago by  SQL Galaxy.

Thanks Steve for your reply..

I tried this option already for PARTNER OFF at mirror server. but not able to bring database in EMERGENCY mode in Principal server.

ALTER DATABASE [DBNAME] SET EMERGENCY

Error Messages:

Msg 1468, Level 16, State 1, Line 1

The operation cannot be performed on database "DBNAME" because it is involved in a database mirroring session or...

yeah.. I agreed your points for what are the possible case database state to change the IN-Recovery mode

1. As per application workload TLOG file LDF huge size increase...

thanks Steve and Sue for your reply..
Database is online after recovery process completed. database size MDF size 25GB and LDF size 2GB SIMPLE Recovery mode options..
Transaction log is...

When either the READ_COMMITTED_SNAPSHOT or ALLOW_SNAPSHOT_ISOLATION database options.
08/02/2017 04:20:30,spid12s,Unknown,Service...

i have checked error log file and found those error messages.. Please suggest which resource are busy in terms of CPU, memory. I have checked these resource are normal state...