How to Password Protected Backup In SQL Server In this post we will learn How to Password Protected Backup In SQL Server. Password Protected backup in SQL Server gives you an additional security, to password protect SQL Server files we will use MEDIA PASSWORD. Setting backup media password are important and useful for securing misuse of data. […]
Category: Sql Server
SQL Server Tutorials, SQL Server Tutorials for Beginners, SQL Server Online Course, Microsoft SQL Server Learning, Microsoft Online Learing
How To Delete Backup Files Older Than n Days In this post we will learn How To Delete Backup Files Older Than n Days. This will help us in deleting old file to free space from disk, we can do it manually. But by this approach we can delete files by setting number of days to […]
Categories
Creating Resource Pools in SQL Server
Creating Resource Pools in SQL Server In this post we will learn Creating Resource Pools in SQL Server. Earlier we had discussed Resource Governor in SQL Server, How To Enable Resource Governor and How To Disable Resource Governor. Resource Pool: Resource pool represents a subset of the physical resources of an instance of the Database Engine. A resource pool represents […]
Categories
Resource Governor in SQL Server
Resource Governor in SQL Server In this post we will discuss about Resource Governor in SQL Server. In previous post we have learnt Switch Back to iOS after Jailbreak and How to Jailbreak iOS 7.1.2, iOS 7.1.1 and iOS 7.1. What is Resource Governor: SQL Server Resource Governor is a feature to manage SQL Server workload and system resource […]