Before transfering the data, change the recovery model of your test database to use the simple recovery model.

Not sure what kind of script you are talking about. If there are any structure changes, SQL Server will handle that for you.

I'd check to see if another full backup was run between 02:00 and 06:00. Start by checking the msdb.dbo.backupset and msdb.dbo.backupfile tables.

Also, if the full backup actually was completed...

Just to be sure, post the actual code you used.

The two fields have different collations is all I can come up with not having the DL for the table. Script the create statement for the table and look...

I'd check the execution plans of the update queries. Sounds like there may be some missing indexes.

Are you using an Access Project (*.adp) or an Access Database (*.mdb)?

I have to second Seth on the approach. Start by writing your query simply as a select query, starting with the main table first and all the data elements...

Try this:

with ParentCommittee (

CommID,

CommName

) as (

select

comm_id,

comm_name

from

Committee

)

SELECT

c.comm_id...

Take your post and expand it some. You provide some sample data, show us what the final results of the query you are try to write would be. ...

Good catch on str. I kept seeing it and ignoring it also.

One thing to remember, when we ask for sample data, we aren't asking you to provide the entire data set. We just need enough data to test what we...

GilaMonster (11/4/2008)

---

Lynn Pettis (11/4/2008)

---

Don't simply truncate the transaction log. You will break your log chain, and won't be able to do a restore to a point in time. ...

Try this:

(

CASE WHEN t.ItmRecvdYR1 > t.ItmRecvdYR2

THEN CONVERT(VARCHAR,((((t.ItmRecvdYR1) - t.ItmRecvdYR2)/(t.ItmRecvdYR1 * 1.0)) * 100)) + '%'

WHEN t.ItmRecvdYR2...

Two questions. What are the data types of the columns in the expression? What value are you getting currently?