Hi,

I am a newbie to microsoft exams, have been a dba for 2 years and have read through the real sql server 2008: implementation and maintenance exam and the MS...

Hi fixed it last night very happy. used case to sort it:

SELECT rawdata,

SUBSTRING(RAWDATA, CHARINDEX('author={',RAWDATA) + 8, CHARINDEX('}',RAWDATA) - (CHARINDEX('author={',RAWDATA) + 8)) as Author1,

SUBSTRING(RAWDATA, CHARINDEX('year={',RAWDATA)+6, ((CHARINDEX('}',RAWDATA,(CHARINDEX('year={',RAWDATA) + 6)))- (CHARINDEX('year={',RAWDATA)+6))) as year1,

CASE...

Hi SSCrazy,

Thanks for the script had a go this weekend made some edits:

SELECT rawdata,

SUBSTRING(RAWDATA, CHARINDEX('author={',RAWDATA) + 8, CHARINDEX('}',RAWDATA) - (CHARINDEX('author={',RAWDATA) + 8)) as Author1,

SUBSTRING(RAWDATA, CHARINDEX('year={',RAWDATA)+6, ((CHARINDEX('}',RAWDATA,(CHARINDEX('year={',RAWDATA) + 6)))- (CHARINDEX('year={',RAWDATA)+6))) as...

One other thing, the main reason this has to be done is that there are non-standard characters in the text like letters with dashed, umlouts? etc and so I cant...

Thanks for the fast reply grasshopper

can you give me some clues on what you wrote

When you get to a row that begins with @article, you empty out a...

Thanks for the response I am really grateful and will give it a go over the weekend and let you know how it goes, an example of when it carrys...

Thanks for the help.

The only issue with this method is that in some cases a line e.g. author maybe longer than a line and roll over to the next...

That worked thanks.

So the report gives me this for the past few days - but no backup ran last night. So it does appear that there vertias is backing it...

Hi,

May thanks for this.

My server name is esrisde\development, how can I enter this in your sql without bring up an error.

Many Thanks as always,

Oliver

OK I will try that instead. Is there anything to be said for using both to backup because they are using different services and if one service went down you...

Adi,

I think this is the case. I have checked the backups and it appears that its doing a full backup. I have now selected Veritas to simply do a Database...

Gail,

Thanks again.

No I made sure that I did not miss any logs since the full backup. I understand the the veritas backup does do a database backup as well as...

Adi,

Thanks for your reply. Over the weekend I tried to restore the database, I wanted to restore it to say a couple of hours earlier so I clicked the full...

The error I reported was from when I tried to restore yesterday which is why the numbers are not the same as the ones above. I will try to run...

Gail,

I attach an image of what I was trying to do, I dont want to recover all the transaction logs because it may well be the error was made 4...