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...
Hi,
i'm having a similar issue. All of a sudden one of my databases is not clearing any old log files (backup logs every 30mins). The script is exactly the same as for the other DB's but this just does not seem to be clearing the files anymore. I've tried adding the FILEOPTIONS = 1, 2, and 3 and none of them work!
Any ideas as to why this may be happening: DECLARE @exitcode int
DECLARE @sqlerrorcode int
exec master..sqlbackup N'-sql "BACKUP LOG [<Database>]
TO DISK = ''F:\Backups\Shipping\LOG__<Database>_<DATETIME yyyymmdd_hhnnss>.sqb''
WITH NAME = ''<AUTO>'', DESCRIPTION = ''<AUTO>'', ERASEFILES = 4, FILEOPTIONS = 1,
COPYTO = ''\\BackupServer\LogBackups'', COMPRESSION = 1, THREADS = 1"',
@exitcode OUTPUT, @sqlerrorcode OUTPUT
Can anyone help? / comments
Hi,
i'm having a similar issue. All of a sudden one of my databases is not clearing any old log files (backup logs every 30mins). The script is exactly the same as for the other DB's but this just ...
ok, i may be getting somewhere now......or possibly not!
I have since found out that one of our xml imports fails everynight due to it trying to import the file whilst its still downloading and therefore not running the sp_xml_removedocument.
I've been monitoring the VAS every minute and when this failed on tuesday it had zapped the largest available block and not released it. So, i monitored it last night and nothing, no reduction in the total or the MAX available........and it actually failed twice last night :?
Could this just be coincidence? I'm going to continue to monitor it over the next few days and we'll put some error handling in place to fix. I don't want to put the fix in just yet as i want to see if it breaks everything again.
thoughts...? / comments
ok, i may be getting somewhere now......or possibly not!
I have since found out that one of our xml imports fails everynight due to it trying to import the file whilst its still downloading and the...
No, don't use CLR's. Tried them once for a generic auditing system and got out of memory errors.
It happend again earlier this week, here are the stats when it happened:
1. (16/02/09 15:23) Free 4096 107937792 1122269 237 265977856
2. (23/02/09 13:30) Free 4096 10682368 169200 285 48222208
3. (24/02/09 09:08) Free 4096 786432 98684 334 32960512
4. (24/02/09 09:45) Free 4096 149946368 1554994 193 300113920
these show the memory when i first took it (1), the day before (2) (was slowly dropping over time), the memory captured whilst 100% CPU (3) and memory after restarting the services (4).
I now believe it to be an issue with VAS. I've defragged the c:\ and up'd the pagefile to 6GB (there is a second page file on another drive which is set to 16GB). Not sure if this is going to help at all but trying everything i can............ / comments
No, don't use CLR's. Tried them once for a generic auditing system and got out of memory errors.
It happend again earlier this week, here are the stats when it happened:
1. (16/02/09 15:23) Free 40...
AWE is enabled and the boot.ini file does not include the /3GB but it does include the /pae switch.... / comments
AWE is enabled and the boot.ini file does not include the /3GB but it does include the /pae switch....
hmmm, been through all procs that use the sp_xml_preparedocument and they all have a corresponding sp_xml_removedocument.
I've been checking sqbmemory since yesterday and the free total is going down.....
Time Ran Type Minimum Maximum Average Blk count Total Total(MB)
16/02/2009 15:23 Free 4096 107937792 1122269 237 265977856 253.66MB
16/02/2009 15:31 Free 4096 107937792 1048021 251 262549504 250.39MB
17/02/2009 12:47 Free 4096 47185920 497290 247 122830848 117.14MB / comments
hmmm, been through all procs that use the sp_xml_preparedocument and they all have a corresponding sp_xml_removedocument.
I've been checking sqbmemory since yesterday and the free total is going do...
Thanks for the info chris.
we're currently on SP2 CU9 but i'm going to investigate both xml and OA issues you mentioned as we use both within our systems. / comments
Thanks for the info chris.
we're currently on SP2 CU9 but i'm going to investigate both xml and OA issues you mentioned as we use both within our systems.