1) Yes

2) Yes

SP3 has been out for a loooooooong time ....

Here's a thread about identifying bad date values. Maybe it will help

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

Maybe you are getting blanks, not NULL .... they are not the same

try:

where open > ''

Make sure you're on at least Service Pack 3. I hear many Maint Plan bugs were fixed from earlier releases.

getdate() is the system datetime. You could make getdate() be the default value in your SQL table so that it gets populated when rows are inserted.

I would suggest installing at least SP3 to get the current fixes to maintenance plans.

I think you would need to copy the data into new tables ... not fun, but maybe someone else has details ?

You can use COLLATE in your queries to allow...

If your truncate happened on Tuesday at 2:00 pm, get the backup file closest to, but earlier than Tuesday 2:00 pm, for example Monday night at 11:00 pm.

If your database...

How close in time do the duplicate jobs run ?

You could have just 1 schedule, but it is set as recurring twice in a small timeframe.

For instance, "Run every...

msharma-393915 (3/8/2011)

---

I was doing a full back up of the four databases on the data server without realizing that if the database recovery model is FULL , it's vital to...

Use the GUI to set up the restore, then use the "script" function to create your script based on what you chose in the GUI. You could then put that...

You have 8 gig RAM, but how much is allocated to SQL ?

How about a maintenance plan with a cleanup task ?

Can you take a differential now after your new full backup ?