BACKUP LOG AdventureWorks WITH TRUNCATE_ONLY - Backup, Recovery and Disaster Recovery

Member of the LearnItFirst.com Video Training Network	\| LearnSqlServer.com \| SQL SSIS Training \| SQL Programming Tutorials \|

Welcome Guest

Search | New Posts | Members | Log In | Register

LearnSqlServer.com's SQL Server Forums » SQL Server Database Administration » Backup, Recovery and Disaster Recovery » BACKUP LOG AdventureWorks WITH TRUNCATE_ONLY

BACKUP LOG AdventureWorks WITH TRUNCATE_ONLY

Options

Previous Topic · Next Topic

wdismukes

Posted: Sunday, August 10, 2008 3:51:48 PM

Rank: PFY

Joined: 5/3/2007
Posts: 20
Points: -37
Location: Houston, Texas

BACKUP LOG AdventureWorks WITH TRUNCATE_ONLY no longer works in SQL Server 2008.
Bummer!!!
What else has Bill Gates done to make my life easier?? Roll Eyes (Sarcastic)

Scott Whigham

Posted: Sunday, August 10, 2008 4:19:37 PM

Rank: Super Mod

Joined: 3/20/2006
Posts: 345
Points: 748
Location: Dallas, TX

Yeah, it was deprecated in 2005 and I still haven't heard a logical reason. AFAIK there's no quick way to get out of an emergency situation in which your log file has completely filled up and you don't have the disk space to back it up Frown

Users browsing this topic

Guest

Forum Jump

You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.