ERASEFILES causes backup error

beachldy · Joined: 14 Sep 2005 Posts: 10

This is the backup script and it fails since adding the ERASEFILES items.

EXEC master..sqlbackup N'-SQL "BACKUP DATABASES [MYDB] TO DISK = ''F:\MSSQL\BACKUP\<AUTO>''
WITH NAME = ''<AUTO>'', DESCRIPTION = ''<AUTO>'', COMPRESSION = 3 , ERASEFILES = 3, FILEOPTIONS = 1, ERASEFILES_REMOTE = 3",@exitcode OUTPUT, @sqlerrorcode OUTPUT

I've tried omitting the ERASEFILES_REMOTE, omitting the ERASEFILES, omitting the FILEOPTIONS, and none of these work.

ChrisAVWood · Posted: Thu Jun 28, 2012 2:36 pm Post subject:

You are missing a ' at the end.

It should read ERASEFILES_REMOTE = 3'"

There was the ' before -SQL "BACKUP that you have no ending ' for.

Chris
_________________
English DBA living in CANADA

beachldy · Joined: 14 Sep 2005 Posts: 10

THANK YOU! I thought I counted all the quotes....but missed one.

	All times are GMT + 1 Hour
Page 1 of 1