Please start any new threads on our new 
    site at https://forums.sqlteam.com.  We've got lots of great SQL Server
    experts to answer whatever question you can come up with.
    
        | 
                
                    | 
                            
                                | Author | Topic |  
                                    | sunny_10Yak Posting Veteran
 
 
                                        72 Posts | 
                                            
                                            |  Posted - 2013-02-21 : 07:13:12 
 |  
                                            | Hi   I want to schedule Automatic Backup of Database . I am using SQL Express 2005.Thanks |  |  
                                    | James KMaster Smack Fu Yak Hacker
 
 
                                    3873 Posts | 
                                        
                                          |  Posted - 2013-02-21 : 08:29:36 
 |  
                                          | SQL Express 2005 does not have SQL Agent, so you will need to schedule the backup job using Windows Scheduler. |  
                                          |  |  |  
                                    | jackvMaster Smack Fu Yak Hacker
 
 
                                    2179 Posts | 
                                        
                                          |  Posted - 2013-02-23 : 02:22:57 
 |  
                                          | Read up on the BACKUP DATABASE command - which give a number of options regarding the destination. It could be worth adding some notification on the Scheduled job - for success\failureJack Vamvas--------------------http://www.sqlserver-dba.com |  
                                          |  |  |  
                                    | AlexVlgStarting Member
 
 
                                    3 Posts | 
                                        
                                          |  Posted - 2013-03-08 : 02:22:36 
 |  
                                          | Try out SQLBackupAndFTP. It's an easy tool to schedule backup jobs. You can save your backups to local folder, FTP, Dropbox, Google Drive or Amazon S3. There is free version with basic features, also you can try full version in trial mode.http://sqlbackupandftp.com/ |  
                                          |  |  |  
                                |  |  |  |