Jeffrey Williams-493691 (4/20/2010)

---

Try rebuilding all indexes in that database - and then see if it reports different usage. I am not sure why your backup failed - did you...

Jeffrey Williams-493691 (4/20/2010)

---

Well, you shouldn't be shrinking the database - it is just a waste of time since it will grow again.

What are the sizes of the mdf/ldf...

Yes, but it has grown suddenly. It was around 700 KB six months back and now 3+ GB. Shrink database hasnt made any difference. Thanks.

Thanks for the update. Elsewhere in this forum, it was mentioned that \\ should be made \ etc but no mention how this can be done! Anyway, the copy to...

In the Maint Plan Designer, the path for the backup was E:\Backups. No \\ etc just plain drive letter path.

Thanks. Will try that

The SQL logs show Stack Dump, etc. Probably a bad area in the disk?

Anyway what I did was to copy the Database from Mgmt Studio on the same server...

Yes, as mentioned in the subject, I have installed SP3.

I have to check where the \\ is coming from as I remember that the path in the Plan is only...

Further to my above post, I find that SQL Integration Services is not appearing/running under the Services. Is this required for backup? As mentioned, System Databases are being backed up...

Sorry I didnt mention that. CR 11 Prof.

Thanks guys. Will try it out on a test DB first.