Posts
                          
                            Sort by recent activity
                          
                          
                        
                      
                      
                        Log-shipping: "Restoring" instead of "Standby/Readonly"
                        
                        
                        
                        
                      
                      
                      
                  
                    This works -- when done calling it, I get my database restored as "Standby/Readonly" and I can access the tables within it.
EXEC master..sqlbackup
'-sql "RESTORE DATABASE CALL FROM DISK = [h:\db\re...
                      
                    
                      
                        Interoperability
                        
                        
                        
                        
                      
                      
                      
                  
                    Can I backup a Compatability Level 9 DB from a 2008 SQL Server, using SQL Backup, and restore it as is to a SQL Server 2005 box?
                      
                    
                      
                        Permissions problem - Warning 200
                        
                        
                        
                        
                      
                      
                      
                  
                    My server is fairly locked down; it caused problems on installation. Now it's causing problems on backup -- I'm failing to backup to the directory I'm aiming at, with the error:
Warning 200: Error ...
                      
                    
                      
                        Installation Failure
                        
                        
                        
                        
                      
                      
                      
                  
                  
                Installing 6.4.0.56. App installation appeared to go well; when I attempt to "Install or Upgrade Server Components..." I get the errors appended below.@version returns:
Microsoft SQL Server 2005 - ...
                      
                    