Comments
Sort by recent activity
Thanks for the reply. I double checked and the account that the service runs under does have rights to delete from the network location. / comments
Thanks for the reply. I double checked and the account that the service runs under does have rights to delete from the network location.
Huh... it just stopped doing it. Sorry for the post, I'll try and find out how I got the behavior to start and post the steps. / comments
Huh... it just stopped doing it. Sorry for the post, I'll try and find out how I got the behavior to start and post the steps.
Linda Hawksworth wrote:
... the 1.2 release due out imminently.
Exciting! [image]
I've been using the product for a little over 2 weeks and love it so far. I'm going to love seeing what user requests and enhancements made it into the new release! / comments
Linda Hawksworth wrote:
... the 1.2 release due out imminently.
Exciting!
I've been using the product for a little over 2 weeks and love it so far. I'm going to love seeing what user request...
You can use the Restore wizard to restore to a remote server. You need to add the server you want to restore to in SQL Backup. When you open the Restore wizard you can then select the SQL Server on step 1. You will need to browse for the backup files to restore.
And to be clear that server must also have SQL Backup server components installed on it.
Clive, can you get the file names that you need for your script out of the
[msdb].[dbo].[backupset] and [msdb].[dbo].[backupmediafamily] tables? Here's a chunk of code that might help you out. SELECT [backupset].[backup_set_uuid],
[backupset].[backup_start_date],
[backupset].[type],
[backupmediafamily].[physical_device_name],
RIGHT([backupmediafamily].[physical_device_name],CHARINDEX('\',REVERSE([backupmediafamily].[physical_device_name])) - 1) AS [FileName]
FROM [msdb].[dbo].[backupset]
INNER JOIN [msdb].[dbo].[backupmediafamily]
ON [backupset].[media_set_id] = [backupmediafamily].[media_set_id]
WHERE [backupset].[database_name] = @RestoreFromDB
AND [backupset].[backup_start_date] BETWEEN @RestoreStart AND @RestoreEnd
AND [backupmediafamily].[logical_device_name] LIKE 'Red%'
If you need the actual file paths of the log and data files you can find those out in [msdb].[dbo].[backupfile] / comments
You can use the Restore wizard to restore to a remote server. You need to add the server you want to restore to in SQL Backup. When you open the Restore wizard you can then select the SQL Server ...
I'll third this one! [image] / comments
I'll third this one!
Scott Herbert wrote:
I had this problem as well. Swore a bit, re-entered my serial numbers and all was back to normal. Fingers crossed it doesn't happen again.
Exact same resolution here. Strange because prior to this happening I was at the limit of my license and when I re-entered it I received no errors. Maybe this re-activation doesn't look for valid license seats to be left? / comments
Scott Herbert wrote:
I had this problem as well. Swore a bit, re-entered my serial numbers and all was back to normal. Fingers crossed it doesn't happen again.
Exact same resolution here. Str...
Images are worth a thousand words, here's a screen cap. [image] / comments
Images are worth a thousand words, here's a screen cap.
Yep, that fixed it. Maybe we can add to the list of changes for 2.0 that it will connect to the IP that resolves or the IP given instead of doing it's own thinking on the subject :? / comments
Yep, that fixed it. Maybe we can add to the list of changes for 2.0 that it will connect to the IP that resolves or the IP given instead of doing it's own thinking on the subject :?