Backup log with norecovery

Question

Post reply

Backup log with norecovery

Steve Jones - SSC Editor

SSC Guru

Points: 736172
More actions
September 28, 2015 at 11:46 pm

#100914

Comments posted to this topic are about the item Backup log with norecovery
September 28, 2015 at 11:56 pm

This was removed by the editor as SPAM

Viewing 11 posts - 1 through 10 (of 10 total)

You must be logged in to reply to this topic. Login to reply

Hany Helmy SSChampion Points: 13921 More actions · Answer 1

I am using this a lot lately.

Thanks & Best Regards,
Hany Helmy
SQL Server Database Consultant

Ed Wagner SSC Guru Points: 287026 More actions · Answer 2

Quite interesting. It's a neat way to leave the database.

Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions

Kristen-173977 SSCrazy Eights Points: 8687 More actions · Answer 3

Gail suggested this to me a few days ago. I now think it is preferable to

ALTER DATABASE MyDatabaseName SET OFFLINE WITH ROLLBACK IMMEDIATE

which I currently use (before restoring the DB)

and much better than

ALTER DATABASE MyDatabaseName SET SINGLE_USER WITH ROLLBACK IMMEDIATE

which I used to use, but had the risk that someone other than me might grab the single user connection!

webrunner SSC-Dedicated Points: 31862 More actions · Answer 4

Thanks, good training question.

- webrunner

-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 5

Nice one, thanks.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

akljfhnlaflkj SSC Guru Points: 76202 More actions · Answer 6

akljfhnlaflkj

SSC Guru

Points: 76202

September 30, 2015 at 7:34 am

#1830426

Thanks for the question.

Ernest Libertucci Ten Centuries Points: 1394 More actions · Answer 7

Good tip, thanks!

(in reply to post about using OFFLINE instead of SINGLE_USER)

TomThomson SSC Guru Points: 104773 More actions · Answer 8

Nice question; but it's a command I hope I never have to use; another is

BACKUP LOG <database> TO <device> WITH STANDBY = <file>.

Tom

patricklambin SSCrazy Eights Points: 9994 More actions · Answer 9

Interesting question about I never used thru T-SQL.

I discovered the WITH NORECOVERY when I tested how to backup with SMO ( there is an option which permits to visualize the T-SQL code generated thru a SMO application without executing it : useful to test it )