Comments
Sort by recent activity
Thanks for the reply, that feature matrix was awesome
Too bad the Standard edition doesn't do format, but I'll start conversation with my manager
I had old SQL Prompt license (4.x) and still barely works, but would prefer newer version if company allows it / comments
Thanks for the reply, that feature matrix was awesome
Too bad the Standard edition doesn't do format, but I'll start conversation with my manager
I had old SQL Prompt license (4.x) and still barely...
I have always done the manual (using SQBServerSetup.exe) install on each of my cluster nodes. Feels safer that way without permission issues
This is for both 2005 SP3 and 2008 R2 clusters / comments
I have always done the manual (using SQBServerSetup.exe) install on each of my cluster nodes. Feels safer that way without permission issues
This is for both 2005 SP3 and 2008 R2 clusters
Interesting
I just did a SQL 2008 R2 on a Windows 2008 R2 install last week also, CLUSTER
Ran the Setup.exe locally for both clusters
Had to add the DOMAIN\account into [sysadmin] because I forgot, but that's the only issue I had, everything went smoothly, no settings changed / comments
Interesting
I just did a SQL 2008 R2 on a Windows 2008 R2 install last week also, CLUSTER
Ran the Setup.exe locally for both clusters
Had to add the DOMAIN\account into [sysadmin] because I forgot,...
This is what I use for Backup summary
Even better if you run this across the Central Management Servers (CMS) to grab a summary of ALL the servers in CMS EXEC master..sqbdata '
SELECT dbname
,backup_start, backup_end
,backup_type
,duration AS [seconds]
,BH.size/1000 AS [Size_KB]
,BH.compressed_size/1000 AS [CompressedSize_KB]
,speed,encryption
,compression_ratio
,compression_level
,BF.name AS filename
--,logfilename
--,convert(nvarchar(19),backup_start,100) as Backup_Start
,DATEPART(hh,backup_start) AS [hour]
FROM backuphistory BH
INNER JOIN backupfiles BF ON BH.id = BF.backup_id
WHERE 1=1
AND DATEDIFF(d,backup_start, getdate()) = 1 -- less than X days old
AND backup_type = ''L''
AND dbname = ''XXXX''
ORDER BY BH.id DESC
'
/ comments
This is what I use for Backup summary
Even better if you run this across the Central Management Servers (CMS) to grab a summary of ALL the servers in CMSEXEC master..sqbdata '
SELECT dbname
,b...
jchertudi wrote:
Thanks for the response Peter! I had thought this would be the case and tried to do such a restore, but got an error message.
Also, the SQB UI doesn't seem to support such a restore, when I select a transaction log, it only selects files back to the prior Full backup. Do these sort of restores need to be run via SSMS??
Yes, you need to do this in scripts, not via UI
Restore last sunday's FULL backup, in NONRECOVERY mode
Restore all remaining LOG backups, all in NONRECOVERY as well
Monday, Tuesday, Wed, Thurs, Friday
then restore Saturday's LOG backup
RESTORE FROM DISK = '....' WITH STOPAT = 'Saturday 1 pm'
RESTORE LOG { database_name }
< file_or_filegroup_or_pages > [ ,...n ]
[ FROM { DISK } = { 'physical_backup_device_name' | 'file_search_pattern' } ] [ ,...n ]
[ WITH
....
[ [ , ] { STOPAT = { 'date_time' | @date_time_var } ]
| STOPATMARK = { 'mark_name' | 'lsn:lsn_number' }
[ AFTER 'datetime' ]
| STOPBEFOREMARK = { 'mark_name' | 'lsn:lsn_number' }
[ AFTER 'datetime']
} ]
/ comments
jchertudi wrote:
Thanks for the response Peter! I had thought this would be the case and tried to do such a restore, but got an error message.
Also, the SQB UI doesn't seem to support such a res...
Anu Deshpande wrote:
Many thanks for detailed steps I replicated the scenario at my end.
I have logged this as a feature request in our internal tracking system whose tracking id is SB-4534.
I will update you as soon as this functionality is incorporated.
Kindly let us know if you have any other issues or questions regarding the product,I'll like to help.
I would classify as a bug rather than a feature :P
but thanks for accommodating me, and hope to see it in 6.5 (or 7.0) / comments
Anu Deshpande wrote:
Many thanks for detailed steps I replicated the scenario at my end.
I have logged this as a feature request in our internal tracking system whose tracking id is SB-4534.
I w...
Anu
I have SQL Backup 6.4.0.56 as Client
and on all the servers as well
I have always had this issue for OFFLINE databases since 6.3 though
FYI: I got the screen from double-clicking on a scheduled Backup job
I just did it again
- intentionally take MDW db offline
- refresh in SQL Backup
1. I see MDW greyed out when I do "manual backup" = GOOD
2. I double click on my current FULL/DIFF jobs, I see MDW in "Orange" = BAD
so I think that's only the place it happens, so I think it's still a bug unfortunately [image] Hopefully gone in 6.5 version / comments
Anu
I have SQL Backup 6.4.0.56 as Client
and on all the servers as well
I have always had this issue for OFFLINE databases since 6.3 though
FYI: I got the screen from double-clicking on a scheduled...
I almost never use the GUI to find backup history
I write queries to query MSDB database, and collect information I need (file path, duration, sizes, db, date started & ended.....)
To query with RedGate commands, this is what I use
/*
master..sqbdata 'SELECT * FROM backuphistory'
master..sqbdata 'SELECT * FROM backupfiles '
*/
master..sqbdata '
SELECT dbname
,backup_start, backup_end
,backup_type
,encryption
,compression_ratio
,compression_level
,duration AS [seconds]
,BH.size
,BH.compressed_size
,speed
,BF.name AS filename
,logfilename
FROM backuphistory BH
INNER JOIN backupfiles BF ON BH.id = BF.backup_id
WHERE 1=1
AND DATEDIFF(d,backup_start, getdate()) < 2 -- less than X days old
ORDER BY BH.id DESC
'
/ comments
I almost never use the GUI to find backup history
I write queries to query MSDB database, and collect information I need (file path, duration, sizes, db, date started & ended.....)
To query with Re...
This has been corrected in SQL Backup 6.4
I just upgraded all my production from 6.3 to 6.4 and Registry Replication has re-surfaced in the SQLBackupAgent
HOWEVER............ the error continues non-stop UNTIL a restart of SQLBackupAgent (take offline, bring online), keep that in mind!!!
I had to do this for 2 * 4 clusters we have [image]
Cluster service failed to save the registry key Software\Red Gate\SQL Backup\BackupSettingsGlobal\DBXXXX01 when a resource was brought offline. The error code was 1018. Some changes may be lost.
/ comments
This has been corrected in SQL Backup 6.4
I just upgraded all my production from 6.3 to 6.4 and Registry Replication has re-surfaced in the SQLBackupAgent
HOWEVER............ the error continues no...
RBA wrote:
A fix for this problem has been discovered and will be included in the next release, due this quarter.
We are currently undergoing release testing, however, if you would like to receive the patch early please get in touch via private message or email (robin.anderson@red-gate.com).
Regards,
Great news, eager to wait for the new release!! / comments
RBA wrote:
A fix for this problem has been discovered and will be included in the next release, due this quarter.
We are currently undergoing release testing, however, if you would like to receiv...