brunm (12/15/2010)

---

i can't get the Maintenance cleanup task to work in SQL Server 2008 (Enterprise Edition)

The step is completing successfully but it is not deleting the files in the folders...

Thanks again....like that idea

its seems like the conformed dimensions. is much simpler on the developer, but no much on the end user? I am thinking more on the lines of accounting or sales...

agree this plan is not your problem.. if you captured a trace or set statistics time on you would see that this is very fast

you set up a job and run the following each morning assuming that you have database mail already set up

DECLARE @PrintMessage nvarchar(50);

SET @PrintMessage = N'Here are your Database update...

1) Do i need to create a share folder on each instance for transaction log backup folders? yes

Can i make them cluster resource? never tried....not sure that you need to

2)...

please refer to the Gails article...we will be able to help a little better

http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

How to Post Performance Problems

one last thing sometimes you you need to stop change tracking on each table then rebuild the catalog..this i have had to do when it gets hung ...

this script will...

I am guess you have already checked the logs and have not found anything, if not I would try one of 2 things or both...restart the FTS service, and or...

so again ....its sounds like sql does not have enough memory and running on disk...my guess is if you look in your task manager...you have a lot of other thing...

sound like the disk is running .....when you are not really doing anything within sql server....its just up and running in the background...you are not hitting it with any queries...

after you hit rebuild...then right click on the catalog there you will be able to see the properties....and yes you are correct should have been done long by now....

I have...

Please confirm it sounds like this was installed on a desktop/laptop...so my guess is there is really nothing running on it as of yet?

SQL is going to take as much memory as it can, if you check your task manager it should be the top of your list as far as memory useage.

...

if you see the Item count...at 0 wait a while....depending on how big the Full text index is it could take a while...

also what does your last population date say?...