This is existing Database mirror setup.

Followed as per your suggestion.

1. Created one new user/login at Principal Instance, it is reflected to Snapshots database also in Mirror instance after create Re-Snapshot...

Existing  Users and  permission inherited at snapshots database of Source DB. Try to connect snapshot database existing user in Mirror Instance not connected.

Login failed for user 'Username'. (Microsoft SQL Server,...

Yeah, I checked that first query. some servers all available drive retrieved and some servers not retrieved. could you suggest me what kind of permission required for fetching all logical...

this code EXEC master..xp_fixeddrives retrieve only available freespace.  but total allocated size not retrieved

Yes, I got it & working now.  ) is missing.

But the above query retrieve datafile mount point only. it not fetched all available logical drive name.

 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 5 years, 6 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.