Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Express Edition and Compact Edition (2005)
 Major Problem

Author  Topic 

SilencerGM
Starting Member

4 Posts

Posted - 2008-04-07 : 04:38:20
For some reason when I'm trying to restore a back up, I'm encountering this problem, I've asked numerous people and been in and out of chatrooms all day and night, has anyone got any idea what to do?



/Sil

RickD
Slow But Sure Yak Herding Master

3608 Posts

Posted - 2008-04-07 : 04:44:05
I don't know what it says as I can not see it properly, can you please elaborate by posting the error message in text format?
Go to Top of Page

SilencerGM
Starting Member

4 Posts

Posted - 2008-04-07 : 05:48:26
Sorry forgot to make it clickable :S

[URL=http://img150.imageshack.us/my.php?image=sqlisgayzb3.jpg][/URL]

Should be better.

/Sil
Go to Top of Page

RickD
Slow But Sure Yak Herding Master

3608 Posts

Posted - 2008-04-07 : 05:53:04
Have you really got a file called |om2.mdf?

Error 3 is a path not found error.

You might want to take a look at this.
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1618597&SiteID=1
Go to Top of Page

SilencerGM
Starting Member

4 Posts

Posted - 2008-04-07 : 06:18:08
I dont believe have, somebody said to try a "force restore" but I cant find the force restore option :(

/Sil
Go to Top of Page

SilencerGM
Starting Member

4 Posts

Posted - 2008-04-07 : 06:25:30
Wow, read that post, and don't have a clue what it means, I'm really new to SQL, as in this is the first time I've used it, how do I access the "force restore" function, I could give that a go?

/Sil
Go to Top of Page

RickD
Slow But Sure Yak Herding Master

3608 Posts

Posted - 2008-04-07 : 07:05:17
Its on the options tab, but if this file can't be used (and looking at the error, I would say the filename is using an illegal character), then you will not be able to restore the backup anyway, also you may want to check that the SQL Server Agent account has the correct rights to be able to get to the backup directory.
Go to Top of Page
   

- Advertisement -