mister.magoo (2/12/2013)

---

Sean is right, however in this one case you can make it seem like it works....

SELECT *

FROM (

SELECT*,row_number() OVER(PARTITION by TType ORDER BY TTime,TFunction,TStatus) AS rn

FROMMyTransactions

) a

ORDER BY rn,TTime,...

Attached are the current and required output screen shots. Note that i have created the required output in excel 🙂

Thanks Lowell. Unfortunately not, it still does not group them together.

There should always be an outgoing after an incoming, and we need to make sure both are of same function...

Thanks everyone, i got it working using OR.

Kl25, thanks a lot for the idea. Your query gave a slightly different result but i used your idea to generate the required result.

Basically first find the minimum group id...

you are right, but we do full backups daily so re-initializing log shipping using diff was not possible because it was broken for over a day and we already had...

We stopped the SQL Writer service, stopped the log shipping backup jobs and then re-initialized the log shipping by restoring a full backup.

Other option was to find the tlog backups...

Thanks for your responses.

We figured out the issue, it was because of the NTBackup that we setup for our VMs.

Here are more details about the issue and resolution.

More details about...

i ran select GETDATE(), SYSDATETIME() on the server and it gave me same values...

I am using SQL Server 2008 R2 on Windows Server 2003 R2 machine.

I figured out an alternate which is giving me the actual file name. Instead of using Backupset table...

Thanks for the response Paul.

That's exactly what i checked and it was right, defualt schema is Forum with db owner permissions.

I wonder some how during the upgrade process it has...

Thanks Steve, no i am not auditing the connections.

Thanks Steve, but will this service upgrage cause any issue?

Thanks Tara, i will try this strategy.

Thanks Roy, appreciate your response. That's the strategy we have planned and tested so i am glad that you have verified it.