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


Top 5 Contributors of the Month
Imran Ghani
Post New Web Links

Edited maintenance plan as dtsx now log files don't work

Posted By:      Posted Date: October 11, 2010    Points: 0   Category :Sql Server
 

Hi all - any help would be appreciated

We created a standard maintainance plan via MS management with logging to text files. - working fine

I added a custom connection to a folder for manual backup of all ssis packages - Manage Connections no longer works via MS.

Imported the Maintplan into VS Solution - Edited connections and turned on SQL server logging

imported back into Integration services (MSDB/MaintPlans) - Log files are no longer being created.

Checked the "Reporting Task for subplan-{CEF4A469-AD4E-4762-B8F7-C3598E732AEE}" - it will not run in VS. and failed in the overnight job

Any ideas?


Regards Mark Pirks


View Complete Post


More Related Resource Links

Edited maintenance plan package - now .log files no longer created

  

**Resubmited to new forum as "Tools General" may be more appropriate**

Hi all - any help would be appreciated

We created a standard maintainance plan via MS management with logging to text files. - working fine

I added a custom connection to a folder for manual backup of all ssis packages - Manage Connections no longer works via MS.

Imported the Maintplan into VS Solution - Edited connections and turned on SQL server logging

imported back into Integration services (MSDB/MaintPlans) - Log files are no longer being created.

Checked the "Reporting Task for subplan-{CEF4A469-AD4E-4762-B8F7-C3598E732AEE}" - it will not run in VS. and failed in the overnight job

Any ideas?


Regards Mark Pirks
Regards Mark Pirks

SQL Server 2008 Maintenance plan will not delete bak and trn files

  

I have a sql 2008 maintenance plan to backup databases and to delete old bak files.  The db backup works but the delete does not.  I do not get any error messages, all steps marked successful.  So, I copied the sql statement EXECUTE master.dbo.xp_delete_file 0,N'Z:\SQL BACKUPS\',N'bak',N'2010-11-14T12:43:35',1 and tried to execute in a query window.  I have a successful completion message, BUT the files are not deleted.  I have ensured that the extension is bak and the folder is correct and the account has sysadmin on the server and is a sql sa.  I have tried many options and no success.  

We are version   Microsoft SQL Server 2008 (SP1) - 10.0.2531.0 (X64)   Mar 29 2009 10:11:52   Copyright (c) 1988-2008 Microsoft Corporation  Enterprise Edition (64-bit) on Windows NT 6.0 <X64> (Build 6002: Service Pack 2) (VM).

Any help would be appreciated.  Thanks!


Localization .RESX files - How to work with translators

  

I understand I need to place all the translated strings in .RESX files. How do I work with translators??? I do not think they will be able to open RESX files? Please advise your existing method of working with them. They mostly know Word... :)

 


Export Maintenance Plan in SSMS

  
Where are the subplan schedules when I exported /imported a Maintenance Plan in SSMS ? How can I ensure that they are exported with ?

Maintenance plan to rebuild Full-text index ? (SQL 2005)

  
Is it possible, through the GUI Wizard, to create a Maintenance plan that rebuilds (rather than reorganise/optimise) a Full text index in 2005 ? The full text index is based on one table only - so would using the "Rebuild index task" in the Wizard do the trick ? I wouldn't mind if the other indexes on the table were rebuilt too, but main concern in the Full text Index. If not - then I guess it would be a scheduled job which does a ALTER FULLTEXT CATALOG catalog_name REBUILD, but I thought it would be nice to keep it within the - Management - Maintenance plans - section of SQL Management Studio. Also - should this be preceeded with a transaction log backup ? Had some issues rebuilding them last night - seemed a Log backup was needed.

Maintenance Plan Works, But Not Through SQL Job

  
If I am in the wrong sub-forum, please let me know where I belong. I submitted this issue to this sub, b/c I believe I have an accessibility issue. I have a maintenance place that executes a stored proc. The stored proc is as followings: CREATE PROCEDURE spFirst     @Err AS INT = -1 AS     EXEC @Err = xp_cmdshell 'dir C:\temp\*.exe'     EXEC msdb.dbo.sp_send_dbmail @profile_name = 'Mail_Proj',                                        @recipients = 'me@xyz.com',                                              @body = 'Complete',                                           @subject = 'Dir Listing' The proc runs successfully and when done, I always get an email message in my Inbox, as expected. When the proc is executed directly from the maintenance plan, it still runs successfully, and the email message is successfully received in my Inbox. A SQL Job was setup to run the maintenance plan. The history of the job indicates that it is completing successfully, but this cannot be true, as my inbox never receives the expected email

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.

Maintenance Update Statistics plan

  
Hi, I've created a maintenance plan for many databases with these tasks (SQL 2005) 1- shrink Database 2- Update Statistics 3- Cleanup History 4- Backup Database (Full) 5- Maintenance Cleanup task The maintenance plan failed at task Update Statics.  Here the error message : Error number : -1073548784 Error message : Executing the query "UPDATE STATISTICS [dbo].[LOG_DETAILS] WITH FULLSCAN " failed with the following error: "Could not continue scan with NOLOCK due to data movement.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly. My question :How do I know which database is causing the problem and how can I fix the problem ? I don't know a dbo database? thanks,   Jasmin  

Need Best Practices for SSI packages (dtsx-files + ONE config)

  
Please advice hot to keep connection string for many packages at one place. Idea is to have one .dtsConfig-file for each iteas is not acceptable. DEV, TEST and PROD - different virtual computers. Each one can have it's own config-file lying in one and the same folder (c:\bi\configs\)

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?

Maintenance Plan Backup Failing Time to time

  
See ERRORO Below: I am using SQL Server 2008 64 bit enterprise edition and backing up on network drive. This differential backup run every weekdays and up to sat, it works just fine and sometimes fails every other week. Need some advice. I use a domain service account on SQL Server agent. Executed as user: DOMAIN\SERVER_ag_def. Microsoft (R) SQL Server Execute Package Utility  Version 10.0.2531.0 for 64-bit  Copyright (C) Microsoft Corp 1984-2005. All rights reserved.    Started:  12:45:04 AM  Progress: 2010-09-11 00:45:34.09     Source: {8006A2EB-FD95-45C3-8426-554DAE1895B4}      Executing query "DECLARE @Guid UNIQUEIDENTIFIER      EXECUTE msdb..sp...".: 100% complete  End Progress  Progress: 2010-09-11 00:58:12.09     Source: Back Up Database (Differential)      Executing query "BACKUP DATABASE [DataCollectorDW] TO  DISK = N'\\w...".: 50% complete  End Progress  Progress: 2010-09-11 01:01:17.26     Source: Back Up Database (Differential)      Executing query "declare @backupSetId as int  select @backupSetId =...".: 100% complete  End Progress  Progress: 2010-09-11 01:01:22.22     Source: Mai

Does a Maintenance Plan "Rebuild Index" task on Tables + Views rebuild the full text indexes ?

  

As subject really.

I'm talking about a complete rebuild - not an incremental, or a re-organise.

SQL 2005

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 : http://social.msdn.microsoft.com/Forums/en/sqltools/thread/5f17f4f1-fba9-436f-aedf-cfbfd89c8db2)

TIA


maintenance plan error send email

  

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.

Thanks!

Daniel


Database snapshots do not work well with databases having multiple log files

  
Hi,

It appears there is a bug in the implementation of database snapshots.

If you create a snapshot on a database with multiple log files:
CREATE DATABASE MYDB_ss1000 ON (NAME = MYDB_DB_GROUP2FILE1, FILENAME = 'D:\Restore\MYDB_DB_GROUP2FILE1_1000.ss')
, (NAME = MYDB_DB_GROUP2FILE2, FILENAME = 'D:\Restore\MYDB_DB_GROUP2FILE2_1000.ss')
, (NAME = MYDB_DB_GROUP3FILE1, FILENAME = 'D:\Restore\MYDB_DB_GROUP3FILE1_1000.ss')
, (NAME = MYDB_DB_GROUP3FILE2, FILENAME = 'D:\Restore\MYDB_DB_GROUP3FILE2_1000.ss')
, (NAME = MYDB_DB_PRIMARY1, FILENAME = 'D:\Restore\MYDB_DB_PRIMARY1_1000.ss')
, (NAME = MYDB_DB_PRIMARY2, FILENAME = 'D:\Restore\MYDB_DB_PRIMARY2_1000.ss') AS SNAPSHOT OF MYDB

Then restore from the snapshot:
RESTORE DATABASE MYDB FROM DATABASE_SNAPSHOT = 'MYDB_ss1000'

then all of you log files, but one will disappear. As a result the backup command will fail with the following message:
Msg 3636, Level 16, State 2, Line 1
An error occurred while processing 'BackupMetadata' metadata for database id 12 file id 10.
Msg 3046, Level 16, State 2, Line 1
Inconsistent metadata has been encountered. The on

T-SQL in 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..
Details:
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.

Command:USE MES_HDL_Batch;
GO
DBCC SHRINKFILE (N''MES_HDL_Batch_log'' , 0, TRUNCATEONLY) WITH NO_INFOMSGS;
GO

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

Question about Maintenance Plan

  

Hello

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 ?


Categories: 
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