Sql Backup And FTP

Welcome Guest Search | Active Topics | Log In | Register
New Topic Post Reply
Buckup while databases are in use Options · View
Previous Topic · Next Topic
Guest
#1 Posted : Tuesday, January 10, 2012 7:28:15 AM Quote
Rank: Guest

Groups:

Joined: 8/10/2009
Posts: 733
Hi, I just have a short question about this automatic backup to a local folder.
My costomers are working all day and night. I don't have the chance to stop the MSSQL servers services.
Does it matter when Sql Backup And FTP does a dump while are users working? Does that crash the database,
or are the reads and writes in "waiting line" while generating the dump.
Sorry for that stupid question I'm not that good in doing these things....

Thanks Marc
Back to top
  |
ruslan
#2 Posted : Tuesday, January 10, 2012 9:26:14 AM Quote
Rank: Administration

Groups: Administrators

Joined: 8/10/2009
Posts: 368
The native backup is a light process that is designed not to interrupt your access to SQL server. The compression that follows utilizes CPU, so server performance can be affected a bit.
The script/remote backup is a different story, but we don't recommend using it anyway. So, as long as you are running SQLBackupAndFTP on the same computer where SQL server is and your processor is not overloaded - you should not notice the backups.
Back to top
 Report Abusive | Report SPAM
Quick Reply Show Quick Reply
New Topic Post Reply
Forum Jump  
You can post new topics in this forum.
You can 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.