Category Archives: Uncategorized

Backup SQL Server on the network

SQLBackupAndFTP creates standard *.bak files when it runs locally on the same computer where SQL Server is. For remote SQL Server computer backups SQLBackupAndFTP creates backup script files (*.sql). Whenever possible, you should always opt for *.bak backups against *.sql backup files.

Here we will show you how to backup a SQL Server on the network to the standard *.bak file even when SQLBackupAndFTP runs on a different computer from where the SQL Server is. The main requirement, in this case, is that both SQL server and SQLBackupAndFTP have access to the same shared network folder.

Continue reading Backup SQL Server on the network

How to Make SugarCRM Backup

sugarcrm logoToday over 50,000  companies use SugarCRM globally for their customer management, sales automation, and other CRM needs. SugarCRM can be installed as an on-premise solution or as a SaaS (Software-as-a-Service) solution. Managing SugarCRM means that you have to work with a huge flow of information that is stored in large databases. Clearly, when working with databases one has to take care of their security, and that implies making backups on a regular basis. Now let’s check how to use SQLBackupAndFTP for regular SugarCRM backups.
Continue reading How to Make SugarCRM Backup

How to set up SQL Server Email Job Notifications

As a DBA, automating your various jobs on SQL Server – taking backups, truncating logs, updating statistics, etc – is a good idea because it makes sure you don’t have to depend on your feeble memory for these important tasks. And it leaves you free for more vital tasks such as sleeping and bingeing on whatever new Netflix series is out. But to make sure your automated tasks are still running, you need a good notification method, and it should also be automated. And foolproof. So how do you do this? Continue reading How to set up SQL Server Email Job Notifications

Top 2014 News of Database – the fall of Microsoft Azure SQL Prices

Microsoft has not ceased in its bid to attract more and more enterprise customers onto their Azure cloud computing system, with all their databases in tow of course. This came shortly after the company disclosed to the public a preview of Azure’s enhanced security auditing feature. With the fall, the company announced its intention to change its cloud-based computing and database offering to make it more affordable. Continue reading Top 2014 News of Database – the fall of Microsoft Azure SQL Prices

Learn the Ways to Recover MySQL Root Password without Restarting

Recover MySQL Root Password without Restarting
When you are using the master production server and there appears a need to recover the root password in MySQL, you cannot restart at once. The remote database experts suggest a few ways by which you can come out of this situation. 

Click to read the article and to find out how to resolve this!

Continue reading Learn the Ways to Recover MySQL Root Password without Restarting