Could you explain more what you did? A backup of a 2008 database cannot be restored on a 2005 server.

Disabling the constraint is not...

Lynn Pettis (3/18/2010)

---

The only other question then would be how long do you retain the snap shots? If you keep them too long, you will mostly start to experience...

GTR (3/18/2010)

---

Snapshot is good only is you know which table\data is modified. What If two or more DDL\DML changes were made during time frame (5:00 and 5:05) and you want...

DECLARE @StartDate DATETIME

SET @StartDate = '2010/03/01'

SELECT DATEADD(dd,-1,DATEADD(mm,1,@StartDate))

It is due to the read-only mode. The info on whether there has been a backup since the last break in the log chain is stored in the database header...

Grant Fritchey (3/18/2010)

---

Remember, MVP is about service to the community. Some, like Gail or Jeff, have near encyclopedic knowledge of SQL Server. Others don't. Just because an MVP says something...

No, bulk-logged retains tran log chain. That's why you can switch from full to bulk and back and the log's intact.

Full recovery = log retained, all operations fully logged

Bulk logged...

jpSQLDude (3/18/2010)

---

Do you think it makes any difference if you switch to Simple, then take a Full backup, then switch to Full Recovery Model; or switch from Full to...

It's only teaching if the other person is willing to learn. At the moment he doesn't appear to be. Same person who spent 4 pages justifying why posting a solution...

jpSQLDude (3/18/2010)

---

So is there any way to tell SQL, "Yo. Ignore all backups that have ever happened, reset to 0, all backups have been deleted, so this next Full...

Sorry Tom, one question.

You say there'll be 800 000 rows with the same batchID, but in the exec plan, actual row count was 0. Should it have been 0?

Also, if...

It's not particularly uncommon. I had a set of queries whose total cost added to 200% the other day. I think it's Kevin (TheSQLGuru) who has a plan somewhere with...

stefan.gustafsson 60897 (3/18/2010)

---

Just curious: What do you expect to find in the actual execution plan that might affect the solution ? In this case we already know that he gets...

I'll be very happy to give a solution once the actual execution plan...