@jeff

Thanks again for your valuable inputs and directions .. now i do have robust road map to follow and fix my DB issues ..

Appreciate all your help !!

@Grant

You are spot on,the removal of the unused PK might have caused creation of  big stack of heap tables which i will need to fix  moving forward ..

Thanks for you...

Thanks again Jeff

Like i mentioned this DB is massive and queries are running fine as expected , issue here is the DB is chewing up massive amounts of disk space...

@jeff ,

Thanks a lot for these ideas i will do my research on the topics outlined

Moving PK /FK to file groups / Compression/Forwarded Rows i will try to look into...

Thanks Fred for your suggestions  and KingswaySoft for the good software info ..

I followed these steps and it worked like a charm but i would not say this would work...

Thanks Fred, that was my last option but looks like its my only option.

Forgot to add this error message too

This occurs when CPackage::LoadFromXML fails.

HTTP Error 503. The service is unavailable.

This is out dev box and has no access to Internet , have installed the .net framework 4.8 and reboot the server .

Restarted the...

Bernard,

Thnx for your solution , we did an upgrade from 2012 Developer to 2016 Standard . I have never did SSRS earlier (Data Driven subscriptions part). So i might need...

@palandri does that cause an issue its the truncation error we can ignore.

I can go to advanced and get rid of truncation errors .. but still not loading

@blakemcneill

Thanks for the awesome post , i followed the step by step you mentioned but i have a question ..let me explain my steps

Guide me to migrate reports from sql...

• This reply was modified 6 years, 6 months ago by JSB_89.

Thanx Jeff will check with the SAN team, but going back to my original question views and synonyms are a big no no correct??

That’s a long process to get approval from IT manager and jump thru all the hoops.

That’s for a later day

Full backups