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.