How to detach and attached databases

This article will cover one of the most common SQL Server Detach and Attach the database.  please make sure you have a recent backup for any case of data loss. If you are not used in computer administration and database administration.   Please go to Start >> Programs >>Microsoft SQL Server 2012 >> SQL Server Management Studio and open the application. Connect with Windows Authentication (You have Windows administration rights) or Connect with SQL Server Authentication (You have no Windows administration rights) Expand the folder Databases in the object explorer,…

Read More

How to create a User and SQL server authentication

SQL Server Authentication is a default mechanism to connect to MS SQL Server, but there are times that you need to use SQL Server Authentication to connect to the server, like when you have to connect to an MS SQL Server Database on a different network or when you have an SSPI problem. In order to use SQL Server Authentication, you need to create a SQL Server Authentication Login ID first. we will create a new SQL Server account. Run Microsoft SQL Server Management Studio. with local windows Authentication    Expand the Security folder,…

Read More

Start, Stop, Pause, Resume, Restart SQL Server Services

This article will cover one of the most common SQL servers using full system ram: start, stop, pause, resume, or restart the SQL Server Database Engine, the SQL Server Agent, or the SQL Server Browser service by using Services. Open Task Manager Press Ctrl + Alt + Delete or Right-Click on Taskbar and then click ” Start Task Manager” In the results pane, right-click SQL Server (MSSQLServer) or a named instance, and then click Start, Stop, Pause, Resume, or Restart.   Restarting services   After restarting services “SQL Server” using 700 mb ram    

Read More