Comments
Sort by recent activity
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.
was there ever a resolution to this as we're getting the same issue.....? / comments
was there ever a resolution to this as we're getting the same issue.....?
the unfortunate thing is that i cannot stop sqlbackup as this is our live production server which is a 24/7 box and we require these log backups for both DR and our reporting server. / comments
the unfortunate thing is that i cannot stop sqlbackup as this is our live production server which is a 24/7 box and we require these log backups for both DR and our reporting server.
Is there a way to do this based on the name of a user defined data type as opposed to a column name?
For example instead of looking for columns *YesNo, is it possible to set this to look at all columns of datatype "udtYesNo"?
I can use the example provided by Brian for this particular column type but there are several other udt's but the naming of the column doesn't always follow standards... / comments
Is there a way to do this based on the name of a user defined data type as opposed to a column name?
For example instead of looking for columns *YesNo, is it possible to set this to look at all col...
Thanks Brian, that worked.
One thing to note, I could only get this to work on anything new I added to the schema (ie, I created a test table with a xxxxYesNo column), anything current seemed to ignore it. I tried refreshing the schema and closing / reloading SDG but still didn't pick it up.
In the end I created a new project using the same database and this then picked it up..... / comments
Thanks Brian, that worked.
One thing to note, I could only get this to work on anything new I added to the schema (ie, I created a test table with a xxxxYesNo column), anything current seemed to ig...