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

Well like I mentioned in the original post, we have 2 domains and we perform a backup in prod and copy to dev environment and then perform the restore.so a...

The company is driven by business so whatever the business needs we need to provide, evn for setting up the QA test env they need the latest prod data not...