How to find databases in SQL Server 2005 after the particion of the drive?

Question

I have an 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:

1. Are the jobs that run through SQL Server stored in a different directory than the databases?
2. 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).
3. Am I missing any other pieces that may need to be restored to the current view besides the databases?

Answer 1

All the SQL Server jobs are stored in the msdb database. Luckily, Microsoft created a page about this where everything is explained. You can check it using the following link posted below:

• MSDB database information: https://msdn.microsoft.com/en-us/library/ms187112.aspx

There is a page for Report Manager as well: https://technet.microsoft.com/en-us/library/ms156496(v=sql.100).aspx

Note: On the page, click the link that leads to tutorial regarding the configuration procedure of Report Manager.