SQL Server – Types of Recovery Models
Database recovery models determine how you backup a database and the strategy you implement to meet your Recovery Point Objective (RPO). RPO enables you to measure the amount of data that might be lost in the event of failure.1 There are three recovery models in SQL Server Management Studio. Simple-Minimal Logging, no transaction log backups…
SQL Server – Script to Monitor Logins on Databases
Use the below script to monitor what applications are running anc connecting to Databases or you want to investigate who is login in to the server Results
SQL Server – Create Logins, Roles, Users and Grant Permission Scripts
1. Create Users on SQL Server There are two ways of doing this depending on the requirement of the company Windows Authentication Method Create user name using Windows Authentication on master database for john and using Domain name “DESKTOP-E6MM8JA\” SQL Server Authentication Method Create user name using SQL Server Authentication on master database for GJerry…
Follow My Blog
Get new content delivered directly to your inbox.
Database Solutions 