Automated backup in SQL Server Express

Asked

Viewed 457 times

1

In my current scenario I have a service of Windows which rotates in the background which at a specified time by me rotates a batch that makes the backup and saved in the Dropbox. But what happens is that not always the Dropbox is allowed to access the internet due to user permissions.

To have an exit I search on the internet and found this site Free Sql Server Express Backup Utility, which is free, and a paid tool, which is the Sql Backup and FTP....

My question is this: did anyone use these software? Are they trustworthy? Is there any alternative I can use?

*Only at the same information level, I want to use a utility that backs up and play directly in my FTP, for FTP no user permission required*.

sql-server backup

  • Afterlife of that question in the Soen also.

  • A backup suggestion: do it normally on your PC and schedule a routine to transfer the backup to Dropbox. This routine can be a bat that performs FTP or even a Vbscript that reads the latest files to transfer via FTP. I’ll send you an example if you need.

  • 1

    I’ve used the SQL Backup and FTP and it works well. It has the limitation of two databases, but for simple and sufficient uses. If you want a code solution, you can always use Powershell and module sqlps which provides a command to do backup.

  • @ricarela. I can’t use the expensive Dropbox right now. The user is not an administrator and therefore bar the internet access of Dropbox, IE, the backup file is not sent and with this I have no control, and this is what I want to avoid at this time. There are many clients, and if for example 20 are not sending I will not have control over it. =(

  • @Omni guy, so I think I’ll use it even. I don’t know if the free one has FTP support, but I’ll try! Thanks for the tip!

2 answers

0


I used both. These are great automated backup tools from Sqlserver. But I chose to use Sqlbackupandftp, because it is easier to move and have more resources.

With license purchase more options can be purchased, but free already caters to almost every case where an automated backup is needed.

There is no windows dependency, so if windows restart, the tool comes back alone without human interference.

0

I am an active backup user, so I insist on this post. I always work with at least 2 environments: dev and Prod (also for database). I just bring to production what’s cool in dev. I keep backups of these environments and more carefully for dev (incredible as it may seem), because that’s where I most move. Back up! And do not leave in a single place, either in the same place where objects are being "backed up". Leave in one or two units of the network. Organize an external disk on another station and back up on it. Get an older micro just to receive backups... AND TEST-OS! Do disaster simulations constantly.

Browser other questions tagged sql-server backup

You are not signed in. Login or sign up in order to post.