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.
| Author |
Topic |
|
dbalearner
Constraint Violating Yak Guru
272 Posts |
 Posted - 2012-07-24 : 21:24:58
|
| This is the Error when Tried to use the Agent Job to restore the File:Executed as user: NT AUTHORITY\SYSTEM. Cannot open backup device 'F:\Backup\DB_Blank.bak'. Operating system error 3(failed to retrieve text for this error. Reason: 15105). [SQLSTATE 42000] (Error 3201) RESTORE DATABASE is terminating abnormally. [SQLSTATE 42000] (Error 3013). The step failed.But When using the Same DB-Blank.bak to restore normally, it is ok.Can anyone identify the bottleneck please |
|
|
ksr39
Posting Yak Master
193 Posts |
Posted - 2012-07-25 : 00:53:55
|
| Check the Agent job permissions for the user to access the folder. |
 |
|
|
|
|
|
Restore through Job