How to restore a Data Warehouse - Revision history

Jeff at 02:10, 2 February 2022

2022-02-02T02:10:42Z

← Older revision		Revision as of 21:10, 1 February 2022
Line 7:		Line 7:
	# Navigate go to Workspaces\Backups\Data Warehouses folder		# Navigate go to Workspaces\Backups\Data Warehouses folder
	# Copy the Backup of the data warehouse which was working last.		# Copy the Backup of the data warehouse which was working last.
	## ~~To see which one worked last check out~~ the Get Data Logs ~~for~~ the last one which suceeded		## Check the Get Data Logs to determine the last one which suceeded
	# Paste it into the Workspaces\[Your Workspace] folder		# Paste it into the Workspaces\[Your Workspace] folder
	# Re-run the get data process		# Re-run the get data process

	If that doesnt work, you might need to go back to a earlier backup		If that doesnt work, you might need to go back to a earlier backup

Jeff at 02:10, 2 February 2022

2022-02-02T02:10:09Z

← Older revision		Revision as of 21:10, 1 February 2022
Line 7:		Line 7:
	# Navigate go to Workspaces\Backups\Data Warehouses folder		# Navigate go to Workspaces\Backups\Data Warehouses folder
	# Copy the Backup of the data warehouse which was working last.		# Copy the Backup of the data warehouse which was working last.
			## To see which one worked last check out the Get Data Logs for the last one which suceeded
	# Paste it into the Workspaces\[Your Workspace] folder		# Paste it into the Workspaces\[Your Workspace] folder
	# Re-run the get data process		# Re-run the get data process

	If that doesnt work, you might need to go back to a earlier backup		If that doesnt work, you might need to go back to a earlier backup

Jeff at 02:09, 2 February 2022

2022-02-02T02:09:14Z

← Older revision		Revision as of 21:09, 1 February 2022
Line 6:		Line 6:
	# Cut the corrupt data base and paste it outside the ODBClink folder to keep it just in case		# Cut the corrupt data base and paste it outside the ODBClink folder to keep it just in case
	# Navigate go to Workspaces\Backups\Data Warehouses folder		# Navigate go to Workspaces\Backups\Data Warehouses folder
	# Copy the Backup of the data warehouse.		# Copy the Backup of the data warehouse which was working last.
	# Paste it into the Workspaces\[Your Workspace] folder		# Paste it into the Workspaces\[Your Workspace] folder
	# Re-run the get data process		# Re-run the get data process

	If that doesnt work, you might need to go back to a earlier backup		If that doesnt work, you might need to go back to a earlier backup

Jeff: Created page with "== Overview == A Data Warehouse is a Database. If its an MS Access database its possible that it can get corrupted. If so it will generally show a message that it contains unr..."

2018-08-09T00:36:28Z

Created page with "== Overview == A Data Warehouse is a Database. If its an MS Access database its possible that it can get corrupted. If so it will generally show a message that it contains unr..."

New page

== Overview ==
A Data Warehouse is a Database. If its an MS Access database its possible that it can get corrupted. If so it will generally show a message that it contains unreadable content. Restoring a data warehouse is a matter of locating a backup and then copying it into the Workspaces folder

== Procedure ==
# Go to the ODBClink\Workspaces\[Your Workspace] folder
# Cut the corrupt data base and paste it outside the ODBClink folder to keep it just in case
# Navigate go to Workspaces\Backups\Data Warehouses folder
# Copy the Backup of the data warehouse.
# Paste it into the Workspaces\[Your Workspace] folder
# Re-run the get data process

If that doesnt work, you might need to go back to a earlier backup