Sam,

Interesting thought. I thought my most successful IT group was one where we released a new version (web apps) every Wed, tackling things that could be done in 1 or...

touche!

It's changed

I'm not sure it matters how the technical order of the restore goes. Once you start a log, it will complete as a single unit or work. It will work...

http://www.sqlservercentral.com/columnists/lPeysakhovich/anaudittrailgenerator.asp

http://www.sqlservercentral.com/columnists/sjones/auditingyoursqlserverpart4selectiveauditing.asp

Not to be difficult, but are you double checking to be sure you're looking at the right db? I've made that mistake before.

Also, is there a lot of insert/update/delete activity...

Need to have "go" between the statements. A create table needs its own batch

How are you trying to "connect" between the systems?

at every checkpoint

When you switch recovery modes out of simple modes, then you do need a fullbackup. You can switch between bulk and full without this. If it fails after your load,...

Everything is part of a transaction. That is how the server can recover in between any crashes or reboots and maintain integrity.

select

o.orderid

, o.orderno

, sum( ssamount)

from ordermaster o

inner join orderdetails od

on o.orderid = od.orderid

group by...

Data consistency is needed within a transaction, which is what the log provides. A backup is a copy of the db at a point in time.

So if you backed up...

Tried to give them feedback, but the time wasn't long enough!!!

What did you have in mind? It can be hard to list a bunch of items for any particular date when people are all over the world.

If the web page has nothing to do with the job, not sure what the relationship is. Does the web page do more than run an insert and then need...