Tail bak up

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » Tail bak up

Tail bak up

Rate Topic

Display Mode

Topic Options

Author

Message

ramyours2003

Posted Monday, January 21, 2013 4:23 AM

Old Hand

Group: General Forum Members
Last Login: Today @ 8:47 AM
Points: 359, Visits: 1,487

Is it possible to take Tail backup after the full backup ?

Post #1409473

sanket kokane

Posted Monday, January 21, 2013 4:25 AM

Old Hand

Group: General Forum Members
Last Login: Yesterday @ 5:04 AM
Points: 323, Visits: 966

yes..

Backup log dbname to disk ='path' with norecovery

-----------------------------------------------------------------------------
संकेत कोकणे

Post #1409474

GilaMonster

Posted Monday, January 21, 2013 5:13 AM

SSC-Dedicated

Group: General Forum Members
Last Login: Today @ 1:59 PM
Points: 37,741, Visits: 30,018

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 »

Permissions