OH DRAT!!!
I ACCIDENTALLY DELETED AN ENTIRE PROJECT OFF OF TABLEAU SERVER INSTEAD OF JUST DELETING ONE WORKBOOK!!!
WHAT DO I DO?
Options:
Pros & Cons:
Recover from latest backup of TS (best for critical workbooks/projects)
- PRO: it doesn’t matter whether TS-dev is on the same version
- PRO: workbook history is maintained
- PRO: workbook links are maintained
- CON: everything published since last backup will be lost
- Use server to find newly published workbooks, but it will find newly published as well as recently refreshed workbooks, hard to distinguish, may have to manually poll known publishers (alternatives would be to use the REST API or Postgres DB to check for newly published workbooks)
- CON: All data extracts will be stale (reverting to where they were at time of last backup. Every night tableau is backed up and restored onto tableau-dev and tableau-beta)
- Most workbooks include morning refreshes so will recover by the following morning at the late
- Order of operations
- Advise affected project users to use tableau-dev
- Try to wait until after business hours to revert to previous backup
- During restore could advise all users to use tableau-dev
Republish everything from scratch
- PRO: Doesn’t affect anything else on Server or users outside the project affected
- CON: Workbook-specific and project-specific bookmarks will change
- CON: Could be very time-consuming
- CON: Finding the right desktop version
- CON: Republishing after downloading from TS-dev is tricky if workbooks use published datasources
- CON: links/shortcuts change
If Tableau-dev is on same version, take snapshot of TS-dev and use it to restore TS (you’ll get what TS looked like at midnight)
- PRO: Workbook-specific and project-specific bookmarks won’t change
- CON: Everything published on TS since midnight will be lost and require republishing