DQS Restore

Question

DQS Restore

Steve Jones - SSC Editor

SSC Guru

Points: 736478
More actions
September 10, 2015 at 10:10 pm

#320521

Comments posted to this topic are about the item DQS Restore
September 11, 2015 at 9:46 am

This was removed by the editor as SPAM

Viewing 13 posts - 1 through 12 (of 12 total)

You must be logged in to reply to this topic. Login to reply

Koen Verbeeck SSC Guru Points: 259115 More actions · Answer 1

Nice one, thanks.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

George Vobr SSChampion Points: 10009 More actions · Answer 2

So this is something new for me, thank you Steve for this very interesting question.

Ed Wagner SSC Guru Points: 287026 More actions · Answer 3

I've never used DQS, so I learned something new. Always a good way to end the week. Thanks.

Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions

SQL_Hunt SSC-Dedicated Points: 33518 More actions · Answer 4

Nice post.

But, one question here, do we not need to restore "DQS_STAGING_DATA" database also?

Thanks.

patricklambin SSCrazy Eights Points: 9994 More actions · Answer 5

For the week-end a good question about a topic which I have really not used except twice during presentation. I have been surprised to have provided the correct answer ( I have hesitated to choose the 4th choice ).

So thanks for this question and I have dived in the provided link ( useful .... ).

patricklambin SSCrazy Eights Points: 9994 More actions · Answer 6

SQL-DBA-01 (9/11/2015)
Nice post.
But, one question here, do we not need to restore "DQS_STAGING_DATA" database also?

As I am curious and a quick search i found in

" DQS_STAGING_DATA provides an intermediate staging database where you can copy your source data to perform DQS operations, and then export your processed data."

But my knowledge about DQS is too small to exploit this link.

patricklambin SSCrazy Eights Points: 9994 More actions · Answer 7

Please , could you have a look at this link ?

I think that you have to restore this database to the same state as it was before the modifications provided on Monday to be sure to have correct results.

akljfhnlaflkj SSC Guru Points: 76202 More actions · Answer 8

akljfhnlaflkj

SSC Guru

Points: 76202

September 14, 2015 at 7:14 am

#1826335

Never used this before.

Steve Jones - SSC Editor SSC Guru Points: 736478 More actions · Answer 9

patricklambin (9/13/2015)
Please , could you have a look at this link ?
I think that you have to restore this database to the same state as it was before the modifications provided on Monday to be sure to have correct results.

You may need this. I confess I didn't restore a DQS system to test this, but it likely is needed.

However it doesn't affect the question and answer here as it's not mentioned.

patricklambin SSCrazy Eights Points: 9994 More actions · Answer 10

Hi Steeve ,

I hope that you are not angry against me. I have done some research only as reflex I had often in forums from another site than SQL Server Central. Moreover , I am curious and it was a way to gain some new knowledge about a topic I don't use and have not really studied.

Ii was just a little add-in to a reply which was asking about a possible 3rd necessary restore.

And I have learnt something today , so I am happy....

Steve Jones - SSC Editor SSC Guru Points: 736478 More actions · Answer 11

Not angry at all. Just responding. I think you are likely correct that this is needed for DQS. What I'm not sure if if it's needed as a restore or just create a new db that DQS can use.