1. Open your SQL Server Configuration Manager(SSCM), make sure your SQL Server service is running.

2. Check if the Client Protocols are enabled in SSCM, especially the TCP/IP protocol.

3....

If the sequence of Transaction log is broken due to a corrupted log file, then in order to get the sequence back you must restore the complete database backup from...

Nice Script and nice output in mail..thanks for posting here

you can try this script.....

SELECT

[sJOB].[job_id] AS [JobID]

, [sJOB].[name] AS [JobName]

, CASE

...

That was very helpful link...solved my problem and my job is running smoothly now .

thanks

nice script very handy...

Hi Steve ..

I am trying to delete old t-log backup files using maintenance plan and it works fine but when i check the files in backup device the old...

okay got you GEOFF ..thanks thanks...

have a good day ahead if you are in USA..lol;)

Hi Geoff..

Like to know one thing regrading to your script

exec master.sys.xp_cmdshell 'PushD "\\YOUR\UNC\PATH" &&("forfiles.exe" /S /M "*.trn" /d -7 /c "cmd /c del @file") & PopD'

GO

to

exec master.sys.xp_cmdshell 'PushD...

thanks Jason for help too..

Thanks Geoff

I tried on local machine and it works fine .thanks for nice explanation.

I can change to the any number?- 7 to 15 or 30?

i have log files located in backup device so should i have to put backup device name in that path? or it will find automatically .trn file ?

E.G ...

can you specify with example ? i am working on same scenario .

great very helpful

thanks

Maintenance plan works fine but old T-log backup file not getting deleted.

T-log backup file located on network drive in Backup device.

Any idea?