I have a serious problem with SQLServer 6.5. The problem is that when I was trying to use a SELECT query over a big table, SQLServer raises an error that said the tempdb has no more space left.
So, I decided to create another device and expand the tempdb in the new device. I did it, but the data
section of the database continued reporting just 2 MB of space and the log has increased its size in the amount of the new database's size. For that reason, the query didn't work too.
Then I decided to put the tempdb in RAM rather that in a hard drive. I did it, or at least, I think I did it. The problem is that I'm no longer to load de MSSQLExecute, in the NT event log it says that there is a problem of login, it is: Error 1069 (The service did not start due to a login failure) ocurred while perfoming this sercice operation in the SQL Executive service.
The I tried to get the tempdb back to a hard drive with the following sentences:
sp_configure 'tempdb in RAM',0
reconfigure with override
But, it doesn't work, what really catches my attention is the fact that there is no tempdb.dat in the DAT directory, so, I don't know if I did something that could have dropped the database.
Is there any way to recreate the tempdb or load it into RAM memory and let SQL server to reconstruct all the information of the installed databases?
If not, Is there any way to create a backup from the