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 |
|
thaniparthi.rao
Yak Posting Veteran
96 Posts |
 Posted - 2008-04-02 : 14:44:29
|
| In log shipping while restoring the transaction log backups on secondary server can users be allowed to read the data on secondary server for reporting purpose |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-04-02 : 14:48:31
|
No.You can read after restore is complete only if you restore with standby option.Was this question asked also in interview? Mr Thaniparthi |
 |
|
|
thaniparthi.rao
Yak Posting Veteran
96 Posts |
Posted - 2008-04-02 : 14:54:50
|
| yes.while restoration process can we acess the database. |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-04-02 : 15:02:20
|
| How many times you ask same question? I already said you that you can't access database while restoring ? In enterprise edition in SQL server 2005 you can have online restore but i donno if it works with log shipping.? Read BOL. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-04-02 : 22:41:46
|
| User may access secondary db before or after log restoring, not in middle of restoring. |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-04-02 : 23:36:40
|
| you can delay restoring in Logshipping and run at certain times in Log shipping but you won't get updated infomation. |
|
|
|
|
|
|
log shipping