Activity overview
Latest activity by swirl80
Configure for user-defined datatypes
A system developed by a third party has a char udt (udtYesNo) used on a number of columns which will contain a Y or N.
Is it possible to configure data generator to say that any column which uses t...
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...
Log shipping flushing the buffer...??
Something i've noticed recently is that whenever we restore our log files (every 30mins) to what is our Live Reports server, it seems to flush the buffer and procedural cache. There's nothing in th...
MSQL_XP lastwaittype in sysprocesses when doing log restore.
I've been trying to temporarily move our reports server to another box and when i go live with it the log restores get slower and slower. On investigation i've noticed that when the restore job sta...
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...
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...
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...