-
I can't change the location of tempdb.
Hi All,
I can't change the location of tempdb.
I have SQLServer 6.5/Sp5a with NT 4.0 /Sp4.
Originally TempDB was on the disk.
I Executed the following command to take TempDB in To RAM.
sp_configure "tempdb in ram", 2
go
reconfigure
go
I Restarted SQL Server
it was ok.
Tempdb was in RAM
After that I executed Diskeeper Lite on the same disk for disk defragmentation.
ThereAfter I wanted to change Tempdb Location again and to place it on Disk
sp_configure "tempdb in ram", 0
go
reconfigure
go
I Restarted SQL Server
Executed sp_configure
name minimum maximum config_value run_value
.
tempdb in ram (MB) 0 2044 0 2
.
Although the config_value was 0 , the TempDB was not removed from RAM.
The Tempdb Database using the TEMP_DB device.
I saw that TEMP_DB device uses in RAM (with this script select * from sysdevices)
low high status cntrltype name phyname
.
16777216 16778239 2050 0 TEMP_DB IN_RAM
.
When I want to expand The tempdb database, I got this error message.
"Error 5016.[SQL Server] incorrect database or device name(s)"
What can I do?
Thanks in advance.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|