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 |
|
maramusa
Starting Member
2 Posts |
 Posted - 2010-02-01 : 08:23:40
|
| IN SQL Server 2005 Management Studio, I want to try restoring a database with Transaction Logs.However, when I right click on the database, select Tasks - Restore - then only 'database' and 'Files and FileGroups' can be selected. The option for 'Transaction Log' is there, but its greyed out...cant select it.I know you can do this in t-sql, but I want to use the Management Studio.Cheers |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-02-01 : 08:56:21
|
| whats the recovery model of db? |
 |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-02-01 : 11:24:49
|
| Either the database is in simple recovery mode, or the log chain is broken, or you restored full with recovery. |
|
|
|
maramusa
Starting Member
2 Posts |
Posted - 2010-02-02 : 06:38:37
|
| Oh yeah, thank you very much.Actually I just tried to test some disaster recovery by restoring the transaction logs after restoring the database full backup , and got the error 'The log or differential backup cannot be restored because no files are ready to rollforward'.After googling this error I found that the database backup needs to be set No Recovery....so now it all fits together..and I see the light.So for any others, you must set the database the database backup as No Recovery, then when you do a recovery with Transaction logs, only the last transaction log should be set to Recovery. |
|
|
|
|
|
|
Cant Select Restore by Transaction Log -greyed out