Viewing 15 posts - 16 through 30 (of 241 total)
select name,recovery_model_desc from master.sys.databases
March 28, 2019 at 12:38 pm
declare
@db sysname ,
@srv varchar(15),
@inst varchar(15),
@msd datetime,
@MFD datetime,
@bl varchar(260),
@ty char(1),
@rm varchar(255)
March 28, 2019 at 12:37 pm
there are many ways to do that, here are some of them
1) you can use batch/cmd file to run query to find out
2) you can use powershell...
March 28, 2019 at 12:05 pm
I was more interested in tokens. you need to find wmi property token for ip and or machine name. if you are using wmi
may be this help
March 27, 2019 at 12:27 pm
is this wmi alert?, please post the code for alert
March 27, 2019 at 12:12 pm
what my friend you need is Policy Based Management - go crazy (test test test and test)
you can create readonly filegroup and move table to RO_filegroup.. just an idea..
March 26, 2019 at 7:27 am
spending $$ is no issue, the question is what if adding memory to OS does not satisfy Symantec's urge to use page file
March 25, 2019 at 1:17 pm
I am sure database files are excluded but I will confirm, the biggest database is about 900gb, I will also see what I can find from Symantec,
any advise/guide lines to...
March 25, 2019 at 12:54 pm
Thanks Guys,
Answering my own question,,
process explorer
March 25, 2019 at 11:05 am
there are no other applications on the box, other than symantec and vmware/backup tools for which I am sure 6GB is more then enough, there is no SSRS/SSAS on the...
March 25, 2019 at 10:43 am
you can create a script to create your logins and permission and save them at network location, Just run the script after the install that is the automation level you...
March 21, 2019 at 9:49 am
yep.. figure out the rest
USE [msdb]
GO
EXEC msdb.dbo.sp_add_alert @name=N'resource_pool_CPU',
@enabled=1,
@delay_between_responses=0,
@include_event_description_in=0,
@performance_condition=N'Resource Pool Stats|CPU usage %||>|90',
@job_id=N'00000000-0000-0000-0000-000000000000'
GO
March 20, 2019 at 2:23 pm
check what else is running when job run, check job schedule conflict, there might be other jobs/process run that might effect the job duration.
March 20, 2019 at 2:10 pm
keep in mind you need to setup mail profile as well for this thing to work..
March 18, 2019 at 2:03 pm
Viewing 15 posts - 16 through 30 (of 241 total)