- Right click on the database then goto Task then Restore ->Database MDF from the system files.
- Select Taskoption.
- Select the Backupoption and click Restore.
select * from sys.configurations ;
I. REBUILDING PROCESS
- You can insert and run the SQL Server 2014 installation media. Other method is to run the command prompt and change the location of the directory to the location of setp.exe file present on the local server. The default location of the file on server is C:\Program Files\Microsoft SQL Server\120\Setup Bootstrap\Release.
- In a command prompt window enter the given commands. The command prompt should be run as administrator. If you are using Windows operating system in which User Account Control is enabled, running setup may require more privileges.
- When specifying multiple accounts in /SQLSYSADMINACCOUNTS=accounts, separate the accounts with a blank space.
- It is suggested to specify a strong password for sa account as it is vulnerable to get hacked.
- If we change the server-level collation, it does not change the location of existing database. New databases will occupy new space by default.
- Restore the recent full backup of the master database. If the backup is not available or the current backup is not updated, recreate the missing entries. The most suitable way to recreate missing entries is by running the scripts that created the entries.
- Restore the distribution database if the instance of your SQL server is configured as a replication distributor.
- Move the master database to the previously recorded location.
- Verify whether the previously recorded values and server-wide configurations values match with each other.