I can't able to restore the Tail Log back up..

Question

Post reply

I can't able to restore the Tail Log back up..

Chowdary's

SSCrazy

Points: 2978
More actions
April 8, 2014 at 1:34 am

#306071

Dear All,
Am Using 2008,
i have restored the full and Differential backup with norecovery model,
But when am trying to restore the log files am getting all the Log files and Tail Log also.
In that i have un select the Tail log and restored all the Logs with norecovery model.And now am trying to restore the Tail Log File,But along with Tail Log all the Tlog files are coming ,Here i can't able to select the TailLog,If i select only Tail log form available logs automatically all the normal logs are selecting,Here i want to restore only Tail Log File because i have restored the logs with norecovery model.
Regards
Jagadeesh
Regards
Chowdary...

Viewing 7 posts - 1 through 6 (of 6 total)

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

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 1

Use T-SQL.

RESTORE LOG ....

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
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

Chowdary's SSCrazy Points: 2978 More actions · Answer 2

Thank U For Giving Reply Sir,

Sir i have a question i.e.

Suppose i have 10 log files and the tail log along with that ,In that case if i use T-Sql to Restore the log whethet i can get all the logs and tail log will get Restore or not?

Regards

Jagadeesh...

Regards
Chowdary...

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 3

Yes, you can use T-SQL to restore multiple log backups.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
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

Chowdary's SSCrazy Points: 2978 More actions · Answer 4

Thank U Sir,

If I want to restore Log Files and Tail Log Backup separately

Ex:-

Suppose am having 4 logs and tail log ,

In that i need to restore first 4 logs then lastly tail log backup with recovery mode.but while trying to select the last log i.e Tail log backup along with that all the Previous logs are coming.

here am getting confusion while taking tail log back up need to specify the separate path for that file with separate name like 'e:\backups\taillog.trn' ?

Please give me some clarity on log and tail log restoration..

Regards

Jagadeesh..

Regards
Chowdary...

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 5

Don't use the GUI

Do your restores with T-SQL statements. Restore the normal log backups, in sequence, with norecovery, then restore the tail log backup. Extension is irrelevant, SQL doesn't care what you call your backups.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
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

Chowdary's SSCrazy Points: 2978 More actions · Answer 6

Thank U very much Sir,

Now Am able to restore the logs with T-SQL commands

Thank u..

Regards

Jagadeesh..

Regards
Chowdary...