1

I am running scheduled daily backups using Windows 7 Backup on my Windows 7 Ultimate Laptop. It constantly gives me the following errors in the backup log:

Backup encountered a problem while backing up file C:\Users\sqlExpress2k8\Contacts. Error:(The system cannot find the file specified. (0x80070002))
Backup encountered a problem while backing up file C:\Users\sqlExpress2k8\Searches. Error:(The system cannot find the file specified. (0x80070002))

The user sqlExpress is the user that my sql server processes run as. These folders do not actually exist on my file system, and there have been several reboots to rule out any issues of stuck file handles etc.

Update: I installed Denali CTP, and ran it as a different user and I get error messages for the same two folders in the users home directory. I recently reinstalled windows on my laptop and still get the error for the sql service user:

Backup encountered a problem while backing up file C:\Users\sql_denali_service\Contacts. Error:(The system cannot find the file specified. (0x80070002))
Backup encountered a problem while backing up file C:\Users\sql_denali_service\Searches. Error:(The system cannot find the file specified. (0x80070002))
Improve this question
2
  • System Image backup or File backup?
    – Moab
    Feb 21, 2011 at 22:20
  • Moab, its a full scheduled backup, not an ad-hoc system image backup. Does that answer your question?
    – Justin Dearing
    Feb 21, 2011 at 23:37

2 Answers 2

Reset to default
0

Try turning the SQL server process(es) off and re-running the backup. SQL may be telling Windows that those folders need to be backed up (even though they aren't there).

Improve this answer
2
  • Josh, that really doesn't make much sense to me because those folder names seem "desktop-ish" However, I've stopped all my sql server instaneces and I'll see what the log says tomorrow morning.
    – Justin Dearing
    Feb 21, 2011 at 23:35
  • @Justin Dearing, Hmm, you're right. For some reason I thought they were a folder further down (inside AppData). Why not just copy the contacts and searches folder from your profile or another users profile, if for nothing else but to satisfy Microsoft's vision of what should be inside a users profile?
    – Windos
    Feb 22, 2011 at 0:10
0

I got this answer in a tweet by Vinod Kumar. He declined to post himself so I will self answer this question.

The second senario described in Microsoft KB979281 tells you that this error can be ignored, as well as how to make it go away.

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.