Comments
Sort by recent activity
thanks for the info, suppose that does make sense i just wanted to confirm that there wasn't anything wrong with the server as i've recently built and deployed it like without noticing this!
I've tested on the old server we took out of production last week and got the same results. / comments
thanks for the info, suppose that does make sense i just wanted to confirm that there wasn't anything wrong with the server as i've recently built and deployed it like without noticing this!
I've t...
was there ever an answer for this....? I'm getting the same answer even though all connections to the DB being restored are killed as part of the restore process... / comments
was there ever an answer for this....? I'm getting the same answer even though all connections to the DB being restored are killed as part of the restore process...
can anyone please tell me why this does not work:
EXEC master..sqlbackup N'-SQL "BACKUP DATABASE [DBName] TO DISK = ''d:\backup\<AUTO>.sqb''
WITH COPYTO= ''\\backupsrv\Servername'',
NAME = ''Database (DBName) Full'',
ERASEFILES = 3,
FILEOPTIONS = 1,
ERASEFILES_REMOTE = 3
" -E '
I get the error:
SQL Backup v5.2.0.2825
Syntax error: 'ERASEFILES_REMOTE' after ','
If i remove ERASEFILES_REMOTE then the script will run BUT it doesn't remove the relevant files from either the local folder OR the network.
Also, does anyone have a list of what the options of FILEOPTIONS actually are? I know they're from 1-7 but can't find anything that tells me what each value represents....
Running v5.2 on sql server 2005 (Win 2k3 server)
many thanks / comments
can anyone please tell me why this does not work:
EXEC master..sqlbackup N'-SQL "BACKUP DATABASE [DBName] TO DISK = ''d:\backup\<AUTO>.sqb''
WITH COPYTO= ''\\backupsrv\Servername...
just found the info that say's ERASEFILES_REMOTE was new in v5.3 :shock: so now installed v5.4 but i'm still getting the same error...
This still doesn't explain my issue with the erasefiles = 3 not removing any backups for that DB older than 3 days. I've even tried it at 3h but still no luck....
any ideas?? / comments
just found the info that say's ERASEFILES_REMOTE was new in v5.3 :shock: so now installed v5.4 but i'm still getting the same error...
This still doesn't explain my issue with the erasefiles = 3 n...