如何查找Sql Server存储作业的文件？ [英] How Can I Find A File Where Sql Server Is Storing Jobs ?

问题描述

嗨


我是SQL服务器的新手。

几个月前我创建了一个备份工作。



JOB RUN：'Bhupinder_backupjob'于2014年3月29日下午6:36:40运行

DURATION：0小时0分54秒

状态：成功

消息：工作成功了。工作由附表9（备份）调用。最后一步是第2步（Getdatetime）。



我的问题是这个工作正占用我硬盘上的空间。

它几乎已经填满了我的硬盘。

我已经停止了这项工作，但我的硬盘已经填满了。



我的问题是怎么能我找到一个存储整个备份的文件，以便我可以删除该文件并在我的硬盘上留出一些空间。





删除了SHOUTING，Urgency已删除 - OriginalGriff [/ edit]

Hi
I am new to SQL server .
Few months ago i created a backup job .

JOB RUN: 'Bhupinder_backupjob' was run on 3/29/2014 at 6:36:40 PM
DURATION: 0 hours, 0 minutes, 54 seconds
STATUS: Succeeded
MESSAGES: The job succeeded. The Job was invoked by Schedule 9 (back up). The last step to run was step 2 (Getdatetime).

My problem is this job is eating space on my hard disk .
It has almost filled up my hard drive .
I have stopped this job but my hard drive is filled up.

My question is how can i find a file where this whole backup is stored so that i can delete that file and make some space on my hard drive .


[edit]SHOUTING removed, Urgency deleted - OriginalGriff[/edit]

推荐答案

查看SQL Server Management Studio中的Management节点，这里要查看的是维护计划部分，如果这是您执行任务的方式，您可以右键单击维护计划并选择修改...等待wysiwyg编辑器打开...查找子计划，通常只有一个备份数据库类型然后双击它，选择Destination tabl并找到你的备份。

随你的问题em，考虑转向选项并定义备份集将过期选项。

Check out the Management node in your SQL server Management studio, here the place to look is the Maintenance Plans section, if this is the way you did the task you can rightclick the maintenance plan and choose modify... wait forever for the wysiwyg editor to open ... the find the subplan, often there is only one back up database type and the double click on that, choose Destination tabl and locate your backup.
With your problem, consider turning to options and define Backup set will expire option.

这篇关于如何查找Sql Server存储作业的文件？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！