Select the database and then right-click on the database, select Tasks > Restore > Database, which will open the Restore Database dialog box 2. Double click on the “Device”. 3. Click on the “Add” to add backup in the database. 4. Select…
Posts Published by Usman Pervaiz
How to Install SQL Management Studio
Download your desired version of Microsoft SQL Server. Find the file “SQLManagementStudio_x64_ENU.exe” where you placed and Double Click on it to start the installation. 3. Select “New Installation” as below screenshot. 4. Select the SQL…
How to install SQL Express.
Download your desired version of Microsoft SQL Server. Find the file “SQLEXPR_x64_ENU.exe” where you placed and Double Click on it to start the installation. Select “New Installation” as below screenshot. 4. Accept the Agreement and…
How to Deploy SQL database to MS Azure.
Open the SQL Management Studio where your database is restored. Right click on the database, and select Tasks >> Deploy Database to Microsoft Azure SQL Database. 3. Click on Next. 4.Click on Connect then select…
How to create a new Database in SQL
Launch SQL Management Studio and connect to your SQL Server instance. Right Click on “Database” and then select “New Database”. 3. Below ‘New Database’ screen will appear. Enter ‘Database name’ Now you have successfully created a…
Set up the Scan to Network Folder
To set up the Scan to Network Folder feature, the printer must have an active network connection to the same network as the computer that will run the setup process. It allows users to save…
How to setup Windows Server 2016 Essentials and configure Active Directory
Windows Server Essentials is a small businesses Server, typically those with a maximum of 25 users and 50 devices. It is designed to suit a small number of users and devices but also supports to expand…
How to resolve RDP authentication error due to the CredSSP encryption oracle remediation on Windows OS
An authentication error message has occurred when you try to connect another computer using Remote Desktop Connection and below are the reasons why RDP is blocked. The client has the CredSSP update installed, and Encryption Oracle Remediation is set…
Migrating DHCP Server to another server
Being a Windows System Administrator, you have to deal with migrating DHCP role to another Server due to various reasons (Hardware/Software end of life, DHCP Server having issue, merging roles, etc.) This can be a…
Enable IP Address Conflict Detection on Windows DHCP Server
You can enable DHCP conflict on the network to diagnose issues related to client devices are not getting an IP Address. In Summary: DHCP server uses the Packet Internet Groper (ping) process to test available…