Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 Transaction log restore

Author  Topic 

raghuveer125
Constraint Violating Yak Guru

285 Posts

Posted - 2011-11-08 : 01:41:50
Hello all,

I need to restore all trasaction files with no recovery option.

I have more than 100 trn file in my G drive and I manually restored few of them now I need tsql command to restore all files wich I have not restored till.

In Love... With Me!

raghuveer125
Constraint Violating Yak Guru

285 Posts

Posted - 2011-11-08 : 03:42:41
I need command something like this


restore log [databaseName] From Disk=N'Path\*.trn' With norecovery

In Love... With Me!
Go to Top of Page

Kristen
Test

22859 Posts

Posted - 2011-11-08 : 04:19:21
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=101995
Go to Top of Page

raghuveer125
Constraint Violating Yak Guru

285 Posts

Posted - 2011-11-08 : 07:09:24
Thanks


In Love... With Me!
Go to Top of Page
   

- Advertisement -