dump transaction - SQL Server Forums

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 2008 Forums

Transact-SQL (2008)

dump transaction

Author

Topic

wided
Posting Yak Master

218 Posts

Posted - 2011-05-27 : 11:18:25

hi
to empty the transaction log, I do this:
DUMP TRANSACTION BDI WITH NO_LOG
on SQL 2008, I have a syntax error:

how to write it on sql2008

thanks

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2011-05-27 : 11:24:57

DUMP has been deprecated for a few versions. We now use BACKUP. DUMP was for SQL Server 6.5 and lower, although it still worked for a few more versions.

But don't truncate the transaction log! Instead back it up. Consider switching your recovery model if you find yourself truncating the log.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

wided
Posting Yak Master

218 Posts

Posted - 2011-05-27 : 11:32:23

thanks tara

but, How to change the recovery model

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2011-05-27 : 11:36:55

You can do it with ALTER DATABASE or via the GUI (right click the database, properties, and then options). You'll likely want SIMPLE recovery model. But you do need to understand the different recovery models in order to pick the one that fits your needs.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2011-05-27 : 12:30:13

Please read through this - [url]http://www.sqlservercentral.com/articles/64582/[/url]

--
Gail Shaw
SQL Server MVP

wided
Posting Yak Master

218 Posts

Posted - 2011-05-27 : 12:33:54

my database is now restored, I have no choice, I have to empty the journal

I must save and restore?

I have no other choice?

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2011-05-27 : 12:36:10

Empty the journal? What do you mean you have no choice? You haven't explained your problem yet.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

wided
Posting Yak Master

218 Posts

Posted - 2011-05-27 : 12:41:45

I'm sorry tara, I posted my question on the forum administration

message received

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources