Restore Master DB and our own DB to a freshly installed SQL 2008 server
Posted on 2011-02-25
I have had to re-install our SQL 2008R2 server, before reinstalling i backed up the master database and our own SQL database, i have now reinstalled the server and installed SQL.
My next step is to restore the database. is it as simple as right clicking on each database and restoring.
Does the New SA password need to match the old one, and also now i have re-installed the file paths are slightly different as the path to the databases i chose during install was E:\SQL_Data
in the original install it was still on the E drive but was just the long default path that SQL.