Sqlsavy (11/8/2010)

---

Thanks for that but

I am bit confused with which job to be set first or the order of the jobs for Reorganize Index, Database Integrity check, Update Statistics

I...

your welcome.

Bhuvnesh (11/8/2010)

---

Did you read my replay fully ?

It depends.

In my case maintenance for system db's,

1.Backup...

Are you sure you run under correct database and correct schema ?

winston Smith (11/8/2010)

---

I thought that the sys.dm_db_index_usage_stats stats dmv only stored data for indexes that got used 1 or more times. i have been capturing this data for a...

Sqlsavy (11/8/2010)

---

Thanks Muthukkumara,

I could figure out the reason for the job failure from the maintenance plan history as you adviced .The error is..

Executing the query "ALTER INDEX [PK_Act] ON [dbo].[_Act]...

There is no need for...

Sqlsavy (11/8/2010)

---

I had already posted job history , posting it agin for your refrence...

Date06/11/2010 09:09:00

LogJob History (UserDB.ReorgIndexes)

Step ID1

ServerServername

Job NameUserDB.ReorgIndexes

Step NameReorgIndexes

Duration05:00:39

Sql Severity0

Sql Message ID0

Operator Emailed

Operator Net sent

Operator Paged

Retries Attempted0

Message

'Executed as user:...

It depends.

In my case maintenance for system db's,

1.Backup --yes (Except...

Sqlsavy (11/8/2010)

---

I am bit confused with which job to be set first or the order of the jobs for Reorganize Index, Database Integrity check, Update Statistics

I feel the order should...

Did you read the previous replay ?

Did you perform log backups?

Did you face any disk space problem?

T.LOGANATHAN (11/8/2010)

---

Dear Friend,

My DB recovery model is FULL and I am taking full backup on every day and transfer the backup to other server ( for Precaution)

My question is How...

harita (11/3/2010)

---

Hi, all

How to check the Health of a database in sql server 2005 and what is 'Health' concept,

and how to know if the transactions are committed are not, can...

TST1 (11/3/2010)

---

Hi,

There isn't any blocking nor fragmentation which is what I'm slightly confused by. The app team was also confused by this. We do use a third party...

TST1 (11/3/2010)

---

Hi,

I have a function which calls on a view within it. It has been working fine and then suddenly it's taking 10 mins to run in the last...