Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-02-13 : 08:21:21
|
| Cristiano writes "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? " |
|
|
paulrandal
Yak with Vast SQL Skills
899 Posts |
Posted - 2006-02-14 : 12:36:02
|
| Your best bet is to cough-up $250 and let PSS help you. It'll be cheaper for you and the client than trying to resolve all of this through newsgroups/forums.Next time, make sure they have backups.Paul RandalLead Program Manager, Microsoft SQL Server Storage Engine(Legalese: This posting is provided "AS IS" with no warranties, and confers no rights.) |
 |
|
|
|
|
|
recover sql and analysis service data from disk crash