Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Helmars

    Black hole in backup plan?

    This has nothing to do with retention time and I'm not speaking about any particular database, now I'm just playing with test database containing 1 table. I can ask the question again: 1) full database backup; ... 2) log backup; 3) good transaction committed; 4) bad transaction committed; 5)...
  2. Helmars

    Black hole in backup plan?

    Recovery model is "full". My question was about full database backups. It seems to me that transaction logs created between a log backup and start of full database backup are just deleted. Consider this scenario: 1) full database backup; ... 2) log backup; 3) good transaction committed; 4) bad...
  3. Helmars

    Black hole in backup plan?

    Hello, I noticed that sql server 2005 database backups always truncate transaction logs, but I don't see where they go. What happens to them? I can't find a way to restore a database to a point between end of database backup and previous log backup. Is such action possible? Helm?rs

Part and Inventory Search

Back
Top