November 5, 2014 at 1:38 am
All,
Is it possible to rebuild and recover SQL cluster instance if cluster drives hosting system database , errorlog and user database files have been removed? I mean only 'instance root directory' binary files are available and rest of all SQL server files are not available.
Note: File system backups for 'data root directory','user database directory', Tempdb directory are not available.
All databases backups are available to restore once SQL instance is online.
Please list out the best approach to recover SQL instance in this scenario..or SQL Un-installation and re-installation is only option left?
Thanks in advance.
November 5, 2014 at 3:57 am
Parthipan-244146 (11/5/2014)
All,Is it possible to rebuild and recover SQL cluster instance if cluster drives hosting system database , errorlog and user database files have been removed? I mean only 'instance root directory' binary files are available and rest of all SQL server files are not available.
Note: File system backups for 'data root directory','user database directory', Tempdb directory are not available.
All databases backups are available to restore once SQL instance is online.
Please list out the best approach to recover SQL instance in this scenario..or SQL Un-installation and re-installation is only option left?
Thanks in advance.
As i understand it you only have SQL Server backups of the databases, does this include system databases (master, model, mdsb)?
Will you be presenting new shared storage to replace what is lost?
An uninstall, reinstall and subsequent restore of all databases may be a better option depending on the skill level of the DBA
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 5, 2014 at 11:47 pm
Perry Whittle (11/5/2014)
Parthipan-244146 (11/5/2014)
As i understand it you only have SQL Server backups of the databases, does this include system databases (master, model, mdsb)?Will you be presenting new shared storage to replace what is lost?
An uninstall, reinstall and subsequent restore of all databases may be a better option depending on the skill level of the DBA
Perry -Thank You..
Yes. System databases full backup are available for restore.
My understanding is that rebuild task of system databases using 'setup.exe' do not create all missing files (system database, errorlog, tracefiles) on 'Data root directory'. Please correct me if I am wrong.
The best option would be to completely uninstall and then reinstall and restore system/user databases?
Thanks in advance.
November 6, 2014 at 5:54 am
Parthipan-244146 (11/5/2014)
Perry Whittle (11/5/2014)
Parthipan-244146 (11/5/2014)
As i understand it you only have SQL Server backups of the databases, does this include system databases (master, model, mdsb)?Will you be presenting new shared storage to replace what is lost?
An uninstall, reinstall and subsequent restore of all databases may be a better option depending on the skill level of the DBA
Perry -Thank You..
Yes. System databases full backup are available for restore.
My understanding is that rebuild task of system databases using 'setup.exe' do not create all missing files (system database, errorlog, tracefiles) on 'Data root directory'. Please correct me if I am wrong.
The best option would be to completely uninstall and then reinstall and restore system/user databases?
Thanks in advance.
No, running a repair from add\rermove programs may well put all the directories back, or you could reconstruct them manually via the registry values and trial and error.
An uninstall, reinstall and then restore of the system and user dbs may be your best option.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply