LearnItFirst User Forum

Welcome Guest

Search | New Posts | Members | Log In | Register

SQL Server Forum - LearnItFirst.com » 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: 24
Points: -22
Where do you live?: 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: 476
Points: 1,053
Where do you live?: 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

wdismukes

Posted: Sunday, January 04, 2009 1:16:52 PM

Rank: PFY

Joined: 5/3/2007
Posts: 24
Points: -22
Where do you live?: Houston, Texas

If I had watched your LearnSQLServer2008 tapes I would have known that. Also, I now know how to get around a full Transaction Log in SQL Server 2008! (I still prefer TRUNCATE_ONLY.) Great job. Lots of good information.

sreekanthbandarla

Posted: Sunday, March 14, 2010 2:50:18 PM

Rank: Newbie

Joined: 3/14/2010
Posts: 0
Points: 3
Where do you live?: Dallas, Tx

Then what's the use for "Switching to SIMPLE Recovery or simply take a tran log Bakup wuth default options". This works great right!

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.