Comments
Sort by recent activity
Not sure why this user question was suggested to me as a reply? Still seems like a bug to me that RedGate should fix. / comments
Not sure why this user question was suggested to me as a reply? Still seems like a bug to me that RedGate should fix.
declare @p3 nvarchar(4000)
set @p3=N'0'
exec master..sqbutility @Parameter1=1001,@Parameter2=N'L:SQLBackupsFULL_(local)_VCM_20150411_120013.sqb',@Parameter3=@p3 output
select @p3 / comments
declare @p3 nvarchar(4000)
set @p3=N'0'
exec master..sqbutility @Parameter1=1001,@Parameter2=N'L:SQLBackupsFULL_(local)_VCM_20150411_120013.sqb',@Parameter3=@p3 output
select @p3
It worked just fine, it gave me 2 rows of the data and log file with values that seem correct. do you need to see the values? / comments
It worked just fine, it gave me 2 rows of the data and log file with values that seem correct. do you need to see the values?
1ST TASK:
Verifying file:
\tcaraid8tbPublicSQLBackupsFULL_(local)_VCM_20150411_120013.sqb
Attempting to restore this backup may encounter storage space problems. Subsequent messages will provide details.
The path specified by "C:MSSQLMSSQL11.MSSQLSERVERMSSQLDATAVCM_data.mdf" is not in a valid directory.
Directory lookup for the file "C:MSSQLMSSQL11.MSSQLSERVERMSSQLDATAVCM_log.LDF" failed with the operating system error 3(The system cannot find the path specified.).
The backup set on file 1 is valid.
SQL Backup process ended.
2ND TASK:
Reading SQB file header of "\tcaraid8tbPublicSQLBackupsFULL_(local)_VCM_20150411_120013.sqb"
Backup group ID : 96258477
File number : 1 of 1
Threads : 7 (multi-threaded file)
Backup type : 1 (Database)
Native backup size : 11.063 MB
Database size : 6.492 MB
Backup start : Saturday, April 11, 2015 12:00:13 PM
Backup end : Saturday, April 11, 2015 12:00:13 PM
Server name : TRILAPTOP6
Database name : VCM
First LSN : 33468000000031800037
Last LSN : 33468000000033500001
Checkpoint LSN : 33468000000031800037
Database backup LSN : 33462000000006100037 / comments
1ST TASK:
Verifying file:
\tcaraid8tbPublicSQLBackupsFULL_(local)_VCM_20150411_120013.sqb
Attempting to restore this backup may encounter storage space problems. Subsequent messages will provide de...
could you please let me know why I couldn't restore it using SQL Backup Pro directly? I've not yet been able to try your ssms restore, but certainly I don't expect to have to do this every time... / comments
could you please let me know why I couldn't restore it using SQL Backup Pro directly? I've not yet been able to try your ssms restore, but certainly I don't expect to have to do this every time...
Just FYI, the issue is that the RG tool will create inproper time entries, like the following: 2013-07-13 14:60:00.1234567 -04:00 instead of what should be which is:
2013-07-13 15:00:00.1234567 -04:00. If you search in your script, you will see some :60: entries...
Extremely frustrating... / comments
Just FYI, the issue is that the RG tool will create inproper time entries, like the following: 2013-07-13 14:60:00.1234567 -04:00 instead of what should be which is:
2013-07-13 15:00:00.1234567 -04...