disk crash and dwh recover

hi everybody.
A customer of mine has had a disk "crash" few days ago.
I wrote for him a dwh application and
of course the backup was not working...
now some "hardware guys" said that it is possible to recover most of
the files.
what I need to restore would be:
1- the sql server db
2- the sql server dts and jobs
3- the analysis service cube and dimensions
to do so is it enough for me to have:
1- the .mdf and .ldf files
2- the master.mdl /.ldf file
3- the .odb file and .dim* and .role .map ... files
right?
is it enough to recover everything?
if it is so, what would be the right processes to recover everything?
any help greatly appreciated!No RAID and no backups? So this data warehouse is really just a bunch of
data dumped on someone's PC with a few reports tacked onto it? ;-)
Assuming the hardware gurus can actually recover the .mdb (data) files
intact, they can be reattached once the SQL Server box is re-installed. The
.ldf files are the transaction logs, and in a bulk loaded data warehouse,
restoring these may not be important.
http://msdn2.microsoft.com/en-us/library/ms190794.aspx
http://support.microsoft.com/defaul...kb;en-us;224071
What will be a pain is restoring or re-building the master database and how
this affects logins/users for the user database(s). However, unlike
operational databases, most data warehousing databases only have a limited
number of users or profiles (ex: Admin and Reporting), so perhaps this won't
be too much of a deal.
Rebuilding the master Database:
http://msdn.microsoft.com/library/d... />
t_0cvm.asp
User logons and permissions on a database may be incorrect after the
database is restored:
http://support.microsoft.com/defaul...kb;en-us;168001
As for restoring the Analysis Services cubes, I assume you at least have a
backup of the development system which can be restored to production. OLAP
data is typically just derived and aggregated, so once AS is re-installed
and the cube files restored, just re-process and they will be re-loaded from
the source data warehouse tables.
Microsoft SQL Server 2000 Analysis Services Operations Guide:
http://www.microsoft.com/technet/pr...n/anservog.mspx
"ilkaos" <c.caoduro@.gmail.com> wrote in message
news:1138637846.479954.273090@.f14g2000cwb.googlegroups.com...
> hi everybody.
> A customer of mine has had a disk "crash" few days ago.
> I wrote for him a dwh application and
> of course the backup was not working...
> now some "hardware guys" said that it is possible to recover most of
> the files.
> what I need to restore would be:
> 1- the sql server db
> 2- the sql server dts and jobs
> 3- the analysis service cube and dimensions
> to do so is it enough for me to have:
> 1- the .mdf and .ldf files
> 2- the master.mdl /.ldf file
> 3- the .odb file and .dim* and .role .map ... files
> right?
> is it enough to recover everything?
> if it is so, what would be the right processes to recover everything?
> any help greatly appreciated!
>|||
> No RAID and no backups? So this data warehouse is really just a bunch of
> data dumped on someone's PC with a few reports tacked onto it? ;-)
>
kind of...it was my first attempt with analysis service and it did a
"little but good" job..

> Assuming the hardware gurus can actually recover the .mdb (data) files
> intact, they can be reattached once the SQL Server box is re-installed.
The
> .ldf files are the transaction logs, and in a bulk loaded data warehouse,
> restoring these may not be important.
> http://msdn2.microsoft.com/en-us/library/ms190794.aspx
> http://support.microsoft.com/defaul...kb;en-us;224071
I thought so

> What will be a pain is restoring or re-building the master database and
how
> this affects logins/users for the user database(s). However, unlike
> operational databases, most data warehousing databases only have a limited
> number of users or profiles (ex: Admin and Reporting), so perhaps this
won't
> be too much of a deal.
> Rebuilding the master Database:
>
http://msdn.microsoft.com/library/d... />
t_0cvm.asp
in fact there are no particular users or profiles

> User logons and permissions on a database may be incorrect after the
> database is restored:
> http://support.microsoft.com/defaul...kb;en-us;168001
I see...

> As for restoring the Analysis Services cubes, I assume you at least have a
> backup of the development system which can be restored to production. OLAP
> data is typically just derived and aggregated, so once AS is re-installed
> and the cube files restored, just re-process and they will be re-loaded
from
> the source data warehouse tables.
> Microsoft SQL Server 2000 Analysis Services Operations Guide:
>
http://www.microsoft.com/technet/pr...n/anservog.mspx
>
sorry but I do not understand what you mean with a "backup of the
development system which can be restored to production".
As I wrote in my previous message I can have back the files tjat were in the
..\analysis service\* folder...
in any case thanks a lot for your answer, it is a great help!
ciao.sql