Re: How do I delete backed-up databases?
- From: GTC <GTC@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Wed, 16 Apr 2008 14:27:01 -0700
Ekrem,
Thanks. That was the workaround I could think of.
SQL 2005 is backward for Database Administrator who needs support a lot of
servers. It now creates more works/jobs to do and monitor.
Thanks a lot.
Glen
"Ekrem Önsoy" wrote:
How about creating two different backup folders for your dbA and dbB backup.
files and then create cleanup tasks differently for each of them. Then
you'll be able to set different values for each task.
--
Ekrem Önsoy
"GTC" <GTC@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:248A7F6A-836F-4E3B-93A2-9369D41B5680@xxxxxxxxxxxxxxxx
Hi all,
Does anyone know how to set up maintenance job that will only remove the
specific database backup file, not all databases with expiration based on
time only?
i.e. two dbs, dbA and dbB.
dbA retention period requirement is 5 days and dbB is 2 days. I do
not want dbB cleanup job remove dbA backup files in the same directory
which
are older than 2 days(this is not an issue for SQL 2000). But what I can
see
the 'maintenance cleanup task' is that one can only specify days to remove
and directory where the backup files locate and extention of backup files.
Thanks advanced for your help.
Glen
"Andrew J. Kelly" wrote:
1. How do I display sp_deletebackuphistory? Is this found in MS SQL
Server Management Studio?
I am not sure what you mean by "Display"? The stored procedure is
located
in the MSDB database and can be found under the Programability - Stored
Procedures - System Procedures folder of SSMS.
2. How do I schedule a call to sp_deletebackuphistory? Can I do this
using a command script or maybe through an SQL Server Agent job?
Copy the code I posted and paste it into a Job Step in SQL Agent. You
would
create a new job just like the one you did for Backups. If the schedule
you
want to run this is each time you do a backup you can simply add a 3rd
step
to your existing job and put it there. Just make sure to change the flow
logic of the job steps. If you want a different schedule then create a
new
job with it's own schedule.
--
Andrew J. Kelly SQL MVP
Solid Quality Mentors
"Bob" <86c6c2e6-2146512712@xxxxxxxxxxxxxx> wrote in message
news:B692CD58-06EA-4CA5-980D-0669E76FAC33@xxxxxxxxxxxxxxxx
Hi Andrew,
I'm trying to backup my DPM database and DPM doesn't make this
particularly easy. I either have to have a second DPM server installed
or
I have to install a tape drive. Both of these choices are a bit more
expensive and cumbersum than simply using SQL Server to backup the DPM
database to a disk drive.
I presently use SQL Server Agent to run a daily scheduled (two step)
job
that:
1. Runs a command script that deletes backup database files older than
a
week.
2. Backs up my DPMDB to disk in a new file each day (using INIT to
ensure
no appends).
I understand now that I must use the Microsoft supplied
sp_deletebackuphistory to keep the backup system tables from growing
endlessly.
However, not knowing much of anything about SQL Server and particularly
stored procedures, can you please answer the following?
1. How do I display sp_deletebackuphistory? Is this found in MS SQL
Server Management Studio?
2. How do I schedule a call to sp_deletebackuphistory? Can I do this
using a command script or maybe through an SQL Server Agent job?
Thanks,
Bob.
- References:
- Re: How do I delete backed-up databases?
- From: GTC
- Re: How do I delete backed-up databases?
- From: Ekrem Önsoy
- Re: How do I delete backed-up databases?
- Prev by Date: Re: How do I delete backed-up databases?
- Next by Date: RE: SQL 2000 & Multiple Instances....
- Previous by thread: Re: How do I delete backed-up databases?
- Index(es):
Relevant Pages
|
