Jump to content

1221 And 1102 Errors On Sql Db Backups

Recommended Posts


Server: Windows Server 2003

Client: Windows Server 2003 with SQL Server 2008 R2


getting the errors:


Can't access volume xxxx error -1102 (drive missing/unavailable)

Trouble reading files, error -1221 (can't access database)


happens on different databases every time.. no pattern..

Link to comment
Share on other sites

  • 2 weeks later...

wow sorry for the late reply!


>can you browse the databases from configure>volumes?



> What authentication methods are being used?


SQL auth


>Any errors in the event logs of the sql server?


* no, the errors are not even logged in the SQL logs... quite strange. i get a success log for the DB before and the DB after it, but nothing for the one that fails..

* nothing showing in system/application logs of sql server either...

Link to comment
Share on other sites

think i just found what it could be:



have checked and sure enough the hostname of this machine does differ from what's in the registry under:

HKLM\Software\Microsoft\Microsoft SQL Server\90\Machines\OriginalMachineName


will post back when i've had a chance to change this setting...

if this does work out to be the solution,.. only question is why it sometimes backs up successfully..

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...