Job Failed

Question

Job Failed

Viewing 3 posts - 16 through 18 (of 18 total)

You must be logged in to reply to this topic. Login to reply

Brandie Tarvin SSC Guru Points: 173108 More actions · Answer 1

Unable to delete is different from unable to find.

Check the file locks.

Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

sudhakara SSCrazy Eights Points: 9425 More actions · Answer 2

Brandie Tarvin (5/18/2010)
Unable to delete is different from unable to find.
Check the file locks.

Can you tell me how to check this lock ?

Brandie Tarvin SSC Guru Points: 173108 More actions · Answer 3

Log onto the server. Right-Click My Computer and go to Manage. Many file locks can be found under Shared Folders -> Shares or Shared FOlders -> Open Files. Sometimes, though, a file attribute locks it to read only (or share perms do), so check the file properties.

And if SQL server (or one of its accounts) has the file locked open, the only way to resolve the issue, that I know if, is to take the service offline or restart the box. I've actually had to do that in the past.

You might want to talk to your server admin before implementing any of these solutions, though, just to see if they have a tool that can read locks better than what I've given you or if they have a way of breaking a lock without leaving it on the file.

Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.