Viewing 15 posts - 976 through 990 (of 1,079 total)
Is it a scheduled Job, or part of your maintenance plan?
Scheduled Job?
Have a look at the steps, you'll see all the properties if its T-SQL Based commands, and you'll have...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
January 19, 2010 at 5:59 am
As far as I know, it's 1 temp datafile per CPU Core....
I agree with Gail, leave your CPU Affinity to default, and rather set your memory usage if you need...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
January 19, 2010 at 5:35 am
i have the LocalSyatem as the login account.
Just as a test, change the account to a domain admin account, and see if the agent starts automatically.
Have you checked your...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
January 18, 2010 at 10:05 pm
Full path on my workstation:
"C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Binn\SQLAGENT.EXE" -i MSSQLSERVER"
check the account that you specified to start the service first, sounds like you have a permission issue....
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
January 18, 2010 at 9:40 pm
Whats your current settings?
Properties tempdb, Files, and have alok at our current config please.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
January 18, 2010 at 6:24 am
remember to set AUTOGROW by a fixed MB size, and not percentage...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
January 18, 2010 at 6:13 am
Have the same setup running live in my environment, no issues except of course the extra load on the Server.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
January 18, 2010 at 6:03 am
I'll have to agree with Randolph, prices seems unrealistically high for smaller companies in South Africa, who need the ent, and all the bells and whistles offered.
I am not too...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
January 15, 2010 at 1:59 am
Hi Gail
Sent it to the Members@sql******.co*** address as instructed on the SASSUG site, to subscribe.
I'll sent you a pm just in case.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
January 13, 2010 at 12:51 am
Thanx Gail, sent the mail.
Looking forward to the sessions.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
January 12, 2010 at 2:30 am
GilaMonster (1/12/2010)
Henrico Bekker (1/11/2010)
Except for Gail's workshops every now and then, are there any other and more regular events in...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
January 12, 2010 at 1:56 am
Thank you, will have a look.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
January 11, 2010 at 11:07 pm
Thank you, will have a look.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
January 11, 2010 at 11:05 pm
I know this is a bit off topic, but somehow relates..
Except for Gail's workshops every now and then, are there any other and more regular events in South Africa for...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
January 11, 2010 at 10:48 pm
praveen640 (1/11/2010)
Haihow to back the data in my server for every 3 hrs automatically
1. create new job, with t-sql statement to back your DB's, schedule to run every 3 hours.
2....
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
January 11, 2010 at 5:53 am
Viewing 15 posts - 976 through 990 (of 1,079 total)