Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-07-26 : 09:11:47
|
| Brett writes "Please, help. I have a very annoying problem. An additional backup of my SQL Server 1997 database is recurring every day and it is hogging up space on the server. I only want one recurring backup.When checking my database backup plan, it seems there is only one backup instance: qarun_1099_release1_db_200207170200.BAK and qarun_1099_release1_tlog_200207170600.TRN. However, when I look in the default backup directory, SQL/Database/Backup, there is an instance in addition to the backup mentioned above with another name: qarun_1099_release1. This "mystery" backup is neither a .BAK or .TRN, but simply a file? I cannot figure out how and where this extra backup is recurring and I want to delete it.After disabling the jobs in the sysjobsteps and sysjobs tables of the msdb database, the backups continue to occur every day! Please advise.Sincerely,Brett" |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2002-07-26 : 11:01:56
|
| Did you disable the jobs using the agent or patching the tables? If it was by patching the tables then try using the agent.Try running the profiler to find out if anything is connecting when the backup takes place.Alos delete the maintenance plan and code your own backup statement (or sp) in a job then you wil be certain what is being scheduled.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
efelito
Constraint Violating Yak Guru
478 Posts |
Posted - 2002-07-26 : 11:06:07
|
| Does the date/time stamp on the file update too? Are you sure it's a backup file? Try viewing the contents in EM. Maybe the file is being created by another user or another application. View the ownership on the file to see what user or group created it.Jeff BanschbachConsultant, MCDBA |
|
|
|
|
|
|
Cannot delete