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.
| Author |
Topic |
|
ahmeds08
Aged Yak Warrior
737 Posts |
 Posted - 2010-12-28 : 00:52:57
|
| hello everybody, when i try to restore transaction log why is it appearing in disabled mode.databasename->tasks->restore->here the Tlog is in disable mode.Thanx in advance |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2010-12-28 : 05:12:26
|
| Completely guessing because there's no where near enough information, but maybe because the database is recovered and online.What are you trying to do here and what have you done up until this point--Gail ShawSQL Server MVP |
 |
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2010-12-28 : 05:52:02
|
| To elaborate on what Gail posted:To restore a tr log you must first of all restore a full backup without recovering the database - then you can restore tr logs and finally recover to access the database.Sounds like your previous restore was recovered so you now can't add further logs.Have a look at restore in bol.==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
|
|
|
Restore TLog