Are you clicking on the Execute button or the Parse button.

With the query highlighted, hold down the control key and press the E key.

let us know what happens.

While you are at it, here are two of my favorites from my previous employer (yes, I stll remember the code well, and it is also COBOL).

IF X = 1...

You can query msdb.dbo.restorehistory.

But the t-log backups will only have the transactions from entered since the last t-log backup.

Is your disk drive filling up during the full backup?

Paresh Prajapati (12/8/2008)

---

i have taken a log backup with truncate only, the chain of log sequence break..

but i nedd to take log backup with truncate..bac of log file size is...

bhushanhegde (12/5/2008)

---

hi,

my sql out put is something like as follows:

in...

chatexpert (12/6/2008)

---

Hi,

Please help me with a query to get records in the latest month.

I will be using this query in my reports which will be executed any time.

I have a...

Double posted. Answer here: http://www.sqlservercentral.com/Forums/Topic615077-8-1.aspx#bm615084

Yes.

You need the t-log backups generated during the full backup if you are restoring from a full backup taken EARLIER than backup running at the time the t-log backups were...

I can't answer you last question, but I can tell you that you don't need the t-log backup(s) that are run while a full backup is executing. I recently...

Either Raid 0 + 1 or Raid 10.

You really should have a separate disk for your backup files to land as well.

Sometimes people have to be hit the 2 X 4 to understand. I know, it happens with me at times.

Especially since Standard Edition comes with 10 CAL's and Enterprise Edition with 25 CAL's.

Dang, forgot my waders! :w00t:

GilaMonster (12/5/2008)

---

Since Steve's post was after the edit, I imagine he's referring to the question...