Is there a way to continue on errors?

I was finally able to restore most of the databases from SQL Managed Instance to a Local SQL 2019 Instance.

I used Visio Studio 2019 to 'Extract Data-tier Application (.dacpac).  I...

• This reply was modified 4 years, 4 months ago by DanielP.

Thanks Steve. This is Daniel P.  I am using Visio Studio to generate the .DACPAC file because you can uncheck 'Verify extraction' so it doesn't error on other database dependencies. ...

• This reply was modified 4 years, 4 months ago by DanielP.

I found an article that states to create a 'Scope' Credential but I think this applies only to Azure SQL Database.  The workaround I have is to use Microsoft Azure...

In Managed Instance, what is the Service Account?  Not the same as a regular instance where you setup the accounts and have control over it.

I forgot to create the new Credential in SQL for the new Azure Storage Blob.  Once I added it, I was able to create the Extended Event.

But now getting an...

Yes, that is all it was.  Thank you.  I meant to reply already.

Thank you.

I still think there is a need for someone with specialized DBA skills.  I see far too many developers with less database knowledge making poor mistakes that impact production performance. ...

thanks, found the object now.

Didn't solve the problem by changing the drives...But we switched to JTDS driver instead.

No, besides updating the TIBCO drivers.

Thanks for the reply Syed and Steve. Yes, Syed's idea should work. They would have to set up a new account\group for the service to do your approach...

Sorry, no just the defaults.

We had to set up Management Data Warehouse (MDW) to monitor. I was able to trace the SQL Code that was causing the blocking by drilling down the Server...