Activity overview
Latest activity by epetro
We use the erasefiles_atstart option with a value of 40h.
This assumes we are running a daily backup (every 24 hours) and wish to always have at least 1 complete backup available on disk.
If you wish to essentially overwrite the previous backup you can simply set this value to less than your expected backup schedule.
So if you are running a daily backup, try
erasefiles_atstart = 1h
/ comments
We use the erasefiles_atstart option with a value of 40h.
This assumes we are running a daily backup (every 24 hours) and wish to always have at least 1 complete backup available on disk.
If you wi...
I think you will get more assistance if you provide the code you are currently running.
You can adjust database/server names for confidentiality.
I know we had an issue with this some time back, but in recent versions no problems.
Be sure to pay attention to any TAPE backup that may be picking up(locking) the previously created file.
You should be able to rename the file as a test to see if it is locked. / comments
I think you will get more assistance if you provide the code you are currently running.
You can adjust database/server names for confidentiality.
I know we had an issue with this some time back, bu...
I contacted support for this issue and we were unable to rectify the issue. I don't believe the underlying issue was caused by Redgate software. I will be reviewing the cause for the memory 'explosion'.
We have scheduled an emergency server reboot this evening.
I did learn that 1 process =SQBCoreService.exe is expected per SQL instance on the box. We only have a single instance, so 4 was abnormal, but no investigation was possible.
Support also shared this ...unfortunately for my scenario it requires that SQL Backup Agent service be operational.
Thanks for your call - to try and get the crash-log, do the following:
USE master
GO
EXECUTE master..sqbutility 9997
GO
/ comments
I contacted support for this issue and we were unable to rectify the issue. I don't believe the underlying issue was caused by Redgate software. I will be reviewing the cause for the memory 'expl...
Backup stuck in KILLED/ROLLBACK
Do failed backups require rollback?
Are multiple instances of process "SQBCoreService.exe " normal?
One of our production servers was experiencing memory pressure which required intervention. The ...
I agree that your suggestion has potential to be incorporated with the Hyperbac software. However, I don't see the possibiity to process all 12TB of production data nightly (maybe not your suggestion) from our testing environments.
A weekly or monthly DBCC would be a good addition to our process though. / comments
I agree that your suggestion has potential to be incorporated with the Hyperbac software. However, I don't see the possibiity to process all 12TB of production data nightly (maybe not your suggest...
<THIS POST RESERVED FOR FINAL SOLUTION>
update pending...
update still pending...(hotter fires)4/5/2012 / comments
<THIS POST RESERVED FOR FINAL SOLUTION>
update pending...
update still pending...(hotter fires)4/5/2012
Automating RESTORE VERIFYONLY as seperate SQL Agent Job
I have been asked to begin verifying backups outside of our typical maintenance tasks.
I am starting this thread to track some ideas and progress relating to :
1. Capturing the latest full backup f...
SQL Storage Compress is a tool available from Redgate which lowers the disk footprint of a database (different from availablity in 2008 Ent). In our case, by an average of 82%.
I have some databases which require 730 GB in native form, but under this tool (and the preferred extensions mdfx, ndfx) will fit on 155GB.
The tool requires a background service(HyperBacSrv.exe) be installed between sqlservr.exe and the OS. Read and write operations are intercepted and translated for the compressed file using index files(extensions .index, .index2)
I don't want to trust it yet in production, but our QA and TEST departments are reporting no issues. The GUI estimates I can save over 3TB on our QA server (which will likely be used by additional restores [image] )
Here is a link to the main page. SQL STORAGE COMPRESS / comments
SQL Storage Compress is a tool available from Redgate which lowers the disk footprint of a database (different from availablity in 2008 Ent). In our case, by an average of 82%.
I have some databas...
My research is really 2 fold.
We are migrating production databases to a new SAN(and your note of UNPRESENT may yield assistance) and I am trying to convert a series of databases to SQL Storage Compress with minimal downtime. If you are not familiar with SQL Storage Compress, I recommend looking at it for TEST and QA environments with large databases.
I think I will code for using a native DIFF backup. In production we run nightly FULLs and 15 min logs. If the DIFF is time consuming, I will revisit my options.
Thanks for the chatter Chris. / comments
My research is really 2 fold.
We are migrating production databases to a new SAN(and your note of UNPRESENT may yield assistance) and I am trying to convert a series of databases to SQL Storage Com...
This database is the only one that will migrate. The others need to remain online.
Due to the nature of the connection remaining open, I still have the option of running a native DIFF, but I prefer your utility.
I have a number of these projects to complete and would like to automate as much as possible. Previous solutions required detach/rename/reattach/FULLBackup/restore. This is too time consuming.
If I can code a solution from one query window, that would be preferred. / comments
This database is the only one that will migrate. The others need to remain online.
Due to the nature of the connection remaining open, I still have the option of running a native DIFF, but I prefer...