Check the other scheduled processes that run during the same time. You probably have another job that is recreating that table while your maintenance plan is running. Or,...

benyos (9/6/2009)

---

You are absolutely correct.

You must use 3 part naming convention (Server.DB.Object) or even 4 part (Server.DB.Schema.Object) in order to get away with it.

If your solution refers to 10 objects...

In your situation, you need a combination of linked server and synonyms. You have to have the linked server for the connection to the other system/database unless the other...

The checkpoint won't cause you any problems - but, truncating the log breaks the log chain. You should never truncate the log unless you are fixing an unusual event...

Do you realize that 100GB is less than 10% of your 1.6TB database? Do you also realize that you want at least 10% (and probably more like 20%) space...

From what you have stated so far - I believe synonyms (or views) will work for you. I prefer synonyms because they are a little easier to manage and...

Steve Jones - Editor (9/4/2009)

---

You can shutdown SQL Server from within SSMS using SHUTDOWN as a T-SQL command. (http://msdn.microsoft.com/en-us/library/ms188767.aspx)

I almost never restart my servers from the command prompt. The GUI...

If you are looking at the first property page for the server properties, you need to understand that the number shown there as free space includes the transaction log.

It could...

HarryH (9/2/2009)

---

Was there any proper resolution to this?

I'm having the same issue with the Maintenance Cleanup Task (and xp_delete_file ) on many of my SQL 2005 servers (SP2 & SP3...

You are welcome - and it is good to hear that you are able to identify the problem.

That's great - glad you were able to get past that problem.

Instead of looking at the job history - try reviewing the maintenance plan history instead. You might find additional information there.

It wouldn't change a thing by cycling the service - SQL Server has to rollback all of the transactions in the batch. If the job you killed is a...

There must be something else going on here - as I can take a backup from prod (mirrored) and restore it to QA (non-mirrored) with no problems.

Is it possible that...

Apurva - if that is a process you perform on a regular basis, then yeah - it's really a waste of time to shrink it because you are going to...