SQL Server备份文件扩展正在自动更改... [英] SQL Server Backupfile Extensions are changing automaticaly ...

问题描述

亲爱的朋友们，



今天我遇到了一个问题，那就是SQL Server 2005数据库备份文件正在自动更改。我已经检查了多个站点，但我无法得到正确的解决方案。请有人给我打电话....





Regard's，

Thrilok。

Dear Friends,

Today i got an issue, that is SQL Server 2005 database Backupsfiles are changing automatically. I have checked in multiple sites but i couldn't get proper solution. please anybody tel me about this ....


Regard's,
Thrilok.

推荐答案

听起来您的备份系统正在运行。如果文件改变一个（非常大）的可能性是每天进行一次新的备份。根据作业的定义方式，每次运行备份时都可以生成文件名，从而更改名称。



检查在SQL Server下运行的作业（使用Management Studio展开作业部分。）

Sounds like your backup system is working. If the file changes one (quite big) possibility is that a fresh backup is taken every day. Depending how the job is defined the name of the file may be generated each time the backup is run thus changing the name.

Check the jobs that are running under SQL Server (using Management Studio expand the Jobs section).

这篇关于SQL Server备份文件扩展正在自动更改...的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！