Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-01-22 : 17:11:00
|
| DONNAJ writes "After we moved one of our servers tempdb files to a new physical file all of our end users get access violation errors in the user apps when sql server is cycled. We have to update the status field to 2 in the guest sysuser record in tempdb and the access is then as it should be(yeah, I know,bad idea).Tempdb is actually 2 physical files, the first being 73M, the second 124M, both on the same drive but under different folder names and we have a clustered server setup.While the server is coming up we also get error messages:r:\mssql7\data\tempdb.mdf: Operating system error 112(There is not enough space on the disk.) encountered.MODIFY FILE encountered operating system error 112(There is not enough space on the disk.) while attempting to expand the physical file. Anybody have any ideas??? Thanks very much!!!!" |
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2002-01-22 : 17:34:09
|
| Looks like you have a couple of problems here.1. How did you move TempDB?2. Are you getting 'Access Violations' (a stack dump is being generated in th log directory) or users ar being denied access?3. It looks like your r: drive is out of disk space.4. How did you figure out changing the stats value worked? That is an internal value, and since you have changed it, I would be uncomfortable with the entire installation.-Chad |
 |
|
|
|
|
|
sql server 7 tempdb user access