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 bak up Expand / Collapse
Author
Message
Posted Monday, January 21, 2013 4:23 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Saturday, September 6, 2014 3:15 AM
Points: 524, Visits: 2,026
Is it possible to take Tail backup after the full backup ?
Post #1409473
Posted Monday, January 21, 2013 4:25 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, August 1, 2013 10:17 AM
Points: 323, Visits: 984
yes..


Backup log dbname to disk ='path' with norecovery 



-----------------------------------------------------------------------------
संकेत कोकणे
Post #1409474
Posted Monday, January 21, 2013 5:13 AM


SSC-Dedicated

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

Group: General Forum Members
Last Login: Yesterday @ 3:43 PM
Points: 39,866, Visits: 36,206
Of course.

A tail log backup is one that's taken either with the notruncate option (if the database is damaged) or the norecovery option (if you want to switch the DB into restoring state in order to restore over/elsewhere without losing transactions)



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 #1409501
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse