...er, your post fooled me, the rest of this thread is about cache flushes, not slow i/o, which your warning refers to.

You would be best starting a new thread but...

Vlad, nothing to do, its not an error, just informational. Just be aware restores will clear out your proccache.

I raised a request to change this behavior on technet but no-one...

Tao, I have not read this anywhere and its a guess so maybe I am setting myself up for a fall, but -

why does index data get deleted when...

no worries. Exactly what I did when I answered the...

Apologies, just reread the options properly, they are correct. :blush:

BOL does say indexes are deleted from index views. search on disabled indexes then see 'about disabled indexes'

As I understand it disabling the index does not delete the index, it remains in the system catalog but is not used by queries and is not maintained as the...

Glad it helped , thanks for the feedback.

Just noticed I in fact gave you an older version of the script that only handles two files, a data file and a...

OK, this script is not for the purist as it still refers to sysaltfiles but it will work and also will reverse engineer the database owner for you, which could...

then SQL is using about 6GB of memory (for buffer cache), the value in task manager is incorrect (due to AWE being used)

what does the perfmon counter show? I would trust that value

looks like you need to start off by querying the value of mirroring_role in table sys.database_mirroring and take it from there.

Theres one in the SQL 2000 BOL under dbcc showcontig

http://msdn.microsoft.com/en-us/library/ms175008.aspx

It could be amended slightly to do either indexdefrag or dbreindex

If this is code run only occasionally you could use openrowset method which is remote access without the need for a linked server.

You could use a table with server names...

If you have SQL memory set to take 6.5GB on a 32bit system I presume you have AWE enabled? In which case task manger does not correctly show memory usage....

we always have a failover pair for those type of servers. 😉