Job Failing

• naku.mayo

  Grasshopper

  Points: 15

  More actions

  January 8, 2008 at 1:02 pm

  #123103

  Good Afternoon,

  I am currently running SQL Sever 2k5. I have a job which is failing. When I view the job history the message states "The file 'D:\sqlserver\data\database_bbb_lob_1.ndf' cannot be overwritten." The problem is, the datafile which is referenced is incorrect. I have another schema on the same server. I checked the stored procedure and the parameters are correct.

  Any suggestions as to how I can verify the job or stored procedure points to the correct data file?

  Thanks in Advance.

• jsheldon

  SSCertifiable

  Points: 5250

  More actions

  January 9, 2008 at 8:19 am

  #766234

  Shot in the dark...is the stored procedure within the job using the full convention? You indicated you had multiple schemas

  Can you try ...

  [databasename].[databaseowner/schema].[tablename]