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 |
|
jagpalsingh4
Starting Member
7 Posts |
 Posted - 2008-09-12 : 06:08:22
|
| Hi , I got this error on one of my database maintaince plan .i found this error in job history User does not have permission to perform this action. [SQLSTATE 42000] (Error 15247) Associated statement is not prepared [SQLSTATE HY007] (Error 0) No entry in sysdevices for backup device 'HFM_20080911214056'. Update sysdevices and rerun statement. [SQLSTATE 42000] (Error 3206) BACKUP DATABASE is terminating abnormally. [SQLSTATE 42000] (Error 3013). The step failed. The database used to reside on E:\Microsoft SQL Server\MSSQL\Data but was moved to it's new location F:\Microsoft SQL Server\MSSQL\Data. From that day we faced this error . Thaxxx Regards Jagpal singhjagpalsingh |
|
|
TG
Master Smack Fu Yak Hacker
6065 Posts |
Posted - 2008-09-12 : 08:20:20
|
| Can you perform a backup outside the context of the job? If so then it sounds like the job owner doesn't have access to the new location. If not then how did you "move" the device files? What does sysFiles have as the physical location of the files? Although if that was messed up then you couldn't even access the database I guess...Be One with the OptimizerTG |
 |
|
|
|
|
|
Job fails continously???/