Support Forums - View Thread

View Thread

The following is the text of the current message along with any replies.

Messages 1 to 5 of 5 total

Will a backup run whilst other users are on?

Mon, Apr 27 2015 7:02 AM	Permanent Link
Peter Evans	Subject : Will a backup run whilst other users are on? Here is the statement that does what I want : /* Backup the specified database to the specified store as a single backup file. / / The store must have already been created using the CREATE STORE statement. */ BACKUP DATABASE MyDatabase AS "MyDatabase-Backup-2015_04_27B" TO STORE "Backups" INCLUDE CATALOG I ran this successfully when there were no other users on the system. What happens if some users are accessing the database? Does it wait and then run? Regards, Peter Evans
Mon, Apr 27 2015 8:16 AM	Permanent Link
Raul Team Elevate	On 4/27/2015 7:02 AM, Peter Evans wrote: > Subject : Will a backup run whilst other users are on? > What happens if some users are accessing the database? > Does it wait and then run? General answer is that it will run even with other users. Backup does require a read lock on the database so while its running nobody can write to the tables - usually this is very quick and not a problem for most applications but it really depends on your application and its usage of tables. Raul
Mon, Apr 27 2015 9:09 AM	Permanent Link
Roy Lambert NLH Associates Team Elevate	Peter As Raul says and if you can't afford to wait for a back use PUBLISH. This can be picked up by a second instance and used to make sure you always have two instances of the database in sync for "hop swap" purposes or can simply be stored together with a good base point for restore just in case its ever needed. Roy Lambert
Mon, Apr 27 2015 8:16 PM	Permanent Link
Peter Evans	Thank you Raul and Roy, > > General answer is that it will run even with other users. Backup does > require a read lock on the database so while its running nobody can > write to the tables - usually this is very quick and not a problem for > most applications but it really depends on your application and its > usage of tables. > Your answers were what I hoped for. This methodology will meet my requirements. Regards, Peter Evans
Mon, Apr 27 2015 8:20 PM	Permanent Link
Peter Evans	Thank you Raul and Roy, > > General answer is that it will run even with other users. Backup does > require a read lock on the database so while its running nobody can > write to the tables - usually this is very quick and not a problem for > most applications but it really depends on your application and its > usage of tables. > Your answers were what I hoped for. This methodology will meet my requirements. Regards, Peter Evans