ooops !

Redgate's is rather cumbersome last I knew, requiring and extra product install and several steps. The Idera uses the regular restore GUI, and you just click table restore & choose...

That's the easiest method, unless...

There probably is a lock. In SSMS, activity monitor, look at process info all the way to the right under "blocked by" and "blocking". Sort the "blocking" column and see...

You can create "Legacy" DTS packages in 2005, but might as well go with the new SSIS instead.

Smaller tables often cannot be completely defragmented.

Here's another thread with some info:

http://www.sqlservercentral.com/Forums/Topic710123-360-1.aspx

1) Create your backup script or maint Plan

2) Create a scheduled job eg, every day at 1 am

3) Under "Duration" set the Start Date and End Date

Would SUBSTRING work ?

WHERE SUBSTRING(CC#, 13, 4) = '1234'

Have you done a clean reboot of the server ?

And why is there no backup ? Are your other databases backed up ?

Thanks ..... so where does "db_state_option " fit in ?

Quoting Paul earlier " ...Yes...

I seem to recall a similar problem with someone else. I think they had unreplicated transactions, so the transactions could not be removed from the log.

In yesterday's thread on this topic, I posted a couple of scripts I use to look at overall growth:

http://www.sqlservercentral.com/Forums/Topic781348-146-1.aspx

"...Both the servers are on a different domain..."

As I recall, you'll also need an administrative level SQL Login on both servers with the same name & password.

I've built a couple of queries using the existing backup history tables in MSDB:

-- Average DB size by month for ALL Databases

select a.database_name,

datepart(year,a.backup_start_date) as 'year',

datepart(month,a.backup_start_date) as 'month' ,

avg(cast((a.backup_size /1073741824) as...