>> Restored the backup of the Master database.
>> Found that they have restored the master of some other instance and hence it was not able to find the database files in the location where it is supposed to be.
>> Requested to get back the original master files.
>> Then opened a command prompt and started the SQL Server in minimal configuration using -f.
C:\Program Files\Microsoft SQL Server\MSSQL\Binn>sqlservr -f
>> Connected from another command prompt using osql.
OSQL -S Machine Name -E
>> Ran the following command.
sp_configure 'Max Server Memory', 3078
Reconfigure with override

0

Featured Post

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

User Beware! This is a rather permanent solution to removing your email from an exchange server. The only way to truly go back is to have your exchange administrator restore your mailbox from backups. This is usually the option of last resort. A…

In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.

The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…