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
 SQL Server Administration (2000)
 List available trans logs in QA ???

Author  Topic 

loiter99
Starting Member

38 Posts

Posted - 2004-06-28 : 12:54:44
Is it possible to list the available transaction log backups from the QA interface just as you can from the EM restore DB wizard?

TIA

J

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2004-06-28 : 13:36:53
Yes, just pull the information from the backup system tables in the msdb database. To see the ERD for these tables, download the map from here:

http://www.microsoft.com/sql/techinfo/productdoc/2000/systables.asp

Tara
Go to Top of Page

loiter99
Starting Member

38 Posts

Posted - 2004-06-28 : 15:25:12
This is perfect.

Now, how do I clear out old information? I have my backups only keeping 1 day on the server, but the msdb has reference to files that don't exist anymore because they were overwritten. How do I update MSDB so I am not backing up invalid or old information?

TIA
J
Go to Top of Page

Kristen
Test

22859 Posts

Posted - 2004-06-28 : 15:35:58
Been there, done that, got the T shirt, and got burned too :-(

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=36201

Kristen
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2004-06-28 : 15:37:51
I was just about to post that thread as well.

Tara
Go to Top of Page
   

- Advertisement -