as far as i read 100% fill factor can be given only to read only tables/DB's.

if the table has regular inserts or deletes index needs to have some fillfactor left...

as it is dedicated sql server why dont you look at what inside SQL server is making the CPU to peak?

Rather sql will release the memory when OS needs it.

Is it as dedicated SQL server or any other application running on it?.

select * from backupmediafamily

this table will have where the last backup happened.

can you recommend some which you might have used without any problems.

thanks, exactly what i require.

Is there any other way other that this, experts you ways.

can you post the table structure and code you trying to use.

Anything on maintanence plan history or job history?

kramaswamy (9/20/2012)

---

Hey -

I think that it's possible that my backup chain may have been corrupted by some transaction logs being removed by other people. The server is working perfectly...

Joy Smith San (9/19/2012)

---

if I disconnect all the users before the backup starts, ensuring there's no any transaction open which may or may not commit before the backup process...

Hello,

read this

http://www.sqlservercentral.com/Forums/Topic253575-149-1.aspx

use profiler

under TSQL select SQL:batchcompleted and SQL:stmtcompleted to find the reads,writes and time taken.

just run execution plan and see CPU time also.

is it is a fresh table then do...

Hello,

1 millon accounts means how many records and in how many tables?

SP4 - http://support.microsoft.com/kb/913089

it was released in 2010, from where you got confused.

i got a issue i XP_Delete_File not working follow the post for last few replies

http://www.sqlservercentral.com/Forums/Topic1348487-146-2.aspx

confirm and then install but...

what do you think this will do?