Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

tail log backup Expand / Collapse
Author
Message
Posted Tuesday, July 2, 2013 10:30 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, July 3, 2013 12:59 PM
Points: 7, Visits: 14
when do we take tail-log backup? and how can we take? wt cmds to be used
Post #1469842
Posted Wednesday, July 3, 2013 1:08 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 1:01 PM
Points: 42,432, Visits: 35,486
When your database is damaged and you are trying to do a last-ditch backup of the log before starting restoring over it, or when for other reasons you're restoring or moving a DB and want to ensure that no transactions are lost.

It's a backup log command. WITH NO_TRUNCATE if the log is damaged, with NO_RECOVERY if it's not.



Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1469866
Posted Wednesday, July 3, 2013 12:07 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, July 3, 2013 12:59 PM
Points: 7, Visits: 14
thankyou
Post #1470187
Posted Wednesday, July 3, 2013 1:41 PM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 12:22 PM
Points: 5,973, Visits: 12,873
you would use the norecovery option on a log backup when you want to swap primary and secondary roles in a logshipping set up without needing to reinitialise from a full backup.

---------------------------------------------------------------------

Post #1470209
Posted Wednesday, July 3, 2013 3:09 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Today @ 12:05 PM
Points: 36,710, Visits: 31,158
manikanta1207 (7/2/2013)
when do we take tail-log backup? and how can we take? wt cmds to be used


This sounds like a series of interview questions. My recommendation is that Gail's good answer has given you the end result but you need to readup about backups and TailLog backups in Books Online. Just in case you don't know what "Books Online" is, open SSMS then press the {f1} key and you're there (is the SQL Server "help" system).


--Jeff Moden
"RBAR is pronounced "ree-bar" and is a "Modenism" for "Row-By-Agonizing-Row".

First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column."

(play on words) "Just because you CAN do something in T-SQL, doesn't mean you SHOULDN'T." --22 Aug 2013

Helpful Links:
How to post code problems
How to post performance problems
Post #1470245
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse