Comments
Sort by recent activity
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...
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...
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...
Most DBAs do not like to enable the xp_cmdshell, so it'll make the above solution not applicable
An alternative is to use
EXECUTE master.dbo.xp_dirtree @SourceDirBackupFiles, 1, 1 / comments
Most DBAs do not like to enable the xp_cmdshell, so it'll make the above solution not applicable
An alternative is to use
EXECUTE master.dbo.xp_dirtree @SourceDirBackupFiles, 1, 1
Interesting, I wouldn't know the easiest way to do a X-hour behind restore either, unless you add in some "time check" logic for LOG_*.sqb files
In our case, we Network Copy all log files off production to the file server
but only run the "Log Restore" job from 10pm-4am on the standby server (low activity times) / comments
Interesting, I wouldn't know the easiest way to do a X-hour behind restore either, unless you add in some "time check" logic for LOG_*.sqb files
In our case, we Network Copy all log files off produ...
Were these 3 files copied successfully for sure?
I'd use SQBConverter.exe to convert them back to .BAK file to make sure
Otherwise to be safe, re-copy those files
We had something like this last week where FTP didn't copy the .sqb files successfully / comments
Were these 3 files copied successfully for sure?
I'd use SQBConverter.exe to convert them back to .BAK file to make sure
Otherwise to be safe, re-copy those files
We had something like this last we...
Yes you can, at least I just did it today
I have encrypted .sqb backup file from production
restored it to the QA server via script (or GUI) today
RESTORE .............
WITH PASSWORD = 'xxxxxx'
I'm using SQL Backup 6.3 already though / comments
Yes you can, at least I just did it today
I have encrypted .sqb backup file from production
restored it to the QA server via script (or GUI) today
RESTORE .............
WITH PASSWORD = 'xxxxxx'
I'm...
I don't work for Red Gate [image]
Can you post the actual script?
I would suggest doing it manually with script inside a SSMS window
make sure msdb is not in use before the restore either
e.g.
ALTER DATABASE msdb SET SINGLE_USER WITH ROLLBACK IMMEDIATE / comments
I don't work for Red Gate
Can you post the actual script?
I would suggest doing it manually with script inside a SSMS window
make sure msdb is not in use before the restore either
e.g.
ALTER DATAB...
This is surprising, I usually get a RedGate reply within 24~48 hours [image]
May I request a reply?
or, who can I contact to ask this question as we have 1-year support, thanks?
Thanks in advance / comments
This is surprising, I usually get a RedGate reply within 24~48 hours
May I request a reply?
or, who can I contact to ask this question as we have 1-year support, thanks?
Thanks in advance
by the way, I notice there is no WITH STATS option either to see the progress of the restore?
Thanks / comments
by the way, I notice there is no WITH STATS option either to see the progress of the restore?
Thanks