The problem is your reindexing job. It causes the log file to become larger as it reindexes. This is normal. That huge log is what gets the reindexing over to...

I looked to fill out the survey, but it is no longer there.

I agree with what other have said on mail. When will they ask about the way Agent handles...

Just a shot in the dark here, but it sounds like the user the job is running under does not have the necessary remote access to the linked server. Have...

I wish. I have asked this question before and have gotten no good leads. I have heard though, that once you select it to be the view EM will remember...

Another thing that can make shrinking the tran log difficult is if the active portion of the log is near the end of the physical file. SQL Server will not...

You might also just replace the Builtin\administrators group with another of your own creation, such as domain\SQLAdmins, which has System Administrator rights on that SQL Server, then put the necessary...

quote:

---

One of our nice developers has managed to create over 300 indexes with a fill factor of 90 (good eh) on a...

For future refence, just write a script to do this job for you, then you don't need to create the DB ahead of time.

Drop Database [DB Name]

Go

Restore Database [DB Name]

from...

quote:

---

Do you mean database available space is 0.00MB? Try to run sp_spaceused @updateusage = true to the database and go back to...