.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Can't save Maintenance Plans (10.50.1600 / 2008 R2 x64)

Posted By:      Posted Date: September 03, 2010    Points: 0   Category :Sql Server
I run SQL Server 10.50.1600 / 2008 R2 x64 Enterprise. I am unable to create a maintenance plan via Management Studio. If I just try to create a new maintenance plan, then I get the following problem: "An OLE DB error 0x80004005 (Login timeout expired) occurred while enumerating packages. A SQL statement was issued and failed."

View Complete Post

More Related Resource Links

Cannot save maintenance plans

I am running SQL 2005 standard SP2 and I cannot save maintenance plans. Using the wizard I create the plan but it always fails with the following error messages:   An exception occurred while executing a Transact_SQL statement or batch   Invalid column name 'from_msx'. Invalid column name 'has_targets'. (Microsoft SQL Server , Error: 207)   Invalid column name 'msx_job_id'. (Microsoft SQL Server, Error: 207)   Thanks   Todd

Unable to modify Maintenance Plans SQL 2008

Been having a problem for a while, in that we are unable to modify any maintenance plans in SQL Server Management Studio. The server is running SLQ Server 2008 Standard on Windows 2003 Standard SP2

how can i export/import maintenance plans from 2005 to 2008?

I have this link http://sqlservernewbie.blogspot.com/2008/10/how-to-importexport-sql-server.html However, it is not the solution for me. When I expand SERVERNAME (Integration Services), all I can see it is Running packages and Stored packages, and I cannot expand any deeper. And the scripting way which described in the link above, seems is not finished. It just tells you about the select...JulieShop

SQL SERVER 2008 Create Maintenance Plans encounter General Access Denied error


After I clicked New Maintenance Plans and filled in <Maintenance Plans Name>, an error appeared like below: General access denied error, my account is already sysadmin and public, and agent service has started.


TITLE: Microsoft SQL Server Management Studio


General access denied error


General access denied error



SQL 2008 Maintenance plans missing Truncate transaction log checkbox



I am a noob SQL 2008 DBA and had a quick question on the maintenance plans. Under the database/tasks/backup function under options there is checkbox to truncate logs when they are being backed up. Yet when I create a transaction log backup job using the maintenance wizard the checkbox is missing for that option.  Why is that missing? 

Thanks, Jules

Cannot create maintenance plan in SQL 2008 SP1

I receive the following error trying to create a maintenance plan in SQL 2008 SP1 on a Windows 2008/R2 server: The action you attempted to perform on a remote instance of SQL Server has failed because the action requires a SQL Server component that is not installed on the remote computer. To proceed, install Microsoft SQL Server Management Tools on the remote computer, and then try again. The components that installed are Database Engine Services, Reporting Services, Client Tools Connectivity, Management Tools Basic/Complete, and SQL Client Connectivity SDK.  I have another independent SQL 2008 SP1 server running on the same platform with the same features installed and I have no problem creating maintenance plans there.  However, it does have IIS as it was upgraded from a SQL 2005 server which required IIS for reporting services while SQL 2008 does not. I'm familiar with http://social.msdn.microsoft.com/Forums/en-US/sqltools/thread/06c80a78-a877-4a48-a032-b0aef78a598c but that doesn't seem to apply as this was a new SQL 2008 installation on a freshly installed OS.  I've seen several other postings of this on the web but they all appear specific to SQL 2005. What else could be missing? Thanks.

Error Editing Step in Job (SQL Server 2008 R2 (RTM) - 10.50.1600.1 (X64))

Hello I am working on SQL Server 2008 migration project. We have SQL Server 2008 R2 (RTM) - 10.50.1600.1 (X64) on WS 2008 R2 Standard. 1) I am getting error when i try to change a step in job. The error information is given below. -- TITLE: Microsoft SQL Server Management Studio ------------------------------   Creating an instance of the COM component with CLSID {AA40D1D6-CAEF-4A56-B9BB-D0D3DC976BA2} from the IClassFactory failed due to the following error: c001f011. (Microsoft.SqlServer.ManagedDTS)   ------------------------------ ADDITIONAL INFORMATION:   Creating an instance of the COM component with CLSID {AA40D1D6-CAEF-4A56-B9BB-D0D3DC976BA2} from the IClassFactory failed due to the following error: c001f011. (Microsoft.SqlServer.ManagedDTS) -- Any idea why i am getting this error. It goes away when i close SSMS and re-open SSMS. Comes back again later on. Thank You for the help V

SQL 2008 Maintenance Plan configuration help

A client has purchased a software package that runs on SQL 2008, They did the initial install but that is a they want to do on there end. They have sent us a list on maintenance jobs to be configured but are no help in getting them in place. I have very little SQL expereince so I am looking for direction. Here is a list of jobs they wanted setup. 1.       Check database integrity – set plan to fire off daily. 2.       Reorganize index – set weekly – except on the week that you Rebuild indexes.  Start index page size at 50%. 3.       Rebuild index – set monthly 4.       Update statistics – set weekly after reorganize indexes and rebuild indexes. 5.       Clean up history – set monthly 6.       Back Up Database (FULL) – set daily 7.       Maintenance Cleanup Task – this is to control the number of locally available backups.          Can anyone help me get these in place? Thanks in advanced for any help. I am doing manual backups only a this time.

SQL 2008 SP1 - ALTER FAILED in Maintenance Plan

Hi, One of my SQL 2008 SP1 servers is experiencing periodic failures of a database maintenance plan that includes integrity checks.  Failed:(0) Alter failed for Server 'ssomsitrack1v'.  I've seen other postings from people who have had this issue with SQL 2005 and fixed it by either applying a service pack, enabling the "automatically set processor affinity mask" and/or I/O affinity mask settings, or by executing a sp_configure 'allow updates',0. This server already has both affinity mask checkboxes set, and allow updates is already set to 0.  The maintenance plan fails with this message about 1 in 4 times.  The server is on a VMWare VM w/2GB RAM and two vCPU's.  There's only one user database and it's tiny (~200MB). Any ideas?

How to save Windows credentials to a data source in SQL Server Reporting Services 2008 using Visual

I am trying to create a shared data source for SQL Server Reporting Services 2008 that uses a specific Windows user ID and password to connect to the database. Using the Report Manager web interface, if I create a shared data source and specify "Credentials stored securely in the report server", I can check the "Use as Windows credentials when connecting to the data source" checkbox. This tells SSRS that the user ID and password I specify are from a Windows user, not a SQL Server user. I want to create the shared data source using Visual Studio though. In Visual Studio I have an option to use stored credentials but there is no equivalent of the "Use as Windows credentials when connecting to the data source" checkbox. SSRS always assumes that user and password are for a SQL Server user, not a Windows user, and thus the connection fails. Does anyone know how to tell Visual Studio that the stored credentials are for a Windows user?

Error with Maintenance Plans - SQL 2005

Hi everyone.I have a problem with SQL 2005 with Cluster.  There is no issues with installation process and the cluster works fine. Normally I install SQL and apply Service Pack. So I do this, installing Service Pack 3 in both nodes (two nodes)After this, I create some databaese and restore backup from other SQL 2005 Server and also I import the logins to access SQLBut when I try access Maintenance Palns appears the following messageFailed to retrieve data for this request (Microsoft.SqlServer.SmoEnum)Additional Information:    an exception occurred while executing a Transact-SQL statement or batch (Microsoft.SqlServer.ConnectionInfo) Invalid column name 'from_msx'Invalid column name 'has_targets') Microsoft Sql Server, Error:207)What I do. Remove client components, Integration and Notification Services in both nodes, reinstall and apply Service Pack. Now I can create a new plan. but in the saving step appears the following messageSaving maitenance plan failed.Additional information:Failed to retrieve data for this request (Microsoft.SqlServer.SmoEnum)An exception occurred while executing a Transact-SQL statement or batch (Microsoft.SqlServer.ConnectionInfo) Invalid colum name 'ms_job_id' (Microsoft Sql Server, Error:207)I found some information in Internet, about a script that fixes this, but in Service Pack 2. I thinking in remove SQL , reinstall and test without SP. And

Exporting SQL Maintenance Plans

I have taken a look at the new maintenance plan designer and have come up with a maintenance plan I would like to be able to deploy on an enterprise level.  Anyone know of a way I can export the plan to another SQL 2005 server - without directly pulling from the msdb system tables?  I like the fact that you can script the output of most of the wizards, but the maintenance plan wizard does not appear to be one of them.Thanks,Matt

how to import a database from sql 2008 r2 to sql 2008 ( from 10.50.1600 to 10.0.2531.0)

Hi I wolud like to import a database from sql 2008 r2 to sql 2008. I have got an error: This version is incompatible with that server. Microsoft SQL Server Management Studio      10.0.2531.0 Microsoft Analysis Services-Clienttools      10.0.1600.22 Microsoft Data Access Components (MDAC)      6.1.7600.16385 Microsoft MSXML      3.0 6.0 Microsoft Internet Explorer      8.0.7600.16385 Microsoft .NET Framework      2.0.50727.4927 Betriebssystem      6.1.7600 Thanks in advance Sebatian

Windows XP, Visual Studio Express 2010 and SQL Server 2008 Express - How can I save modified columns



I am using c# in VS 2010 Express. I have a MDF database that I connect to through "Database Explorer". Database Explorer will not let me SAVE columns that I have modified. As I know in SQL Server 2008 full edition you can change the setting "Prevent saving changes that require table recreation" in Management Console to prevent this. I haven't got Management Console and can't see it in install.

How do I change this setting if I haven't got management console? Is it in Registry or Config File.



SQL Server 2008 R2 Reporting Services - How to I run a report and save the output as a .pdf on the s


I have the source code for doing what I want to do using a previous version of SSRS.  Since the new release, the service seems to work differently as I can't find any of the methods in the WSDL:

//Validate txtEmail for inputting

lblPrompt.Text="You must enter a valid email address!"

lblPrompt.Text="You must enter a valid email address!"

//Get report

TimeSheet.wdsg_svr003.ReportingService rs=new


Do cleanup maintenance plans that are linked to a backup job work for other backup jobs as well?



I have a job that backs up transaction logs and then there is another job within that plan that cleans up .trn files that are older than 48 hours. This job points to the directory where the transaction logs are backed up to. I just created a seperate maintenance plan to backup transaction logs for a different database. Will the cleanup job for the first backup job also clean up the logs from the second plan or do I need to create another job to cleanup the logs from the second backup job. My confusion is that the first backup job has specific databases that it is backing up and I'm wondering if that limits what the cleanup job does as well.

SQL Server 2005 Maintenance Plans - Reporting And Logging Does Not Work


I have a maintenance plan built on a SQL Server 2005 instance that rebuilds indexes, rebuilds statistics, checks for database integrity, performs a maintenance cleanup, and performs a history cleanup.  This job runs once per week.

In the "Reporting and Logging" section I have the following options:

- Generate a text file report is checked

- Create a new file is selected

- A valid destination folder is identified

- Send report to an email recipient is checked

- A valid agent operator is selected

- Log extended information is checked

The job seems to complete successfully and a report is created and emailed, but the only information in the report is as follows:

Quest SLSSQLMaint Utility.
Logging on to SQL Server 'DEVSQL01' with Windows Authentication
Logged on to SQL Server 'DEVSQL01'

[1] Delete old text report files...
[1] Execution Time: 0 hrs, 0 mins, 0 secs.

[2] Send DBMail or SendMail report file....

[2] Execution Time: 0 hrs, 0 mins, 1 secs.

End of maintenance plan 'DB Maintenance Plan (No Backups) [DB Maintenance]' on 9/29/2010 8:40:49 PM (Success)
C:\Program Files\Microsoft SQL Server\MSSQL.4\MSSQL\Binn\slssqlmaint.exe Process Exit Code: 0 (Success)

Where is the information about the rest of the maintenance plan?&nbs

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend