| Author |
Topic |
|
dsasys
Starting Member
8 Posts |
 Posted - 2009-11-23 : 18:02:15
|
| Hi guys. I am trying to setup a maintenance plan to backup a database but when I try and test it by executing the plan it fails. I get the following at the bottom when I check the job history"Executed as user: <Removed this bit>. Microsoft (R) SQL Server Execute Package Utility Version 10.0.1600.22 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. The SQL Server Execute Package Utility requires Integration Services to be installed by one of these editions of SQL Server 2008: Standard, Enterprise, Developer, or Evaluation. To install Integration Services, run SQL Server Setup and select Integration Services. The package execution failed. The step failed."I tried to install the integration services, but we only have SQL server 2008 workgroup which doesn't have the option to install the service. I also downloaded SQL server 2008 from Microsofthttp://www.microsoft.com/SQLserver/2008/en/us/trial-software.aspxbut it doesn't have the option either under features to install the service? Any ideas? Its a pain having to manually do a backup of the database each day.Cheers,Jason. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
dsasys
Starting Member
8 Posts |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
dsasys
Starting Member
8 Posts |
Posted - 2009-11-23 : 22:14:50
|
| Hi Tara,I ran the following line and got the errors below. It didn't create a file. Any ideas?osql -U sa -S (local) -d ISRP71 -i c:\isp_Backup.sql 610> 611> 612> 613> 614> 615> The module 'isp_Backup' depends on the missing object'master.dbo.xp_backup_database'. The module will still be created; however, itcannot run successfully until the object exists.The module 'isp_Backup' depends on the missing object 'master.dbo.sqlbackup'.The module will still be created; however, it cannot run successfully until theobject exists.The module 'isp_Backup' depends on the missing object 'master.dbo.sqlbackup'.The module will still be created; however, it cannot run successfully until theobject exists.The module 'isp_Backup' depends on the missing object 'master.dbo.sqlbackup'.The module will still be created; however, it cannot run successfully until theobject exists.1> |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2009-11-23 : 23:34:05
|
| Those actually aren't errors. They are warnings and should be ignored. It just means your system doesn't have Quest's SQL Litespeed or Red Gate's SQL Backup products installed. isp_Backup will still work without those. They are third party backup tools that improve SQL backups. When you don't have them installed, you just pass 'NV' for @bkpSwType input parameter.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog"Let's begin with the premise that everything you've done up until this point is wrong." |
|
|
|
dsasys
Starting Member
8 Posts |
Posted - 2009-11-23 : 23:42:05
|
quote:
Originally posted by tkizer
Those actually aren't errors. They are warnings and should be ignored. It just means your system doesn't have Quest's SQL Litespeed or Red Gate's SQL Backup products installed. isp_Backup will still work without those. They are third party backup tools that improve SQL backups. When you don't have them installed, you just pass 'NV' for @bkpSwType input parameter.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog"Let's begin with the premise that everything you've done up until this point is wrong."
Ok but it didn't create a backup file to the directory I specified in the line below@path = 'C:\ISRP-backup\',IS there something I missed? Is my osql line correct? Thanks for your help. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
dsasys
Starting Member
8 Posts |
Posted - 2009-11-24 : 22:28:19
|
| ok so I can't run it via command line with osql? I have never setup a job in sql. Seems a little complicated without using a wizard. Do you have any more detailed instrutions on how to use your script under SQL Server Agent - Jobs?Cheers,Jason. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
dsasys
Starting Member
8 Posts |
Posted - 2009-11-25 : 18:03:14
|
| Thanks. I added the following under the command section in the step for the backup job I created. Getting an error about it not finding isp_Backup.sql file. How do I tell the backup job where to call this script from? Or have I setup the job wrong? Cheers. EXEC isp_Backup.sql @path = 'C:\ISRP-backup\', @dbType = '-ISRP71', @bkpType = 'Full', @retention = 5, @bkpSwType = 'NV', @archiveBit = 0, @copyOnly = 0 |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2009-11-25 : 19:10:37
|
| isp_Backup gets put into a database. I use a database named DBA. Once the object has been created, you no longer need the sql file. Now you just execute it. Here's an example:EXEC DBA..isp_Backup@path = 'C:\ISRP-backup\', @dbType = '-ISRP71', @bkpType = 'Full', @retention = 5, @bkpSwType = 'NV',@archiveBit = 0,@copyOnly = 0Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog"Let's begin with the premise that everything you've done up until this point is wrong." |
|
|
|
dsasys
Starting Member
8 Posts |
Posted - 2009-11-25 : 23:16:38
|
| Ok will give that a go. Thanks |
|
|
|
|
Maintenance plan problem