MS-SQL Databases

These are sets of mssql scripts that i employ to generate the tables for a new database for accounting records.
This provides the script for running backups for your MS-SQL databases to an external drive. Having an external drive helps to protect your data should your current system crash.

GO
BACKUP DATABASE [DATABASENAME]
TO DISK = 'F:\MSSQL BACKUPS\DATABASENAME.bak'
WITH FORMAT,
MEDIANAME = 'Z_SQLServerBackups',
NAME = 'Full Backup of DATABASENAME';
GO
Below are a set of scripts that helps to generate backups of your MS-SQL databases.

Leave a Reply


*