Project Description
I run a scheduled job that loads our daily database files into SQL Server. Until recently it ran flawlessly; now the job ends with an HTTP 500 error and the expected data never appears in the tables. I need someone who knows SQL Server inside-out to:
• Identify the exact cause of the 500 failure (stored procedure, permissions, IIS/ODBC mis-configuration, corrupt data file, etc.).
• Restore or repair any affected tables so the missing information is back in place.
• Make the automated run reliable again and document the fix so I can repeat or monitor it in future.
You will have remote access to the production instance and recent .bak backups. Please bring strong T-SQL troubleshooting skills and familiarity with SQL Server Agent jobs, error logs, and performance tools such as Profiler or Extended Events. A concise post-mortem explaining what broke and the steps you took to resolve it will complete the engagement.