PowerShell offers a lightweight and efficient solution for backing up SQL Server Express databases on local workstations without the need for full system backups.

I created a copy of the database on the remote server and generated a SQL script to TRUNCATE all the tables in the copy database as shown in Listing 1. After a quick backup of the newly cleaned ...

So, I have a shell script named "backupdb" that backs up my MySQL database. When I run the command "sudo sh ...

DTS can do that (execute process task).<br><br>Anyway, you can just write the sql script to backup the database to a file (aww hell let Enterprise Manager do it for ya by scheduling a backup job ...

By treating the backup process like, well, a backup process rather than a database rebuilding process, your SQL Server database can be recovered by a network administrator.

In part 2 of a series, On VB columnist Joe Kunk provides a Visual Basic program to generate a SQL script that clears all the data from a SQL Server database.

Script to Azure - Choose this option is you think your database is compatible with SQL Azure. It will prompt your for your Azure credentials and then run the generated script against SQL Azure.

Joey on SQL Server How To Automate Tasks in Azure SQL Database Knowing how to automate tasks in the cloud will make you a more productive DBA.