September 28, 2015 at 11:46 pm
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
September 29, 2015 at 1:24 am
I am using this a lot lately.
Thanks & Best Regards,
Hany Helmy
SQL Server Database Consultant
September 29, 2015 at 5:47 am
Quite interesting. It's a neat way to leave the database.
September 29, 2015 at 6:05 am
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!
September 29, 2015 at 8:27 am
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
September 30, 2015 at 3:43 am
Nice one, thanks.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
September 30, 2015 at 7:34 am
Thanks for the question.
September 30, 2015 at 11:58 am
Good tip, thanks!
(in reply to post about using OFFLINE instead of SINGLE_USER)
September 30, 2015 at 1:29 pm
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
October 7, 2015 at 9:34 am
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 )
Viewing 11 posts - 1 through 10 (of 10 total)
You must be logged in to reply to this topic. Login to reply