Forum Replies Created

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

  • RE: SQL database unexpected increase in size

    Here are results from the sp_helpdb

    campus6 54123.25 MBsa7Jul 25 200880Status=ONLINE,

    Updateability=READ_WRITE, UserAccess=MULTI_USER, Recovery=SIMPLE, Version=611, Collation=SQL_Latin1_General_CP1_CI_AS, SQLSortOrder=52, IsAutoShrink, IsAutoCreateStatistics, IsAutoUpdateStatistics, IsRecursiveTriggersEnabled, IsPublished

    1D:\mssql\data\campus6.mdf PRIMARY55421184 KBUnlimited10%data only

    2D:\mssql\data\campus6_log.ldfNULL1024 KBUnlimited10%log only

  • RE: SQL database unexpected increase in size

    DBCC SQLPERF(logspace)

    master 0.492187542.857140

    tempdb 46.4921930.373050

    model 0.492187577.777780

    msdb ...

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