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.

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 DB Backups

Author  Topic 

Reedar
Starting Member

6 Posts

Posted - 2008-09-11 : 06:41:56
Hi Guys,

Not sure if this is the right place.... But here goes.

I have inheritied several SQL 2000 DBs at work. Now I know with the various DBAs that have worked here over a course of time that there are various backup routines scheduled which seem to write the log and file backups to several different places on different days and times.

Basically it's a mess!

What I'm looking for is a way to identify all the backup activities which take place. Ideally then to cancel/delete them and replace with a singular updated schedule to avoid all the current duplication.

Is this possible?

I'm running EM/QA 2000.

Thanks in advance

Reedar

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-09-11 : 12:45:32
You might find my routines useful. They are used by many people around the world.

My backup routine:
http://weblogs.sqlteam.com/tarad/archive/2008/08/19/Backup-SQL-Server-Databases.aspx

All of my database maintenance routines:
http://weblogs.sqlteam.com/tarad/archive/2004/07/02/1705.aspx

Here's what my production environments look like:
http://weblogs.sqlteam.com/tarad/archive/2008/06/30/SQL-Server-jobs-on-production-instances.aspx

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

Reedar
Starting Member

6 Posts

Posted - 2008-09-15 : 03:49:17
Many thanks for that tkizer, I'll make sure I have a read.

Just so long as I find a way to identify the current arrangements and delete them first I should be fine.

Thanks again.

Reedar
Go to Top of Page
   

- Advertisement -