Thanks, I see. So using STOPAT would allow recovery to, say, 7:45 AM if the last log file contains transactions between 7:30 AM and 8:30 AM?

Also, regarding using NORECOVERY in...

Here's what I have so far. It is very crude, containing only what I needed to get the restore done. I know others probably have many improvements for purposes of...

Steve Jones - Editor (2/21/2008)

---

You can perform a backup to multiple files, meaning that if you had 2 files, 1/2 the data is in 1 and 1/2 is in the...

Steve Jones - Editor (2/20/2008)

---

It looks like you performed a striped backup and then tried to restore one file. At least that's what it seems.

Did you restore the same files...

Andy Leonard (2/8/2008)

---

There's the potential for a slippery slope here, but I think Karma nailed the solution - black box testing is good enough for pharma regulators, it should be...

Jamie Longstreet (2/7/2008)

---

Ah, can we lobby for points? [Sounds like going to court for a traffic ticket cuz ya know the officer won't be there.] Stupid Interviewer...

GilaMonster (2/7/2008)

---

In addition, from what I know, there's nothing that prevents me from using functions, constants and variables as new data for the table, so it doesn't always come from...

Minor comment (although I got the right answer): The question asked "Which versions..." but the form had radio buttons, so only one option (i.e., "Which version..." - singular) could be...

Sorry, it was a mistake because the site was running slowly, so I clicked the submit button twice. (I won't do that again.)

However, I tried to delete the extra post...

===== Call off the search. :w00t:=====

I found the query source. Gail, After reading your confirmation that the SQL:BatchCompleted could be from a web front end, I checked our scheduled tasks...

Thanks, everyone.

Yes, the query is just a select statement. I will try to trace the batch starting and also see if Sergiy's suggestion of using sp_who2 can provide more information.

webrunner

PS - I also included HostName (I did not see any column called IP, but I see IP addresses in the HostName column), but it too comes back blank for...

Hi,

Thanks for your reply.

The event class is SQL:BatchCompleted. I added ObjectName but the column is blank for this query. And the fact that it runs like clockwork every 5...

Great article, thanks. I especially like the reminder to build and use databases for practice (music catalog, recipes, etc.) - I don't do enough of that experimentation, but it is...

An example of this problem is one that may sometimes be subtle yet dangerous - email addresses. Email addresses in a test system can inadvertently be used if the production...