Frequent transaction log backups can help manage log growth.

AP = Accounts Payable

They are a specialized group in our company for hacking into certain products 🙂

How much free space is in the .MDF and .LDF ?

I had Redgate for a 14 day trial. I was able to crack it and use it permanently by generating a PO and then following the steps through our AP...

Is that the message in the job history ? Are there error logs being written out ?

In what way are you unable to shrink ?

Why do you want to shrink ?

It looks like you...

I think the idea is that although Windows has "marked" it as deleted and available for re-use, a recovery tool can read the sectors marked as deleted and rebuild the...

Did you check the Recycle Bin ? The little bit that I know is that you should refrain from doing any writes on the affected drive so that a recovery...

You could search your SPs for the table name. It won't tell you if the SPs are used, but can be helpful in general.

select name, crdate, CHARINDEX('TableName', definition),substring(definition,CHARINDEX('TableName', definition)-25,150)...

This topic has been covered many times. Search "Delete Duplicate", and get pages of threads such as these with different methods.

http://www.sqlservercentral.com/Forums/Topic652644-338-1.aspx

http://www.sqlservercentral.com/Forums/Topic825096-338-1.aspx

http://www.sqlservercentral.com/Forums/Topic403032-338-1.aspx

A job has started that requires a lot of CPU

If your delete statement is so huge that it takes 2 days to complete, you might want to think about breaking it into smaller batches, or a loop. Then you'll...

CREATE TABLE #TableSpaceUsed

(Name nvarchar(128),

Rows char(11),

reserved varchar(18),

data varchar(18),

index_Size varchar(18),

unused varchar(18))

insert into #TableSpaceUsed

exec sp_msforeachtable 'sp_spaceused [?]'

select * from #TableSpaceUsed

order by name

The error looks pretty self explanatory. Not sure how to help based on the info given.