HA Technologies(High Availability) is the solution\process\technology to make the application\database available 24x7 under either planned or un-planned outages. Mainly, there are five options in MS SQL Server to achieve\setup high…
MS SQL Server provides the following two services which are mandatory for databases creation and maintenance. Other add-on services available for different purposes are also listed. SQL ServerSQL Server Agent…
Monitoring refers to checking database status, settings which can be the ownerās name, file names, file sizes, backup schedules, etc. SQL Server databases can be monitored mainly through SQL Server…
Assign PermissionsĀ refer to the rules governing the levels of access that principals have to securable. You can grant, revoke and deny permissions in MS SQL Server. To assign permissions either…
In this topic, we will discuss about Create Users in MS SQL Server. User refers to an account in the MS SQL Server database which is used to access the…
Restoring Databases is the process of copying data from a backup and applying logged transactions to the data. Restore is what you do with backups. Take the backup file and turn…
Creating BackupsĀ is a copy of data/database, etc. Backing up MS SQL Server database is essential for protecting data. MS SQL Server backups are mainly three types ā Full or Database,…
To remove your database from MS SQL Server, use the drop database command. The following two methods can be used for this purpose. Method 1 ā Using T-SQL Script Following…
MS SQL Server - Select Database based on your action before going ahead with any of the following methods. Method 1 ā Using SQL Server Management Studio Example To run…
Create Database is a collection of objects such as table, view, stored procedure, function, trigger, etc. In MS SQL Server, two types of databases are available. System databasesUser Databases System…