In Confluence, how do you get all pages on new Cloud configuration?

[Lindsay Rall]

Right now, half of my pages seem to be using the new cloud layout and half are not. I would like to create a global template with the new cloud configuration/settings but that doesn't seem to be an option. Any new pages I create in my Confluence space are in this new format, new templates are not.  Example of global template I just created:

[J. Caldwell · Accepted solution]

So...don't rely on the XML backup for Confluence for your disaster recovery or your regular backups. There is too much that can go on and cause the backup to fail or be corrupt. Atlassian recommends separate database backups and filesystem backups. The above example of a problem is a great example of why you shouldn't rely on XML.

That being said...

select * from CONTENT where CONTENTTYPE = 'ATTACHMENT' and CONTENTID = '4522021';

will get you a page ID. From there, go look at the page and see if anything is obvious about the attachment. There's a possibility you have a broken link/orphaned attachment. 

[Martin Boulanger]

Thanks for you help.  This was exactly the problem.  I had about 25 deleted attachments (all gliffy files) that were deleted on the file system but were still referenced in the database.  I deleted these and my backups are working again!

[J. Caldwell]

Cool. But again...if it is production data and you care about it, you need to not rely on the XML backup approach. You need something really reliable and simple for backups. 

https://confluence.atlassian.com/doc/production-backup-strategy-38797389.html - Check out the second section. 

[Martin Boulanger]

Thanks for the link.  I will add this to my todo list.