The following link may be of assistance to you

https://docs.microsoft.com/en-us/dynamicsax-2012/appuser-itpro/guidance-when-upgrading-reports

Not sure if I totally understand what you're doing but when I did this to upgrade to 2016 SSRS I installed SQL Server 2016 for the reporting server and used...

On top of what the others have mentioned here, I've had issues in the past of snapshots causing the backup chain to break .. not really sure what the deal...

• This reply was modified 7 years, 3 months ago by oogibah.
• This reply was modified 7 years, 3 months ago by oogibah.

I would also add I don't trust deduping any more than I do compression and I have a job that does a test restore every day using a restore headeronly...

I did in fact run into this issue, but our solution might not work for you

We have a datastore we move all but the most recent backup-set(we copy that.. so...

• This reply was modified 7 years, 3 months ago by oogibah.

I really doubt it would be a network issue unless your log file is for some reason stored on another server?

Granted that your DNS is clean .. and has forwarders and your spns are correct, it should work once the domains have trust.

Just a note I remembered when reading this.. I did see a video SOMEWHERE that pretty much said you always want to wrap just about everything in transactions in the...

Thanks for the follow up.. silver lining I guess... great for AD cleanup

If you're compressing 2012 backups I hope that you have a process in place to do test restores to make sure that they are valid.  Otherwise I feel like you...

TL;DR

Because of the way modern encryption works ,very few strings are identical therefor:

Compression no happen good

GRANT BULK INSERT ON [TEMPDB] TO [User]

would work wouldnt it? .. granted I don't know enough about tempdb to know how destructive something like this could be 😉

• This reply was modified 7 years, 3 months ago by oogibah.

While I don't know the answer to your question specifically.. a word of caution.. if you're not on SQL Server 2016 CU7 or SP1 CU4 .. compression + encryption can...

It just depends on the nature of the table.. if I can avoid deleting data I prefer to do it another way, whether that is checking if the table already...

.. or using

I hate using truncate/deletes.. granted .. not sure if your account/service account will have access to sys tables

IF NOT EXISTS (SELECT name FROM database.sys.tables where...

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