Hi Erin,

I am not able to use your script. I am trying to capture 'AdventureWorks' data file and log file growth every week, using SQL agent job. Can you help...

Thank you Mr. Shawn!!!!

Thank you Shawn for your reply. I am bit confuse here, when I run your query I get total no. 97 (when i add all) but when I run Sp_who2...

When I run your query gives me 31.

when I run:

sp_who2

or

select * from sys.dm_exec_connections

gives me 10 (which is >50 spid) !!!!!

@muthyala_51: I did remove mirroring and the database (on mirror server) is in restoring mode).

My question is How do I find out the next Transaction log backup file to...

Thanks for your input.

Thank you.

Thank you for your input.

Thanks for your input

Thanks for your input

Thank you

Total DB size is 790 GB. doesn't this help? My question is what's the appropriate size for this large db after shrinking the log file.

Yes, one filled so I added another one. It is full recovery model and backing up T log every hour. What's the ideal size would be for log file?

i have T-log backup job every hour.

I never heard that can't have 2 log files. May be I am wrong. 1st drive was getting full so I added another drive