Activity overview
Latest activity by JHammond
I do not have a script to drop all users before restore as I feel the restore itself should run at a lower precedence than the users queries and speed. ie a users query should run smooth with no interruption and no speed loss even if a log restore starts. If it fails it shouldn't move the file to the processed folder but continue residing in the current folder until next execution. / comments
I do not have a script to drop all users before restore as I feel the restore itself should run at a lower precedence than the users queries and speed. ie a users query should run smooth with no in...
I have scheduler currently setup to rerun the last job as many times possible until success. I have yet to have an issue with a user telling me he is blocked during a restore, but wanted to verify this wasn't a possibility. / comments
I have scheduler currently setup to rerun the last job as many times possible until success. I have yet to have an issue with a user telling me he is blocked during a restore, but wanted to verify ...
Log Shipping as a reporting database.
I had an issue with log shipping with SQL Backup v. 4.0. this turned out to be my maintenance script for nightly backup and shrink of the log files. Duh changes the LSN number sql guy...But this le...
EraseFiles=3 not deleting.
I am having an issue in the newest version of sqlbackup where from a script the erasefiles=3 setting will not delete files. I know there is a patch for previous versions is it available for this as...