is this similiar to what you ran.

SELECT OBJECT_NAME(object_id),* FROM sys.dm_db_index_physical_stats

(db_id('msdb'),null,null,null,'detailed')

You say it is 1gb in size, what size is the mdf file and what size is the ldf file.

try selecting...

Thanks Dave, I googled and got the answer. thanks for that i was really struggling with that 😀

As previously mentioned in the last 4 duplicate posts, you can only backup using copy_only from t-sql in sql 2005, it is possible to restore if you perserve through the...

[rant] Why do I get a feeling that myself and others on this forums are keeping inexperienced people in their current role. deja vu every day, same ops different questions...

Dont double post, and the...

You seem to have a few issues listed in the log.

2009-10-15 06:22:10.14 spid5s FCB::Open: Operating system error 32(error not found) occurred while creating or opening file 'R:\MSSQL.1\MSSQL\DATA\master.mdf'. Diagnose and correct...

Good points, it does ring pretty true about people being out of their league, too many people i think are either under a lot of pressure from management or have...

Manie Verster (10/15/2009)

---

eyespi20 (10/14/2009)

---

I believe that we are each responsible for ourselves. It's great if your employer offers to pay for seminars or even tuition reimbursement for a degree, but...

Look at the maintenance plan history

gmamata7 (10/14/2009)

---

thank you,

Is that OK to have disk IO high...

You say avg, but over what period ?

system databases shouldnt need changing

Nicely put, makes a change for someone to agree with me 😀

Bob Hovious 24601 (10/14/2009)

---

Chris, I am not bothered at all by basic questions from beginners. The irritation comes from people who post next to no background information and expect...

To help you further in your understanding, look at the checkpoint statement in BOL.

to answer your further questions, 'truncate the log'. it will happen if recovery model is simple or...