Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase «««123

Should I backup the transaction log? Expand / Collapse
Author
Message
Posted Wednesday, March 12, 2014 7:57 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Yesterday @ 2:01 PM
Points: 260, Visits: 1,029
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: 'ΓÇô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: 'ΓÇô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.
Post #1550244
« Prev Topic | Next Topic »

Add to briefcase «««123

Permissions Expand / Collapse