Advertisement
Guest User

Untitled

a guest
Oct 31st, 2014
141
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.07 KB | None | 0 0
  1. select size/128,* from sys.sysfiles
  2.  
  3. dbcc loginfo('monitoring')
  4.  
  5. -- updated [monitoring] autogrowth to (chunk of 8 Gb)
  6. DBCC SHRINKFILE(monitoring_log, 1)
  7.  
  8. select size/128,* from sys.sysfiles
  9.  
  10.  
  11. ALTER DATABASE [monitoring] MODIFY FILE ( NAME = N'monitoring_log', SIZE = 8GB )
  12. ALTER DATABASE [monitoring] MODIFY FILE ( NAME = N'monitoring_log', SIZE = 16GB )
  13. ALTER DATABASE [monitoring] MODIFY FILE ( NAME = N'monitoring_log', SIZE = 24GB )
  14. ALTER DATABASE [monitoring] MODIFY FILE ( NAME = N'monitoring_log', SIZE = 32GB )
  15. ALTER DATABASE [monitoring] MODIFY FILE ( NAME = N'monitoring_log', SIZE = 40GB )
  16. ALTER DATABASE [monitoring] MODIFY FILE ( NAME = N'monitoring_log', SIZE = 48GB )
  17. ALTER DATABASE [monitoring] MODIFY FILE ( NAME = N'monitoring_log', SIZE = 56GB )
  18. ALTER DATABASE [monitoring] MODIFY FILE ( NAME = N'monitoring_log', SIZE = 64GB )
  19. ALTER DATABASE [monitoring] MODIFY FILE ( NAME = N'monitoring_log', SIZE = 72GB )
  20. ALTER DATABASE [monitoring] MODIFY FILE ( NAME = N'monitoring_log', SIZE = 80GB )
  21. ALTER DATABASE [monitoring] MODIFY FILE ( NAME = N'monitoring_log', SIZE = 96GB )
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement