Restore SQL Server after OS loss

60 pts.
Tags:
Backup
SQL Server
SQL Server backup
SQL Server backup and restore
I have all datafiles and backups but no OS services. What steps would I take to restore the database
ASKED: February 19, 2011  11:05 AM
UPDATED: February 21, 2011  2:47 PM

Answer Wiki

Thanks. We'll let you know when a new response is added.

+++++++++++++++++++++++++++++++++++++++++++++++++++++++++
DISCUSSION:
What sql server are you using, and what type of backup did you make
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++

I am using SQL Server 2008r2 x64 on WINDOWS 2008r2 x64. I made a full backup of all files. However the drive the data is located on is in tact. When using oracle I just need to create services and use the same datafiles as previous. Can’t I do the same for SQL server? Juts drop the datafiles back into the MSSQL Server directory and start the database?

Currently I am unable to re-install SQL Server and I have asked another question with the following error:
An error occurred during the installation of assembly ‘policy.8.0.microsoft.vc80.crt, version=’8.0.50727.4027′, publickeytoken=’1fc8b3b9a1e18e3b’, Processorarchitecture=’x86′,type=’win-32-policy’. HRESULT:0x800736fd

I researched but no answer has worked for us. As soon as I can re-install SQL Server though I would like to know if this procedure that I have in my head will work

——————-

Rename the current folder that the system databases are in. When you reinstall SQL Server tell it to put the system databases in the same location that they were in before you renamed the folder. After the installation is done, stop the SQL Server service, rename the folder that the system databases are in, and put the original system databases in that location, then restart the SQL Server. It will automatically pick up all the databases (assuming that all the other databases are in the correct locations). This will only work if the new installation is the SAME VERSION as the old installation was. If the version isn’t the same this won’t work.

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Ingram87
    What sql server are you using, and what type of backup did you make?
    1,285 pointsBadges:
    report
  • Grabber
    +++++++++++++++++++++++++++++++++++++++++++++++++++++++++ DISCUSSION: What sql server are you using, and what type of backup did you make +++++++++++++++++++++++++++++++++++++++++++++++++++++++++ I am using SQL Server 2008r2 x64 on WINDOWS 2008r2 x64. I made a full backup of all files. However the drive the data is located on is in tact. When using oracle I just need to create services and use the same datafiles as previous. Can't I do the same for SQL server? Juts drop the datafiles back into the MSSQL Server directory and start the database? Currently I am unable to re-install SQL Server and I have asked another question with the following error: An error occurred during the installation of assembly 'policy.8.0.microsoft.vc80.crt, version='8.0.50727.4027', publickeytoken='1fc8b3b9a1e18e3b', Processorarchitecture='x86',type='win-32-policy'. HRESULT:0x800736fd I researched but no answer has worked for us. As soon as I can re-install SQL Server though I would like to know if this procedure that I have in my head will work
    60 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following