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.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 PREEMPTIVE_OS_GETFILEATTRIBUTES

Author  Topic 

denis_the_thief
Aged Yak Warrior

596 Posts

Posted - 2010-11-25 : 16:10:37
Anyone have any idea on the wait type PREEMPTIVE_OS_GETFILEATTRIBUTES? I can't hardly find anything on the internet about this one.

Basically, we set AWE and PAE and since then, are backups are not working. Although we are backing up directly onto a different drive, although that was working fine before.

Sometime a Database or 2 will back up fine then the next one seems to hang indefinitely on wait type PREEMPTIVE_OS_GETFILEATTRIBUTES. Then the error message in the log is:

The operating system returned the error '64(failed to retrieve text for this error. Reason: 15105)' while attempting 'SetEndOfFile' on '\\Server\sql Backup\Database1.bak'.

jen
Master Smack Fu Yak Hacker

4110 Posts

Posted - 2010-11-25 : 16:47:12
http://sqlblogcasts.com/blogs/christian/archive/2008/06/06/new-sql-server-2008-wait-types-preemptive-and-ft.aspx



--------------------
keeping it simple...
Go to Top of Page
   

- Advertisement -