Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I have created a backup file by SQL query like this :

BackUp [DBName] to disk=N'Backup path'.

now i want to move it to another folder.but i recieve this error:

Cannot copy 'Backup file name':Access is denied. Make sure the disk is not full or write protected and that the file is not currently in use.

Note : i am sure that my disk is not full and not write-protected for my user.

share|improve this question

1 Answer 1

It would've been created by the account used by the SQL service. So is there a chance that you don't actually have permission on the file?

Alternatively, could it be that the backup process hasn't finished completely (is it caught up verifying it or something), and that the file is locked?

share|improve this answer
    
thanx for your help. i solved my problem. –  M_Mogharrabi Aug 23 '11 at 4:14

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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