Activity overview
Latest activity by dbouchard
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.
Removal of space before FROM in sub-query undesired, how to stop it?
I have the following Sql query and Sql Prompt insists on removing the space before the FROM in the sub-query every time. How do I stop this?SELECT TOP (50000000)
[Id] , [SourceBranch]
...
Valid Sql merge statement fails Sql Prompt layout
The below valid sql stored proc fails the layout command in Sql Prompt. Why?
<bbcode>
create PROCEDURE dbo.usp_mrg_JournyxTimeRecs
AS
BEGIN
SET NOCOUNT ON;
MERGE INTO dbo.journyx_time_recs T
USING...
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...
Unable to restore backup sqb file
Well, this is depressing. I have hundreds of sqb backup files and this is the first time I'm trying to restore one ever! when I do, I get the error shown in the attached image file. what can I d...
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...
DateTimeOffset support not working
I have 2 databases with several tables that contain datetimeoffset fields. I have emptied one of the databases so that sdc10 will basically be doing a move from one db to the other and the script ...