修改tempdb的 大小 size 和 maxsize growth
select name,physical_name,size,growth,max_size
,'alter database tempdb modify file(name='+name+',size=20480MB)' size
,'alter database tempdb modify file(name='+name+',filegrowth=10%)' growth
,'alter database tempdb modify file(name='+name+',maxsize=20480MB)' maxsize
,'alter database tempdb modify file (name = '+name+', filename =' +'''' + physical_name +''''+')' change_path
from sys.master_files where name like 'temp%' and type_desc='LOG'
,'alter database tempdb modify file(name='+name+',size=20480MB)' size
,'alter database tempdb modify file(name='+name+',filegrowth=10%)' growth
,'alter database tempdb modify file(name='+name+',maxsize=20480MB)' maxsize
,'alter database tempdb modify file (name = '+name+', filename =' +'''' + physical_name +''''+')' change_path
from sys.master_files where name like 'temp%' and type_desc='LOG'
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/29507357/viewspace-1786859/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
kettle 调用存储过程
下一篇：
SQLserver 文件收缩脚本
请登录后发表评论
登录
全部评论
