TITLE MSSQL Backup DB SET PATH="C:\Program Files\Microsoft SQL Server\80\Tools\Binn\";%PATH% SET Server_name=SERVER SET Backup_Path=D:\Backup\ SET BackupSet_Name=Automatic SET DB_List=master model msdb DB_1 DB_2 DB_3 FOR %%N IN (%DB_List%) DO ( DEL /Q %Backup_Path%MSSQL_%%N.backup DEL /Q %Backup_Path%MSSQL_%%N_backup.log osql.exe -S %Server_name% -E -Q "BACKUP DATABASE %%N TO DISK = '%Backup_Path%MSSQL_%%N.backup' WITH INIT, NOUNLOAD, NAME = N'%BackupSet_Name%', NOSKIP, NOFORMAT" -o %Backup_Path%MSSQL_%%N_backup.log ) EXIT