Viewing 15 posts - 406 through 420 (of 782 total)
First try it on a dev server and see how it goes before trying to do on a prod server.
Regards,
Sushant
February 8, 2011 at 9:54 am
wat are the error logs and sql server logs say?
Are your sql server and sql agent running on the same domain account.
Regards,
Sushant
February 8, 2011 at 9:08 am
ok, i got it ...
but
thats wat i said at hte starting that i chekced all the maintennace plans and jobs , but no backup was done to that database.
Regards,
Sushant
February 8, 2011 at 9:05 am
Check the sql agent services in hte services panel of administrative tools.
right click on sql agent and see the properties.
The startup type should be automatic.
Regards,
Sushant
February 8, 2011 at 8:43 am
I couldn't get wat you meant by command inside a sql agent ???
I am the only guy who does the backup so im pretty sure that the backups are not...
February 8, 2011 at 8:27 am
When i run the query to find out the last backup time of all databases, i can see that, physical device name as
DBName_00__8b079130_1ff6_4712_9a8e_c5c8f8a1448c_
where the last backup was done.
Regards,
Sushant
February 8, 2011 at 7:52 am
select es.session_id,es.status,wt.exec_context_id,wt.wait_type,wt.blocking_session_id,wt.blocking_exec_context_id, wt.resource_description, wt.wait_duration_ms
from sys.dm_exec_sessions es
inner join sys.dm_os_waiting_tasks wt on es.session_id = wt.session_id
where es.is_user_process = 1
Regards,
Sushant
February 8, 2011 at 6:27 am
Maybe some1 put up that maintenance plan because the ddatabase was growing out of size frequently..
You can disable that, but be sure to monitor the size of db and the...
February 7, 2011 at 2:06 pm
go to server--> properties -->security--> enable C2 audit tracing...
it shouldnt be checked.
Regards,
Sushant
February 7, 2011 at 11:56 am
go to the job --> properties
and then see the schedule
Regards,
Sushant
February 7, 2011 at 9:28 am
what you meant by jobs are not running?
Were they scheduled to run and if it failed.
Can you post the code/error.
Regards,
Sushant
February 7, 2011 at 9:16 am
I guess ,They have been just created and they didnot run until now.
see in job activity monitor, wat can u see about the jobs, last run, next run ?
Regards,
Sushant
February 7, 2011 at 9:14 am
upgrade from rtm version to sp3 and then build the maintenance plan there...
Let us know, what errors you getting this time.
Regards.
Sushant
February 7, 2011 at 6:20 am
you mentioned earlier, they reorganize index daily, but thats also not required on a daily basis.
What i do is i reorganize indexes only if the fragmentation level of indexes is...
February 4, 2011 at 7:52 am
Viewing 15 posts - 406 through 420 (of 782 total)