Hello everyone,
I am trying to do a backup by using the SQL Server Agent Job utility in SQL Server 2000.
The problem is that I get the following error :
(Error 170) The label 'c' has already been declared. Label names must be unique within a query batch or stored procedure. [SQLSTATE 42000] (Error 132) The label 'c' has already been declared. Label names must be unique within a query batch or stored procedure. [SQLSTATE 42000] (Error 132). The step failed.
Here is the line where I ge the code :
osql -E -dmaster -Q "BACKUP DATABASE proddb TO DISK = 'c:\temp\ProdDB.bak' WITH INIT"
Any help is greatly appreciated.
Sergio