The customer_Detail is being locked. I am thinking that the indexes have not been reindexed in over a month and it could be causing the issue.

You were absolutely correct.

This is the finished statement:

Select u.Dealer_Id, u.usage_date, u.usage_ipaddress, e.Employee_first_name, e.Employee_last_name

from usage_data u with (nolock)

Inner JOIN Employee e With (NoLock)

ON u.employee_id = e.employee_id

WHERE u.Dealer_id...

I used DBCC SHRINKFILE with EMPYFILE which moved whatever was left in the FileGroup to the PRIMARY and then it allowed me to remove the file group.

Let me phrase that, there is 0.25MB in the Blob File group which is preventing me from deleting it.

Is it because I am trying to search for a string of numbers with a wild card?

eg. SELECT ticket_id,ticketnote_id ticketnote_byname, Ticketnote_text FROM DMS_TICKETNOTES

WHERE CONTAINS(TicketNote_Text, '"*998877*" ')

This is the string...

Any other ideas? I even dropped the catalog and re-created it and it still doing the same thing.

Tried the following:

SELECT ticket_id,ticketnote_id,ticketNote_text FROM dms_ticketnotes WITH (NOLOCK)

WHERE Freetext(*, '"*%009988"')

Order by Ticketnote_id

Still no records.

They won't.

Thanks for all the advise. I have to figure something else out about the indexes because the database is too big for multiple full DB backups.

What would you recommed for...

Cool. What is the ramification for changing the recovery mode of you database?

We currently in full recovery mode in production mode. But every Sunday we run a maintenance task the...

Then I just apply the transaction log backup to new database as I would normally?

Now the million dollar question. Is there was to restore the full database backup to another database name and then apply all the transaction log backup to the new database?

I found the issue was I trying to restore a log backup that was associated with the previous nights backups.

That worked great. But I need run into an issue in testing. We backup our production database to tape and also take t-log backup every hour to disk. We tried...

So if I were to go with a single file transaction log backup how would I setup the job?

here is a scenerion

M - Full DB Backup @ 12:00am

...