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 2012 Forums
 Transact-SQL (2012)
 DUMP A LOG FILE

Author  Topic 

wided
Posting Yak Master

218 Posts

Posted - 2014-02-20 : 11:51:40
Hello,

I have a database that has become enormous.

I trvaillé before with the old version of SQL and I used the command:

DUMP TRANSACTION WITH DBNAME no_log

Then I use the instruction

Shrink Database

With vesion 2008, I have not found the equivalent of instruction DUMP

I already posted this problem and told me that I should save the database with simple recovery. But I can not do this operation


Thank you for helping me.

James K
Master Smack Fu Yak Hacker

3873 Posts

Posted - 2014-02-20 : 13:02:46
You have only two choices:

1. Change the recovery model to SIMPLE (which you said you cannot)

or

2. Backup the log file (and schedule regular log backups).

In either case, after you have done it, shrink the log file to some reasonable size.

Exact instructions to do either of these should be available if you google for it, but if you need more help, post back.
Go to Top of Page
   

- Advertisement -