Sunday, April 24, 2011

Database role access level issues in sql server.

If you create one login named as 'kumar' and map the login to the user 'kumar' in the 'test' database.
Let us see below scenario.
1.First i gave db_datareader role for that login 'kumar' ,then try to execute below queries.

Let us see what will happen.


To resolve above error ,what role needs to give for 'kumar' login?
db_datawriter.

To resolve above error ,what role needs to give for 'kumar' login?
db_ddladmin and to resolve below by giving db_backupoperator

Alert :Disk is full ,As a DBA,What will you do?

1.Find out the free space in the drives by 

XP_FIXEDDRIVES


2.Check the free space in the mdf and ldf for all databases to shrink.
if free space available,shrink the mdf or ldf as like below image.



3.Check for any unarchived backup files available in the drive,if so,ask Archive team to fire a full backup.

4.Check which database has free space by 

or 



Thats'it

Hope you will clear the drive to get free space...


MYSQL::Setting Validate_Password componet for MySQL Database to ensure password policy settings

Inadequate Password Settings for MySQL Database We observed that the `validate_password%` settings on hostname `<insert hostname>` a...