Just wanted to understand the process of rebuild the SQL Server in the below situation
windows server 2008 r2 was crashed and rebuilt with scratch and the administrator has given access to me windows admin right.
the currently windows administrator does not have any detailed info about SQL server versions, running, objects, database,etc, and this was connected to ERP
so I found out in the D: Drive it has all the SQL Server folder, which has backup (system/user database, log,etc)
so I need to rebuild it
My Questions here
1. Which Version i need to install the SQL
2. After installation of SQL server
shall i restore the system databases (Master, model,msdb) one by one.. after that shall i move to restore the user database?
After restore the above system database, all my user logins, permission, roles,users, server objects, configuration mg, Ram being used, Sql Configuration mgt port used, etc.. will it be back my original state?