I’m using the free version of SQL Server Management Studio so I have to use CMD to call the SQL scripts. The official page gives an example of the CMD syntax used to call the “DatabaseBackup” script, as follows:
Create cmd files to execute the stored procedures; for example: sqlcmd
-E -S .SQLEXPRESS -d master -Q “EXECUTE dbo.DatabaseBackup @Databases = ‘USER_DATABASES’, @Directory = N’C:Backup’, @BackupType = ‘FULL'” -b -o C:LogDatabaseBackup.txt
I got that to work, but I can’t get it to work for the “DatabaseIntegrityCheck” or the “IndexOptimize” scripts.
I guess I don’t know the syntax. I tried using the example code and just replacing the script name, but that didn’t work.
Can anyone help me?