Hi Phil,

I agree with you but due to time constraint I could not investigate this issue in production. Prior to performing the process, I did performed the backups of msdb...

Nice article.

I've not said that this is a known issue, I said I think this is a known issue. Yes this needs to be done as last resort. In my article,...

Hi Phil,

Thanks for your comments. We are backing up the transaction log every 15 minutes. This article has been written for particular situation that is mention below:

According to SQL Server...

Thanks for this excellent article.

Thanks for this useful contribution.

Excellent article....

Specify the date format at the start of the script as follow:

SET DATEFORMAT DMY;

<Your script>

.....

...

..

<YourScript>

Open SQL Server Configuration Manager and verify that SQL Server service is running. Also check the account under which service is running is running is not locked and its password...

Rem70Rem,

1 in running column means job is currently running and 0 means its not currently running.

Rem70Rem, John,

You can use master.dbo.xp_sqlagent_enum_jobs to find out what jobs are currently running on SQL server (see below):

CREATE TABLE #xp_results

(

...

okbangas (3/13/2012)

---

First of all, I am really a fan of CTEs, as they give a lot of flexibility and readable code. However, in this case I find that the CTE...

anthony.green (3/12/2012)

---

Thanks Basit, I'm diving deeper into this when I get a moment aside from the other things I'm working on.

One thing I would like to know is say I...

bgdjwoods (3/12/2012)

---

Good article, however; before anyone decides to use this method as their form of DR, I would highly recommend they rethink this. Unfortunately in your situation you were...

anthony.green (3/12/2012)

---

thanks, I think my little understanding of programming languages lets me down on this.

i've only ever had exposure to T-SQL as I'm a DBA, never been a developer so...