spid5 Encountered an unexpected error while checking the sector size for file 'DRIVE:\SQLFOLDER\DATA\TEMPDB.MDF'. Check the SQL Server error log for more information.
spid5 CREATE DATABASE failed. Some file names listed could not be created. Check previous errors.
spid5 Error: 823, Severity: 24, State: 6
spid5 I/O error 38(Reached the end of the file.) detected during read at offset 0000000000000000 in file 'DRIVE:\SQLFOLDER\DATA\TEMPDB.MDF'.
spid5 WARNING: problem activating all tempdb files. See previous errors. Restart server with -f to correct the situation.
- Hardware problems.
- Permissions problems.
- Check the accessibility and condition of the device in question.
- Run hardware diagnostics and correct problems, if possible.
- Make sure that the disk drive (for example, C:\, D:\) where tempdb is located has sufficient NTFS permissions for the accounts that need access (that is, the account with which you start the SQL Server services, the system account, the Administrators group; all of these account must have Full Control).