Activity overview
Latest activity by dklein9930
                    
                      
                        Backup Differencial error
                        
                        
                        
                        
                      
                      
                      
                
                  Executed as user: ''. SQL Backup failed with exit code: 5160  SQL error code: 0 [SQLSTATE 42000] (Error 50000).  The step failed.
What error does this indicate?
Thanks,
                      
                    
                  
                    
                      
                        My apologies Peter,  
The server that is taking the backup is running Redgate backup version 5.3.0.178. The server that we are attempting a ‘partial’ restore on is running version 6.4.0.56. How would this change the solution to our problem? What cost/work is involved in upgrading version 5 listed above to the version to sent me 6.5.2.23?  
Thanks for your time, 
David / comments
                        
                        
                        
                      
                      
                      
                
                  My apologies Peter,
The server that is taking the backup is running Redgate backup version 5.3.0.178. The server that we are attempting a ‘partial’ restore on is running version 6.4.0.56. How w...
                      
                    
                  
                    
                      
                        Did this occur cause the transaction logs were on a different version than the full backups? Is the first action after the switch to take a full backup?  
Thanks, 
David / comments
                        
                        
                        
                      
                      
                      
                
                  Did this occur cause the transaction logs were on a different version than the full backups? Is the first action after the switch to take a full backup?
Thanks,
David
                      
                    
                  
                    
                      
                        Hey Peter,  
I switched out the files and the first transaction log backups came back with this error:   
"Executed as user: dbo. SQL Backup failed with exit code: 667  SQL error code: 0 [SQLSTATE 42000] (Error 50000).  The step failed."  
Thanks, 
David / comments
                        
                        
                        
                      
                      
                      
                
                  Hey Peter,
I switched out the files and the first transaction log backups came back with this error:
"Executed as user: dbo. SQL Backup failed with exit code: 667  SQL error code: 0 [SQLSTATE 42000...
                      
                    
                  
                    
                      
                        Thanks for the reply Peter. What is this error? We have been using this version for almost 3 years, we have clients who are receiving backups from us in this version. Management is reluctant to make changes. Why did this error happen all of the sudden?  
Thanks again, 
David / comments
                        
                        
                        
                      
                      
                      
                
                  Thanks for the reply Peter. What is this error? We have been using this version for almost 3 years, we have clients who are receiving backups from us in this version. Management is reluctant to mak...
                      
                    
                  
                    
                      
                        Error: Rijndael: Invalid key size - 0, red gate
                        
                        
                        
                        
                      
                      
                      
                
                  Error when attempting a restore. Version: 6.4.0.56
                      
                    
                  
                    
                      
                        Backup failed on disabled sql login.
                        
                        
                        
                        
                      
                      
                      
                
                  Greetings,
I recently disabled an old sql login, used by a former employee, now a database backup is failing with the following message:
SQL error 18470: Login failed for user ''. Reason: The accou...
                      
                    
                  
                    
                      
                        Use Copyto or Mirror
                        
                        
                        
                        
                      
                      
                      
                
                  Hey All,
I need to copy a full backup to a reporting server with a fixed name. The local copy gets an auto name. Can I use copyto to rename or choose a different name than the <auto.sqb> name given...
                      
                    
                  
                    
                      
                        Thanks Peter / comments
                        
                        
                        
                      
                      
                      
                
                  Thanks Peter
                      
                    
                  
                    
                      
                        Problems with 2nd Copyto location
                        
                        
                        
                        
                      
                      
                      
                
              My backup script is erroring out on the second copyto location. I am guessing it is permissions, but I want to be sure the scripts looks alright.
DECLARE @exitcode int
DECLARE @sqlerrorcode int
EXE...
                      
                    
                  