Bump..sorry if thats not allowed.

I still cant find any solution to this problem and it worries me =)

I tried using the set of scripts given above from https://ola.hallengren.com/sql-server-backup.html...

Can anyone help with this issue...this is what is stored in the backupmediafamily table for a transaction log backup

C:\DBs\Backups\Volunteers\Volunteers_backup_2016_08_08_043001_1718650.trn

and this is what is stored for a full backup

{67896F2D-C306-422C-B95A-2491B8244E04}

No name/file location...

Nope no other backup happening...unless you count the host machine backing up the Hyper v guest.

All the transaction logs are fine, with filenames, but that is a separate job.

Rolf

Thanks for the reply.

I can restore them manually from ssms and tsql.

If I run the job or the plan from smss they have a filename in the ssms restore dialogue....

Can anyone help with retrieving the old backups..?

Any of the full backups done via the maintenance plan and a scheduled job have no name/location so I cannot restore them.

Thanks

Rolf

Thank you I will take a look...I still need to correct these existing backups though.

Anyone have any ideas how I can do that..? The file seems ok its just wherever...

Hi again,

Got this all working fine and have just been told that the pivot now has to occur over two columns so the data is like this

CREATE TABLE #SESSIONS (

SESSIONID...

Thanks for that, that is the structure of my dynamic pivot....should of just done that but I was trying to get to intermediate point without having to pivot which showed...

Hi Sean,

I read the dynamic cross tab post, very interesting. My issue is that the possible columns for each CASE statement (in your post dates) are completely unknown and variable...

Hi there,

I didnt include all the T-SQL as its very lengthy and its really a philosophical question rather than anything about the actual code being used.

I have included the snippet...

Whoa there.

It would really help if you had DDL that had keys, followed basic standards for dates, used a DATE data type, etc. This disaster is not even a table!...

Thaks that makes perfect sense, I was trying to avoid more group bys.

I need to collect a whole bunch more data in this query to do with totals and skills...

This is interesting.

So out of these which would result in a calculation for ALL numbers in the tally table and is there a way of telling?

WHERE NUMBER <= DATEDIFF(M,#FIRSTDATE,#SECONDDATE)

WHERE NUMBER...

wow..weird....I guess it makes sense to the DB architecture and the execution plan but it doesn't make any sense to me to evaluate the DATEADD clause for all the numbers...

Sorry missed your latest reply...that works..I had tried something similar before but it doesnt 'fit' in with some of the other aspects of the SP.

I'm still confused/interested as to why...