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!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by 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)...- Helmars
- Post #5
- Forum: Microsoft SQL Server: Setup and Administration
-
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...- Helmars
- Post #3
- Forum: Microsoft SQL Server: Setup and Administration
-
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- Helmars
- Thread
- Replies: 6
- Forum: Microsoft SQL Server: Setup and Administration
