Generally, such functionality is covered by a third-party tools or your own(ex: PowerShell script). We are using the SQLBackupAndFTP[/url]. It has a several restrictions, but in most standart cases it...

CloudBerry seems like a nice product, but adjusting it to SQL Server backups seems a bit convoluted. SQLBackupAndFTP allows you to do backups to Amazon S3 in a much simpler...

Using built-in SQL Server tools is always a good approach. However, depending on your working scenario 3rd. party tools can bring simplicity and a wider range of management tools.

For example...

Why spend time in a script to backup one or several databases when there are so many tools available.

SQL Backup and FTP lets you backup your databases, schedule backup jobs,...

You can save your backups to a mapped drive like this:

BACKUP DATABASE MyDB to DISK = 'D:\Backups\MyDB.bak' as long as you have the proper permissions on the remote server.

Even though...

SQL Server and FTP will let you schedule backups. You can also save your backups in a remote location on your LAN or FTP sites, compression and encryption is also...

You must use SSMS Express to manage your SQL Express databases and run manual backups. However, because SQL Express lacks of SQL Agent you won't be able to schedule backup...

I don't see the point of dealing with custom scripts to backup SQL Express when there are many tools available for that.

This tool http://sqlbackupandftp.com lets you create manual...

You should not spend time dealing with SQL DMO or custom scripts to backup your SQL Express databases.

Try this tool http://sqlbackupandftp.com. You can create manual or scheduled backups...

You can also try this GUI tool SQL Backup and FTP which lets you schedule your backups. It is very simple to use and it's free 🙂

Jeffrey Williams-493691 (6/17/2011)

---

AlexGreen (6/17/2011)

---

Did you consider using Jobs instead of stored procedures for your backups? You can easily create jobs using SQL Management Studio interface.

There are also third party tools...

Have you consider shrinking your database before back it up to release unused space?

You can do this with DBCC SHRINKDATABASE('DB_Name', TRUNCATEONLY)

Have you consider shrinking your database before back it up to release unused space?

You can do this with DBCC SHRINKDATABASE('DB_Name', TRUNCATEONLY)

Just note that it is just a solution for the...

SQL Server has three recovery models:

Simple: This model minimally logs most transactions.

Full: logs all transactions an retains all the transaction log records until after they're backed up.

Bulk-Logged: minimally logs bulk...

The user under which SQL Server Agent runs doesn't seem to have access to write on drive C:. However, unless you really need it, for security reasons you should avoid...