Loop through the databases one by one SELECT Loop = min ( ID ) FROM DBs Filter out databases which do not need to backed up IF backupType = 'F' BEGIN DELETE DBs where DBNAME IN ( 'tempdb', 'Northwind', 'pubs', 'AdventureWorks' ) END ELSE IF backupType = 'D' BEGIN DELETE DBs where DBNAME IN ( 'tempdb', 'Northwind', 'pubs', 'master', 'AdventureWorks' ) END ELSE IF backupType = 'L' BEGIN DELETE DBs where DBNAME IN ( 'tempdb', 'Northwind', 'pubs', 'master', 'AdventureWorks' ) END ELSE BEGIN RETURN END - Declare variables DECLARE BackupName varchar ( 100 ) DECLARE BackupFile varchar ( 100 ) DECLARE DBNAME varchar ( 300 ) DECLARE sqlCommand NVARCHAR ( 1000 ) DECLARE dateTime NVARCHAR ( 20 ) DECLARE Loop int databaseName sysname = null, backupType CHAR ( 1 ), backupLocation nvarchar ( 200 ) AS SET NOCOUNT ON DECLARE DBs TABLE (ĭBNAME nvarchar ( 500 ) ) - Pick out only databases which are online in case ALL databases are chosen to be backed up - If specific database is chosen to be backed up only pick that out from INSERT INTO DBs ( DBNAME ) SELECT Name FROM master.
= - Author: Microsoft - Create date: - Description: Backup Databases for SQLExpress - Parameter1: databaseName - Parameter2: backupType F=full, D=differential, L=log - Parameter3: backup file location - = CREATE PROCEDURE.
#Sql 2012 express backup all databases code
This code released under the terms of the - // Microsoft Public License (MS-PL.
0 kommentar(er)
