USE [master]
GO
ALTER DATABASE [tempdb] ADD FILE ( NAME = N'tempdev02', FILENAME = N'D:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\temdev02.ndf' , SIZE = 1048576KB , FILEGROWTH = 131072KB )
GO
ALTER DATABASE [tempdb] ADD FILE ( NAME = N'tempdev03', FILENAME = N'D:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\temdev03.ndf' , SIZE = 1048576KB , FILEGROWTH = 131072KB )
GO
ALTER DATABASE [tempdb] ADD FILE ( NAME = N'tempdev04', FILENAME = N'D:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\temdev04.ndf' , SIZE = 1048576KB , FILEGROWTH = 10% )
GO
ALTER DATABASE [tempdb] ADD FILE ( NAME = N'tempdev05', FILENAME = N'D:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\temdev05.ndf' , SIZE = 1048576KB , FILEGROWTH = 10% )
GO
ALT
在线增加tempdb数据文件
最新推荐文章于 2023-10-09 12:00:18 发布
这篇博客介绍了如何在不中断服务的情况下,通过SQL Server的ALTER DATABASE命令,逐步增加tempdb数据库的数据文件,详细列出了增加多个文件的T-SQL语句,并提供了最后验证文件添加是否成功的操作。
摘要由CSDN通过智能技术生成