May 26, 2011 at 1:17 pm
we have SQL server web edition and I have installed all the Services packs.
But it does not run automated backup.
I get error
"The SQL Server Execute Package Utility requires Integration Services to be installed"
Web edition doesn't have integration services?
I downloaded hotfix KB960484 which will says it will solve that problem but when I run it , it shows has no shared to update.
I am confused is there any solutions for this ?
May 26, 2011 at 1:34 pm
Check 'Integration Services' at http://msdn.microsoft.com/en-us/library/cc645993.aspx
May 26, 2011 at 1:41 pm
As far as I can tell, the web edition supports the SQL Agent scheduler. If so, you can schedule the backup yourself using scripts rather than using the wizard.
June 16, 2011 at 3:29 pm
It seems that you're using SSIS to run your backups. Have you consider using the BACKUP command to do the task?
There are also third party tools that help you do this task in a very easy way. I use “SQL Backup and FTP” http://www.sqlbackupandftp.com/. You can do it 3 simple steps.
- connect to the server.
- select the database you want to backup
- Choose the destination folder and hit Run Now.
It also provides additional features like uploading backups to FTP repositories, schedule backup jobs, etc.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply