Howtos / Articles

Restore Microsoft SQL Database Using T-SQL

This guide will show you how to restore a Microsoft SQL database using T-SQL commands rather than using the wizards in SQL Management Studio. This has the added benefit of being able to be scripted if needed. Restoring a Microsoft SQL database: RESTORE DATABASE [database_name] FROM DISK=’c:\path\to\backup\file.bak’ Replace ‘database_name’ with the name of the database you want to restore to. Eg: RESTORE DATABASE [testing] FROM DISK=’C:\temp\testing.bak’ Sample output: Processed 312 pages for database ‘testing’, file ‘Testing’ on file 1. Processed…

Read more [...]

Restore MySQL Database on Linux

This howto guide will step you through how to restore a MySQL database from a backup file, using the MySQL client command line tools on a Linux machine. Backing up databases is important, but it is useless if you don’t know how to restore the backup. Regular restores should be done to ensure that your backup is operating correctly. Restoring a MySQL database: To restore a MySQL database from a plain text MySQL backup file, run the following command: $…

Read more [...]