October 5, 2015 at 12:16 pm
I have around 300+ databases and I need to find out the recovery model for all the DBs, Number of VLF, size of the log file (Initial + autogrowth size). I can find that out by accessing each DB but it will be time consuming. Is there a script I can use which I can run in CMS (Central Management Servers) so it can run in all the servers? Please let me know if something is not clear or even if it's possible or not?
October 6, 2015 at 1:36 am
VLF's you will need to do some sort of loop like using sp_msforeachdb or building a dynamic query that goes and queries each DB individually.
But for the other bits, just query sys.master_files joined to sys.databases on each server and you will get the file information your after.
October 9, 2015 at 10:00 am
October 9, 2015 at 12:26 pm
MadAdmin (10/9/2015)
https://gallery.technet.microsoft.com/scriptcenter/SQL-Script-to-list-VLF-e6315249
Make it easier for others:
https://gallery.technet.microsoft.com/scriptcenter/SQL-Script-to-list-VLF-e6315249
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply