You are welcome! 🙂

Try the next thing.

Create a database with the same exact name and exact files in the correct orders.

i.e: DB NAME = TEST

FILES = File1.mdf, file2.mdf, file3.mdf and log.ldf.

take the database...

Usually, the dashboard shows every replica, is the secondary replica displayed in the dashboard?

Hello,

I suppose you have access to the package, the only way to find out is downloading it and executing it and while you are at it, you can actually set...

Why not just take the backup in that server?

Just share a folder/drive on that server and give the sql server service account permissions to write there.

To add something,

Its recommended to have all the tempdb data files the same size, that's why Microsoft have added a feature in which not only one file but all of...

We had this issue migrating from 2008 R2 to 2016 and by issues i mean, performance degradation in some queries. don't know if you upgraded from that early of a...

If you have corruption in older backups, try restoring and executing DBCC CHECKDB with repair_allow_data_loss in another environment.

If it fix the issues great, run DBCC checkdb again to check for...

Which version of SQL Server are you using?

There's a blog post from Paul Randal regarding an issue when migrating from 2014 to 2016 or later versions, you might wanna take...

Yes Jeff, i think the SAN guys found some issues and have been working with the provider, no outages, thank god it was only one filegroup.

prettsons, looks like defunct filegroups...

Thanks!.

We could restore and even though the database was corrupted, we used the standard restore procedure.

Full > differential > logs

At the time we got corruption, our full and differential backups...

Thanks for your reply guys,

We could not remove the corrupted filegroup.

Mr. Steve, we found the issue and fixed is asap, we have open cases with our different partners and finding...

The last one completed and this was the SQL Server message:

DBCC CHECKDB WITH REPAIR_ALLOW_DATA_LOSS

Date 9/18/2019 4:02:02 PM

Log SQL Server (Current - 9/18/2019 4:44:00 PM)

Source spid67

Message

DBCC CHECKDB (DB_CLONE, repair_allow_data_loss) WITH all_errormsgs,...

Hi Jeff!, thanks for replying!

There were errors and the new CHECKDB WITH REPAIR_ALLOW_DATA_LOSS fixed again lots of errors, i'll add the output(attached) and the SQL Message.

After it completed we ran...

After running DBCC CHECKDB with REPAIR_ALLOW_DATA_LOSS, it lasted 3-4 hours in a VLDB, not even mad, that's amazing

this was the output.

SQL server log:

Message

DBCC CHECKDB (DB, repair_allow_data_loss) WITH all_errormsgs, no_infomsgs executed...