MySql Backup

Welcome Guest Search | Active Topics | Log In | Register
Are tables locked during backup or can applications continue to write to tables? Options · View
Transistor
#1 Posted : Tuesday, February 8, 2011 10:38:54 AM
Rank: Newbie

Groups: Registered

Joined: 2/8/2011
Posts: 2
Location: Ireland
Hi.
I hope to use SQLBackupAndFTP on a PC controlling an industrial process. I am concerned that backup will lock the DB/tables for periods of time - short or long? - and that the machine application will try to write to the DB, timeout and error or crash.

Can you comment on this? Does SQLBackupAndFTP lock the tables during backup? If not, how are changes during backup handled?

Many thanks.
ruslan
#2 Posted : Tuesday, February 8, 2011 10:50:22 AM
Rank: Administration

Groups: Administrators, Registered

Joined: 8/10/2009
Posts: 437
Since SQLBackupAndFTP just runs BACKUP DATABASE command, take it from MSDN (http://msdn.microsoft.com/en-us/library/ms175477.aspx):
Quote:
Performing a backup operation has minimal effect on transactions that are running; therefore, backup operations can be run during regular operations. During a backup operation, SQL Server copies the data directly from the database files to the backup devices. The data is not changed, and transactions that are running during the backup are never delayed. Therefore, you can perform a SQL Server backup with minimal effect on production workloads.

Transistor
#3 Posted : Tuesday, February 8, 2011 12:26:29 PM
Rank: Newbie

Groups: Registered

Joined: 2/8/2011
Posts: 2
Location: Ireland
Thanks for the quick response. We'll give it a try. (Paid version of course!)
Alexander Omelchenko
#4 Posted : Friday, July 29, 2016 3:24:33 AM
Rank: Advanced Member

Groups: Administrators, Registered

Joined: 12/23/2015
Posts: 457
Great! Thanks!
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You can create polls in this forum.
You can vote in polls in this forum.

©Pranas.NET Sql Server Backup MySql Backup Free SQl Backup SQL Backup Master Employee monitoring software Web Scraping Azure SQL Database Backups ergonotes.com