I cannot modify existing maintenance plans on a remote sql 2005 server when using SSMS Express 2008 R2.
The maintenance plan wizard works fine and I can see all the plans in the list.
Is this a known problem?
View Complete Post
As subject really.
I'm talking about a complete rebuild - not an incremental, or a re-organise.
The full text indexes are only on individual tables, not Views.
I've asked a similar question before, but sufficiently different, and other is marked as Answered so thought I'd open a new Q :
Some body have this error : Could not generate mail report.An exception occurred while executing a Transact-SQL statement or batch.No global profile is configured. Specify a profile name in the @profile_name parameter. When i execute my maintenance plan.
When I run this code in the query tool, it works. But I put the exact code in a T-SQL Task of a Maintenance Plan and I get the following error:
Status: Warning: One or more tasks failed..
Execute T-SQL Statement Task (ALX-ENGCSRV32)
Execute TSQL on Local server connection
Execution time out: 30000
Task start: 2010-09-24T12:24:41.
Task end: 2010-09-24T12:24:41.
Failed:(-1073548784) Executing the query "DBCC SHRINKFILE (N'MES_HDL_Batch_log' , 0, TRUNCATEONLY) WITH NO_INFOMSGS;
" failed with the following error: "Could not locate file 'MES_HDL_Batch_log' for database 'master' in sys.database_files. The file either does not exist, or was dropped. ". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly,
parameters not set correctly, or connection not established correctly.
DBCC SHRINKFILE (N''MES_HDL_Batch_log'' , 0, TRUNCATEONLY) WITH NO_INFOMSGS;
I understand the problem but don't know how to fix it - not looking at right database in order to find the log file.
FYI: I'm in a manufacturing environment and working with a older boxed product where transaction log just grows and grows. We don't ever roll transactions back or anything so that's
I made mistake and ran "Maintenance Plan" instead another job
from SQL server agent, it did not executed but run time was 20 secund, i stoped it manualy. I am interested in this will cause any problem? did it change something in database if it did now full execute ?
We have a database schema with a period in it's name. This is valid as per
http://msdn.microsoft.com/en-us/library/aa224033(SQL.80).aspx. When we create a maintenance plan to update statistics it will succeed if the object property is set to 'Tables and Views'.
If this is set to 'Table' it will fail.
Steps to Reproduce
CREATE SCHEMA [Windows.EventLog] AUTHORIZATION [dbo]
CREATE TABLE [Windows.EventLog].[Computer](
[ComputerId] [smallint] IDENTITY(1,1) NOT NULL,
[ComputerName] [varchar](255) NOT NULL,
CONSTRAINT [PK_Computer] PRIMARY KEY CLUSTERED ([ComputerId] ASC)
) ON [PRIMARY]
I am running a maintenance plan (Sql Server 2008 Enterprise) every night at mid-night. All the plan entails is doing a full backup of one database (about a 3GB database). We are getting timeouts on our site at exactly that point when the database is being backed up and they last up to 20min. I was under the impression that doing backups this way does not take the db down? Or am I wrong about this?
Has anyone else experienced this and if so what steps did you take to rectify it? Sorry if I have not provided other information, just let me know and I will give it to you.
I have installed SQL 2005 SP2 yesterday and when trying to schedule a maintenance plan I get an error from Microsoft .NET framework as soon as I click on the calendar button:
"Unhandled exception has occurred in a component in your application. If you click Continue, the application will ignore this error and attempt to continue.
Method not found: 'Boolean Microsoft.SqlServer.Management.SqlMgmt.JobScheduleData.UpdateSourceSchedule()'"
SQL Server Agent is running.
Can anybody help me on that?