It depends. It sounds like you have the basic bases covered. Now the outstanding question is whether there are other users that were members of the admin groups...

The database backup will block the log backups. (And vice versa, I believe.) I would schedule the database backup to start just after a log backup. That...

When a job completes, it either fails or succeeds. So, use 'When the job completes' to cover the other two.

Also in the link:

This hotfix contains only those files that are required to correct the issues that this article lists. This hotfix may not contain of all the files that...

While I totally agree with everyone that you should update the statistics after a large archive, I disagree that it will have anything to do with this problem. The...

Is your select as plain vanilla as you say? Are you using DISTINCT/WHERE/ORDER/GROUP?

Jey,

When you took your backups did you use the WITH INIT option for both? If not, you may have appended your backup onto an existing backup. When you...

You might try tracing the execution plan from each source to check for differences.

Also, what is the timing of the two executions? If the long runner runs first, then...

Its been several versions of everything and several more years than that since I last used Access to attach to SQL databases, but I'll take a stab at this anyway....

In order to restore to a point in time, your database backup must predate the point-in-time. Log backups can't take a database back in time.

Dan,

To re-iterate what I said in my response to your other thread: don't do it. The headaches you will have maintaining all those tables and the trigger just aren't...

Your lead column on your clustered index is Respondent. I doubt that is a terribly useful column in your statistical analysis. On your reporting database, try reclustering with...

Good plan, with a couple of additions. There are a couple of places where the server name is kept - since you are renaming the server, you will need to...

sysindexes.name is not a nullable column, so this seems fishy. What is the indid of the index in question? What does this give you:

select 'drop index [' +...

It's been a while, but as I recall, you don't. Sybase's TIMESTAMP is a poorly named datatype, and actually there is no way to extract the date/time from the...