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?
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...
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...
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...