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 a small db that i need to restore back in time. Meaning i have the db running now, but some data have been overwritten, wo i need to restore a version from last night for instance.

But when i try to "Task > Restore > Database" i select the same db in both source and destination. I get an error "Cannot open the backup device... Operating system error 2(failed to retrive text for this error. Reason: 15105)"

What am i doing wrong?

share|improve this question
3  
It may sound harsh, but what you did wrong happened when you first created the backup: you failed to test the restore process. If you don't know how to restore your backups, you don't have backups. –  Ladadadada Jul 12 '12 at 20:24
    
This sounds like MSSQL but you might want to clarify –  Mark Henderson Jul 12 '12 at 20:34
    
@MarkHenderson Yeah, sorry. It is MSSQL. –  brother Jul 12 '12 at 20:38

2 Answers 2

The SQL Server is having a problem finding or accessing the backup file on the file system. Does the file exist in the location that is shown in the UI?

share|improve this answer

Try running SQL Server Management Studio "As Administrator". This is usually a permissions related issue.

share|improve this answer
    
Tried it, dident help :-( –  brother Jul 12 '12 at 21:42
    
So you ran the program as Admin? Are you also making sure that the SQL user has the correct permissions? Like SA? Check that as well. –  nojak Jul 12 '12 at 23:17

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.