February 18, 2016 at 2:03 am
Hello,
The tempdb files are stored in a RamDisk. There is almost 50GB free space in this RamDisk.
However I'm not able to increase the size of the tempdb data file by using:
USE [master]
GO
ALTER DATABASE [tempdb] MODIFY FILE ( NAME = N'tempdev', SIZE = 8388608KB )
GO
I have got the following error:
MODIFY FILE encountered operating system error 112(There is not enough space on the disk.) while attempting to expand the physical file 'E:\db_hawk_echo\tempdb.mdf'.
Does anyone has an idea how to solve this problem? The autogrowth option is also enabled on the tempdb database. This mechansim also does not work. MS SQL Server is not able to increase tempdb files when they are full.
Regards
Mike
February 18, 2016 at 7:55 am
mikeb80 (2/18/2016)
Hello,The tempdb files are stored in a RamDisk. There is almost 50GB free space in this RamDisk.
However I'm not able to increase the size of the tempdb data file by using:
USE [master]
GO
ALTER DATABASE [tempdb] MODIFY FILE ( NAME = N'tempdev', SIZE = 8388608KB )
GO
I have got the following error:
MODIFY FILE encountered operating system error 112(There is not enough space on the disk.) while attempting to expand the physical file 'E:\db_hawk_echo\tempdb.mdf'.
Does anyone has an idea how to solve this problem? The autogrowth option is also enabled on the tempdb database. This mechansim also does not work. MS SQL Server is not able to increase tempdb files when they are full.
Regards
Mike
"There is not enough space on the disk"
February 18, 2016 at 8:41 am
A RAM disk isn't any different from another disk to SQL Server. If you can't add space to the files on that disk, either you have no space, a quota limit, or permissions.
Can you expand this by smaller amounts? Say 1GB? You can use other prefixes to make this easier.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply