Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase «««123

Should I backup the transaction log? Expand / Collapse
Posted Wednesday, March 12, 2014 7:57 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: 2 days ago @ 2:00 PM
Points: 363, Visits: 1,866
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