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 |
|
Liew2020
Starting Member
26 Posts |
 Posted - 2008-03-12 : 02:32:28
|
| May I know any reason why my Transaction Log Backup job keeps failing while the particular database set to "Standby /Read-Only"?Kindly help. Thank You.Regards,Jimmy Liew |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-03-12 : 07:41:42
|
| Check your recovery model of database. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-03-12 : 08:30:17
|
| You can't backup a database that is in standby/read-only. You can only restore transaction logs on top of it. For future reference, providing the error is helpful.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-03-12 : 08:43:56
|
| Is 'standby/Readonly ' related to Logshipping? IF individual databaseis set Readonly, We can do backup. But i don't know for secondary database in Log shipping . |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-03-12 : 23:42:07
|
| Yes it's for log shipping. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-03-13 : 00:33:46
|
| You can't make that assumption. A database can be in this mode without being a member of log shipping.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-03-13 : 23:53:35
|
| You can put db in that status only with restoring, usually will not do that outside of log shipping. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-03-14 : 01:18:13
|
| I already mentioned that this was for restoral purposes. But we can't make an assumption about log shipping.You can use that status when you are in a disaster situation and are restoring the data and need to take a look at the database to find out when to stop restoring logs. So it is not only in a log shipping scenario.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
|
|
|
Trans Log Failed While DB in Standby