my share snapshot folder was emptied out after the first reinitialization ( 1 month ago)

hi, thanks for you reply Sue, I don't think I understand fully, how did I have an available snapshot already? how can I check that so it doesn't happen again?

thanks Sue, i was hoping maybe with sql 2014 there was a feature to cleanup better than doing manually 🙂

thanks for your recommendation, did you also have transactional replication? the issues with our refresh is usually the time it takes for the restores and also the reinitialization of replication...

hi, i was planning on removing the databases I refresh from availability group. QA users can continue using those databases as well as others in the primary. I...

thank you Grant! yes QA do writes and updates . Thank you for your recommendation, i will look into the redgate tool.

thank you Grant!

Update: It was too hard to go with the approach of importing the data from the table with the corrupted page into a new table. This table had many...

good catch, you are correct! the database id is not 3. It is a user db.

Thank you Grant for all your help! really appreciate it. I...

thank you Grant for your reply. this is a 2 Tb db, this table in question is 15 Gbs. I will try your second approach.

"Drop the...

I restarted the services and that solved the spid running in the background for days.

yes i do have replication running

can i try to kill this spid? or since is an internal spid, the only way to stop it is to restart services?

ok thank you.

I checked the server and this data file is not present there.