I have a SQL Server (on Windows XP) where I have published reports using Report Manager and a bunch of databases. Within the SQL Server, I have jobs scheduled to run updates on tables, etc. I came in this morning to find that the root drive died. My drive is partitioned such that my databases aren't on the root drive - so I was able to salvage the databases.
I was able to use a prior hard drive (from about a month ago - we upgraded) and load current databases to the old drive. I'm trying to bring the old drive up to speed with today's data, jobs, files... .
My databases seemed to load fine.
What I can't do is view any of the reports that use Report Manager. A few questions:
- Are the jobs that run through SQL Server stored in a different directory than the databases?
- Any idea of what's happening with accessing report manager reports? Usually a client machine could access the reports using IE. - also can't connect using an ODBC connection with Access. (the network plug is connected).
- Am I missing any other pieces that may need to be restored to the current view besides the databases?
Any suggestions are appreciated.