First time here? Check out the FAQ!
x

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

0 votes
asked by (120 points)
edited by

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?

1 Answer

0 votes
answered by (264k points)

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:

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.

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.
Anti-spam verification:
To avoid this verification in future, please log in or register
...