211 reputation
13
bio website
location
age
visits member for 3 years, 5 months
seen Oct 14 at 9:00

Jun
30
awarded  Yearling
Jul
7
awarded  Nice Answer
Jul
6
comment tempdb in sql server
Select tempdb and try: SELECT * FROM sysfiles. This should work for SQL server 2000
Jul
5
comment tempdb in sql server
what version of sql server do you have?
Jul
5
comment tempdb in sql server
Can you try: select * from tempdb.sys.database_files and provide us the output?
Jul
5
comment tempdb in sql server
For the moment try restarting SQL server
Jul
5
comment tempdb in sql server
Does the machine have enough free space for the log file to grow?
Jul
5
answered tempdb in sql server
Jul
5
comment tempdb in sql server
I guess the only way to do this is accidentaly.
Jul
5
comment tempdb in sql server
+1. I guess you are right, recover mode is set to full instead of simple
Jul
5
comment tempdb in sql server
What is the recovery model for tempdb? Normally it should be simple.
Jul
1
awarded  Supporter
Jun
30
comment Backup Scenarios
What matter's is to help others, and exchange idea's isn't it?! Thank you all for the upvoting
Jun
30
awarded  Teacher
Jun
30
answered Backup Scenarios