Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- select size/128,* from sys.sysfiles
- dbcc loginfo('monitoring')
- -- updated [monitoring] autogrowth to (chunk of 8 Gb)
- DBCC SHRINKFILE(monitoring_log, 1)
- select size/128,* from sys.sysfiles
- ALTER DATABASE [monitoring] MODIFY FILE ( NAME = N'monitoring_log', SIZE = 8GB )
- ALTER DATABASE [monitoring] MODIFY FILE ( NAME = N'monitoring_log', SIZE = 16GB )
- ALTER DATABASE [monitoring] MODIFY FILE ( NAME = N'monitoring_log', SIZE = 24GB )
- ALTER DATABASE [monitoring] MODIFY FILE ( NAME = N'monitoring_log', SIZE = 32GB )
- ALTER DATABASE [monitoring] MODIFY FILE ( NAME = N'monitoring_log', SIZE = 40GB )
- ALTER DATABASE [monitoring] MODIFY FILE ( NAME = N'monitoring_log', SIZE = 48GB )
- ALTER DATABASE [monitoring] MODIFY FILE ( NAME = N'monitoring_log', SIZE = 56GB )
- ALTER DATABASE [monitoring] MODIFY FILE ( NAME = N'monitoring_log', SIZE = 64GB )
- ALTER DATABASE [monitoring] MODIFY FILE ( NAME = N'monitoring_log', SIZE = 72GB )
- ALTER DATABASE [monitoring] MODIFY FILE ( NAME = N'monitoring_log', SIZE = 80GB )
- ALTER DATABASE [monitoring] MODIFY FILE ( NAME = N'monitoring_log', SIZE = 96GB )
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement