SP to determine database file growth at intervals

  • Comments posted to this topic are about the item SP to determine database file growth at intervals

  • The script doesnt give me any information. The sysaltfiles table is always empty 🙁

    INSERT INTO [dbo].[tbl_sysaltfiles_1]([fileid], [groupid], , [maxsize], [growth], [status], [perf], [dbid], [name], [filename],[createlsn],[droplsn])

    Select [fileid], [groupid], , [maxsize], [growth], [status], [perf], [dbid], [name], [filename],[createlsn],[droplsn] From master.dbo.sysaltfiles

    The createlsn and droplsn columns do not exist in master.sys.sysaltfiles

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply