Home Forums SQL Server 2005 SQL Server Express Should I backup the transaction log? RE: Should I backup the transaction log?

  • March 12, 2014 at 7:57 am

    #1696395

    Rod at work (3/12/2014)

    When I run the batch file and redirect it's output, the first thing I see is this:

    Sqlcmd: 'GÇôE': Unexpected argument. Enter '-?' for help.

    The contents of the output.txt file are as follows:

    C:\Users\rfalanga\Documents\SQL Server Management Studio\Backup Files>sqlcmd -U Superacct -P xxxx -S .\EXPRESS –E -Q "EXEC master..sp_BackupDatabases @backupLocation='C:\SQLBackups\', @backupType='F'"

    There you go....That's what am saying(Sqlcmd: 'GÇôE': Unexpected argument). Type everything from scratch in a new txt file and run the batch file(This should eliminate unexpected argument issue). Also, remove -E switch from your syntax.