If you saw a...

GilaMonster (12/10/2008)

---

Feel, maybe, though done properly though...

rbarryyoung (12/9/2008)

---

Actually, its called...

I have discovered quite a few stored procedures on our SIS system that use nested cursors and the queries are written using the old style join syntax (I hate that...

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.