How to Restore a SQL Database From a .MDF File. Computer database software such as Microsoft's SQL Server benefits all types of businesses, as it makes recordkeeping fast, flexible and secure.

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 ...

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 ...

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.

If a web-based GUI is better suited to your admin skills, Jack Wallen wants to show you how to back up and restore your MySQL/MariaDB databases with one of the easiest tools on the market.