Logins will be in the AD group and you grant permissions to a role and add the group to that role. Then use " Be made using the login's security...

Yes i have checked for all the options we are unable to add the groups name here.

can anyone please suggest on this

Yes, i have the full backup file and moved to new server but i dont know the restoration process can we restore using gui mode or through commnads

i tried through...

We have very less process are running. not only the sql server even we are unable to navigate the windows also.

we have restricted the max server memory to 60%. still...

Thanks for your information.

How can i monitor the complete log usage in that particular time.

Performance and if the services are failed then we have to get the alerts alo disk space issues.security and all the dba activities

For one week i have monitored the log in weekends it is occupying 25% space so can anyone please update me on this.

i have created one job and it will run for every 15 mins and insert the results in to one table. here we have last four days data in that...

SELECT DISTINCT d.logical_volume_name

,d.volume_mount_point

,CAST(d.total_bytes / 1024 / 1024.0 AS INT) AS TotalMB

,CAST(d.available_bytes / 1024 / 1024.0 AS INT) AS FreeMB

FROM sys.master_files f

CROSS APPLY sys.dm_os_volume_stats(f.database_id, f.file_id) d

---------------------------------------------------

Now above query is working. example...

yes i am monitor the log from last five days the maximum size of log used is : 7.03167

if i run the above command i am not getting any out put and all the columns are blank.

Thanks for your information.

as per your script i have executed in our server.

see the below resilts:

Actual log size: 369409.0

Used_log_size_mb :128.0

potential_log_size :368000.0

actual_VLF's :2890

used Vlf's:1

Potential_VLFs :736

growth_iteration :46

Log_initial_size:8000.0

File_auto_growth_mb:1024.0

Please advise me how can i...

How can i check whether how many virtual log files in log

Thanks for u r information. i will monitor the log for few days and i will let you know how much it is occupying.