Scheduling Backup - Revision history

Alnaucler at 08:47, 17 October 2017

2017-10-17T08:47:50Z

← Older revision		Revision as of 10:47, 17 October 2017
Line 1:		Line 1:
			{{Note \| It is advised to plan when to take the backup carefully so the usage of IMSMA is not hindered and the backup is successful. If the backup is scheduled during the night then it is important to very the next day that the backup was completed successfully. }}
	{{Warning \| This script '''only''' takes backup of the database and the attachments.}}		{{Warning \| This script '''only''' takes backup of the database and the attachments.}}

	<ol>		<ol>
	<li> ~~Take a decision on how the~~ '''[[Shutdown IMSMA Server \| shutdown]]''' of the IMSMA server ~~will be implemented~~.		<li> It is strongly recommended to '''[[Shutdown IMSMA Server \| shutdown]]''' the IMSMA server before the backup is starting.
	<li>Modify the following script by replacing ''xyz'' at '''SIX''' places with the folder where you would like the backup folder to be created.		<li>Modify the following script by replacing ''xyz'' at '''SIX''' places with the folder where you would like the backup folder to be created.
	<pre>		<pre>
Line 53:		Line 54:
	[[Image:Scheduled bkp.png\|center\|800px]]		[[Image:Scheduled bkp.png\|center\|800px]]

	It is ~~advised~~ to ~~plan when to take~~ the ~~backup carefully, i.e. it is best during the night when no one is accessing and entering data into {{IMSMANG}}, as this might lead to inconsistencies~~.		It is also possible to '''[[Start-up IMSMA Server \| start-up the IMSMA Server]]''' with a bat-file.

	{{NavBox Manage Information}}		{{NavBox Manage Information}}
	[[Category:NAA]]		[[Category:NAA]]

Alnaucler at 17:38, 26 May 2017

2017-05-26T17:38:57Z

← Older revision		Revision as of 19:38, 26 May 2017
Line 55:		Line 55:
	It is advised to plan when to take the backup carefully, i.e. it is best during the night when no one is accessing and entering data into {{IMSMANG}}, as this might lead to inconsistencies.		It is advised to plan when to take the backup carefully, i.e. it is best during the night when no one is accessing and entering data into {{IMSMANG}}, as this might lead to inconsistencies.

	{{NavBox ~~How To Backup~~}}		{{NavBox Manage Information}}
	[[Category:NAA]]		[[Category:NAA]]

Alnaucler at 17:25, 20 August 2016

2016-08-20T17:25:51Z

← Older revision		Revision as of 19:25, 20 August 2016
Line 2:		Line 2:

	<ol>		<ol>
			<li> Take a decision on how the '''[[Shutdown IMSMA Server \| shutdown]]''' of the IMSMA server will be implemented.
	<li>Modify the following script by replacing ''xyz'' at '''SIX''' places with the folder where you would like the backup folder to be created.		<li>Modify the following script by replacing ''xyz'' at '''SIX''' places with the folder where you would like the backup folder to be created.
	<pre>		<pre>

Alnaucler at 07:15, 4 August 2016

2016-08-04T07:15:58Z

← Older revision		Revision as of 09:15, 4 August 2016
Line 53:		Line 53:

	It is advised to plan when to take the backup carefully, i.e. it is best during the night when no one is accessing and entering data into {{IMSMANG}}, as this might lead to inconsistencies.		It is advised to plan when to take the backup carefully, i.e. it is best during the night when no one is accessing and entering data into {{IMSMANG}}, as this might lead to inconsistencies.
	~~[[Category:NoPublic]]~~
	{{NavBox How To Backup}}		{{NavBox How To Backup}}
	[[Category:NAA]]		[[Category:NAA]]

Alnaucler at 19:26, 3 August 2016

2016-08-03T19:26:16Z

← Older revision		Revision as of 21:26, 3 August 2016
Line 1:		Line 1:
	~~{{Under construction\| }}~~
	{{Warning \| This script '''only''' takes backup of the database and the attachments.}}		{{Warning \| This script '''only''' takes backup of the database and the attachments.}}

	<ol>		<ol>
	<li>		<li>Modify the following script by replacing ''xyz'' at '''SIX''' places with the folder where you would like the backup folder to be created.
	Modify the following script:
	<pre>		<pre>
			:: IMSMA backup via bat file
	@echo off		@echo off
	@echo Backing up database. This may take awhile, do not close this window.		@echo Backing up the database. This may take awhile, do not close this window.
	:: C:\xyz ~~being~~ the ~~location~~ you ~~desire~~. ~~You~~ must have read/write access to ~~it. It has to be replaced at FOUR positions in this script~~.		:: C:\xyz is the folder where you want the backups to be created. The folder must exists before the script is started.
			:: The user starting the Task in the Windows scheduler must have read/write access to the folder.
	c:\imsmang\pgsql\bin\pg_dump -U imsma > C:\xyz\dump.sql		c:\imsmang\pgsql\bin\pg_dump -U imsma > C:\xyz\dump.sql
	@echo Creating folder		@echo Creating folder
	:: Creates a folder with the date as a timestamp, similar to the backups done in IMSMA. Then moves the dump.sql to it.		:: Creates a folder with the date as a timestamp, similar to the backups done in IMSMA. Then moves the dump.sql to it.
	set ~~foldername~~=~~Backup_~~%~~date~~:~10,4%_%~~date~~:~4,2%_%~~date~~:~7,2%_%~~time~~:~0,2%_%~~time~~:~3,2%_%~~time~~:~6,2%		for /f "delims=" %%a in ('wmic OS Get localdatetime ^\| find "."') do set dt=%%a
			set datestamp=%dt:~0,8%
			set timestamp=%dt:~8,6%
			echo datestamp: "%datestamp%"
			echo timestamp: "%timestamp%"
			set YYYY=%dt:~0,4%
			set MM=%dt:~4,2%
			set DD=%dt:~6,2%
			set HH=%dt:~8,2%
			set Min=%dt:~10,2%
			set Sec=%dt:~12,2%
			set foldername=Backup_%YYYY%_%MM%_%DD%_%HH%_%Min%_%Sec%
	mkdir c:\xyz\%foldername%		mkdir c:\xyz\%foldername%
	move c:\xyz\dump.sql c:\~~AnneLifiler~~\%foldername%\		move c:\xyz\dump.sql c:\xyz\%foldername%\
	~~cmd~~ /c ~~echo F \|~~ xcopy C:\IMSMAng\server\attachments c:\xyz\%foldername%\server\attachments /c /e /i /h /q		@echo Copying the attachments
			:: uses xcopy to copy files from server destination to backup destination.
			:: /e Copies all subdirectories, even if they are empty]
			:: /h Copies hidden/system files
			:: /q suppresses output messages
			mkdir c:\xyz\%foldername%\server\attachments
			xcopy C:\IMSMAng\server\attachments c:\xyz\%foldername%\server\attachments /e /h /q
	@echo Done.		@echo Done.
	</pre>		</pre>

Alnaucler at 15:07, 2 August 2016

2016-08-02T15:07:44Z

← Older revision		Revision as of 17:07, 2 August 2016
Line 1:		Line 1:
	{{Under construction\| }}		{{Under construction\| }}
			{{Warning \| This script '''only''' takes backup of the database and the attachments.}}

			<ol>
			<li>
	Modify the following script:		Modify the following script:
	<pre>		<pre>
Line 15:		Line 19:
	</pre>		</pre>

	Save it with name runIMSMAbackup.bat. Do ~~NOT~~ save it in the ''C:\IMSMAng'' folder.		<li>Save it with name ''runIMSMAbackup.bat''. Do '''not''' save it in the ''C:\IMSMAng'' folder.
	Schedule a task in the Operating System's Task scheduler. The following steps are done with Windows 7, follow those steps:		<li>Schedule a task in the Operating System's Task scheduler. The following steps are done with Windows 7, follow those steps:
	~~<ol>~~
	<li>Go to Control Panel → Administrative Tools → Task Scheduler</li>		<li>Go to Control Panel → Administrative Tools → Task Scheduler</li>
	[[Image:Windows Scheduler.png\|center\|600px]]		[[Image:Windows Scheduler.png\|center\|600px]]
Line 25:		Line 29:
	<li>Next, refine recurrence criteria (e.g. time of the day) and click '''Next'''.</li>		<li>Next, refine recurrence criteria (e.g. time of the day) and click '''Next'''.</li>
	<li>In the next window, select '''Start a Program''' and click '''Next'''.</li>		<li>In the next window, select '''Start a Program''' and click '''Next'''.</li>
	<li>Browser to the previously created script, e.g. C:\runIMSMAbackup.bat Click '''Next''' and then '''Finish'''.</li>		<li>Browser to the previously created script, e.g. C:\backups\runIMSMAbackup.bat Click '''Next''' and then '''Finish'''.</li>
	</ol>		</ol>

Alnaucler at 15:03, 2 August 2016

2016-08-02T15:03:47Z

@@ Line 1: / Line 1: @@
 {{Under construction| }}
-<li>Schedule a task in the Operating System's Task scheduler. The following steps are done with Windows 7, follow those steps:
+Modify the following script:
 <ol>
 <li>Go to Control Panel &rarr; Administrative Tools &rarr; Task Scheduler</li>
@@ Line 11: / Line 27: @@
 <li>Browser to the previously created script, e.g. C:\runIMSMAbackup.bat Click '''Next''' and then '''Finish'''.</li>
 </ol>
 The {{IMSMANG}} backup should now start at the specified time. <br/>

Alnaucler at 14:56, 2 August 2016

2016-08-02T14:56:17Z

← Older revision		Revision as of 16:56, 2 August 2016
Line 1:		Line 1:
	<li>Schedule a task in ~~an operating system~~'s ~~task~~ scheduler. ~~For example, using~~ Windows 7, follow those steps:		{{Under construction\| }}
			<li>Schedule a task in the Operating System's Task scheduler. The following steps are done with Windows 7, follow those steps:
	<ol>		<ol>
	<li>Go to Control Panel → Administrative Tools → Task Scheduler</li>		<li>Go to Control Panel → Administrative Tools → Task Scheduler</li>

Alnaucler: Created page with "
Schedule a task in an operating system's task scheduler. For example, using Windows 7, follow those steps:

Go to Control Panel → Administrative Tools →..."

2016-08-02T14:51:51Z

Created page with "<li>Schedule a task in an operating system's task scheduler. For example, using Windows 7, follow those steps: <ol> <li>Go to Control Panel → Administrative Tools →..."

New page

<li>Schedule a task in an operating system's task scheduler. For example, using Windows 7, follow those steps:
<ol>
<li>Go to Control Panel → Administrative Tools → Task Scheduler</li>
[[Image:Windows Scheduler.png|center|600px]]
<li>In the Task Scheduler interface, click on '''Create Basic Task...'''</li>
<li>In the Create Basic Task Wizard, provide a name, e.g. '''IMSMA Backup''' and an optional description. Click '''Next'''.</li>
<li>In the next window, specify the required recurrence (daily, weekly, etc.) and click '''Next'''.</li>
<li>Next, refine recurrence criteria (e.g. time of the day) and click '''Next'''.</li>
<li>In the next window, select '''Start a Program''' and click '''Next'''.</li>
<li>Browser to the previously created script, e.g. C:\runIMSMAbackup.bat Click '''Next''' and then '''Finish'''.</li>
</ol>
</li>

The {{IMSMANG}} backup should now start at the specified time. <br/>
[[Image:Scheduled bkp.png|center|800px]]

It is advised to plan when to take the backup carefully, i.e. it is best during the night when no one is accessing and entering data into {{IMSMANG}}, as this might lead to inconsistencies.
[[Category:NoPublic]]
{{NavBox How To Backup}}
[[Category:NAA]]