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


Top 5 Contributors of the Month
david stephan
Post New Web Links

Maintenance Cleanup task not functioning properly???

Posted By:      Posted Date: September 05, 2010    Points: 0   Category :Sql Server
 
Using SQL Server 2005 Management Studio and backing up databases. When I add the task Maintenance Cleanup to remove database backups older then 1 day the task fails???What part of this TSQL code does SQL Server 2005 Management Studio not understand?EXECUTE master.dbo.xp_delete_file 0,N'\\pdxsql03\SQL Backup\POSSQL_Server',N'.bak',N'05/15/2006 08:09:37'The database file backup extension is .bak and the file is older than one day which was specified.It is just not deleting the file.We have deleted the maintenance task and recreated it with no effect and this has been happening for over a month.Any help here would be greatly appreciated.Carlcarlt@gicw.org


View Complete Post


More Related Resource Links

Task scheduler and System.IO.File.WriteAllText() not working properly

  
I have a simple console application that has this in mainline:  Console.WriteLine(System.String.Format("the current directory is: {0}", System.IO.Directory.GetCurrentDirectory())); System.IO. File.WriteAllText(@"test.txt", "new contents");   Console.ReadLine(); I compile this in VS 2010 and copy the EXE to a directory named "c:\test".  When I run this code in two different OS's via "Task Scheduler" and "Scheduled Task" I get different results.   In Windows Server 2003 R2 "Scheduled Task" this code will create a file as I would expect, c:\test\test.txt with the proper contents written to it.  When I run this same code on Windows 2008 R2 (64 bit version) "Task Scheduler" it writes the expected contents to an unexpected location, c:\C:\Windows\SysWOW64\test.txt. In both environments if I run the exe's from a command line, it writes to c:\test\test.txt as I would expect. As I understand it, if you don't fully qualify the file name in the first parameter of the WriteAllText method it will write the contents to the file in the directory of the executable however this seems to break down when running in the Windows 2008 Task Scheduler.  I know I can fully qualify the file name or put the expected path in a

"Open this task" link not functioning

  
Hello everyone, I am using the OOTB approval line to generate tasks for document approval.  For some reason I have encountered a very strange issue where using Outlook 2010 and clicking the "open this task" I get this error http://yfrog.com/12outlooktaskerrorj

SQL Server 2005 (X64) Maintenance Clean Up Task Using Hours Option for File Age

  
I'm running into an issue with SQL Server 2005 64-bit and the maintenance clean up tasks.  I have it set up to delete any transaction logs or backups older than 12 hours.  It seems that there could be some sort of bug because, according to the log files, SQL is running the clean up for 12 days instead.  I've created a work around for this by using execute transact-sql tasks instead, but was wondering if there's a problem with my version of SQL Server, like an SP or patch that I've overlooked. Here's my version information: Microsoft SQL Server 2005 - 9.00.1399.06 (X64)   Oct 14 2005 00:35:21   Copyright (c) 1988-2005 Microsoft Corporation  Enterprise Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 2)

Execute SQL Task with XML resultset not return properly

  
Hello, I have a table with one column as XML data type, and it stored XML content from a XML file. In SSIS, I used execute SQL Task, and select the XML column from the table, and set resultset as XML. I then defined a variable XMLList as string, and I used this XMLList variable as resultset. When I run the package, I saw from watch window that this XMLLIst variable not returned the proper value from the table column, but with something like <ROOT><?MSSQLError HResult=\"0x80004005\" etc. Could anyone give me advice on what is wrong with my settings for resultset? Any suggestion will be appreciate!  

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


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

  

Hello,

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.


Huge temdb and msdb data file after Cleanup Task

  

I've run the History Cleanup Task has a maintenance job.

After the job ran successfully, I noticed that the data files of msdb and temdb are over 2 GB of size. I've tried to shrink both databases and I didn't get much. It is normal to have the tempdb over 3 GB after run History Cleanup Task even when this is was not the size of the database tempdb before run the History Cleanup Task ??

Best regards


Check if my sql server is not functioning properly

  

hello,

how can i know how my sql server is performing and how to know if it is freezing or is not functioning properly

thxs in advance


Sharepoint 2010 Approval Workflow "Open this task" link not functioning

  

When I am clicking on "Open this task" link in outlook 2010 i am getting error as "Access to the floowing form required". Please help me out to resolve the issue..

 

Thanks,

Basavaiah 

 

 


WSS 3.0 User permissions not functioning properly after...

  

Hi everyone,

I have an SBS 2008 domain with WSS 3.0 (SQL 2005 Express) default install. I added a child site and must have accidentally clicked the "Manage Permissions  of Parent" instead of the "Edit Permissions" link which you inherit and then break off inheritance to create unique permissions. Unfortunately I did not catch my mistake until it was much too late.

All my permissions were working well before this.

I have recreated all my Parent Site permissions, but they are not working properly. They are also not working on the child site, either. All the rights that I did not change in creating the permissions for the child site work properly. The ones I have recreated aren't allowed any "Design" functionality. They cannot start work flows, mark tasks assigned to them as complete (edit Tasks), anything that requires the slightest permission above read. They can edit documents and save them in the libraries, but nothing in the Edit SharePoint realm as I have granted them rights to do.

I haven't found anything specific to this problem online.

Any help on this will be greatly appreciated. As it is now, I have built all these lovely work flows that people were able to use and now they cannot. They are growing irritable.

 

John

Technical Director

Harvest America Corporation


Maintenance Plan Backup Database Task timeout

  

Hi,

I am using SQL Server 2008.  I am trying to create a new Maintenance Plan.  I create the plan, and then add a backup database task to the plan.  When chosing Databases to backup, if I chose "All Databases" or "All user databases", and then click OK, the UI hangs for a while, then eventually, it comes back with an unhandled exception.  If I look at the details, I see the following exception:

Microsoft.SqlServer.Management.Sdk.Sfc.EnumeratorException: Failed to retrieve data for this request. ---> System.Data.SqlClient.SqlException: Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.

If I chose the option "Choose databases" and pick databases to backup, things seem to work just fine.  New databases on are added to this server on a regular basis.  I do not want to maintain the list of DBs to backup.  Any suggestions?

Thanks,

Scott


connection to SQL Server files (*.mdf) require SQL server express 2005 to function properly.

  

I dont have the SQL EXPRESS installed instead I have SQL Standard Edition.

 I have two SQL Server instances installed.

 1- UserLT (this is sql 2000)
2- UserLT\SQL2005 (this is SQL 2005 named instance)

But when i try to add a database to my VS website project I get the following error:

Connection to SQL Server files (*.mdf) require SQL server express 2005 to function properly. please verify the installation of the component or download from the URL: go.microsoft.com/fwlink/?linkId=4925

I went in Tools>Opetions>DataBase tools>Data Connection>Sql Server Instance Name (blank for default)

and changed the "SQLEXPRESS" to "USERLT\SQL2005".

But I still get the same error message. Any ideas how i can resolve this issue?


Intermittant error: "A connection attempt failed because the connected party did not properly respon

  

Greetings,

I'm having a doozy of a problem, and can't find a solution.  I have a WFC Web Service installed to a pair of servers, and accessed through a load balancer.  I am accessing the service from an ASP.NET client app, also via WCF.  The Client is not load balanced.

I'm getting an intermittant error:

(Inner Most Exception) System.Net.Sockets.SocketException:  A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond x.x.x.x:80

(Middle Exception) System.Net.WebException: Unable to connect to the remote server

(Outer Exception) System.ServiceModel.EndpointNotFoundException:  Could not connect to http://<MYSite>/<MYApp>/<MYService>.svc. TCP error code 10060: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond x.x.x.x:80.

I can reproduce this error with about 20% reliability if I execute the exact same page request on the client from 2 browsers at the same time.  When the problem occurs, the successful p

Code Cleanup: 9 Useful Tactics for Paying Back Technical Debt

  

Now that you've identified technical debt in your code base, let's turn our attention to some specific tactics that will help you pay back that debt.

David Laribee

MSDN Magazine January 2010


Code Cleanup: Using Agile Techniques to Pay Back Technical Debt

  

Every codebase contains some measure of technical debt - code that is maddeningly hard to test and maintain. We outline some ideas for identifying and dealing with the high-interest debt in your code.

David Laribee

MSDN Magazine December 2009


Parallel Debugging: Debugging Task-Based Parallel Applications in Visual Studio 2010

  

In Visual C++ 10 and the Microsoft .NET Framework 4, Microsoft is introducing new libraries and runtimes to significantly ease the process of expressing parallelism in your code base, together with new tool support for performance analysis and debugging of parallel applications. In this article, you will learn about debugging support in Visual Studio 2010, much of which is focused on task-based programming models.

Stephen Toub, Daniel Moth

MSDN Magazine September 2009


Windows with C++: Task Scheduler 2.0

  

The new Task Scheduler in Windows Vista can do so much more than previous versions. We introduce some basic concepts and building blocks you can put to use in your own scheduled task projects.

Kenny Kerr

MSDN Magazine October 2007


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