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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-09-02 : 07:27:55
|
| Gary writes "Hi,We are using SQL Server 2000 Enterprise Edition on Windows 2000 Advanced Server.Log shipping has been set up on one of our production databases. The destination database is set to read only and able to restore transaction logs. It is used for generating Web reports.Our Web developer created a new report that uses a LEFT JOIN query, which requires the several additional indexes to boost performance.Is there a way we can create the new indexes on the destination server without bring it back online? Or is it possible to create the indexes on the original server and have them "shipped" to the destination database?Thanks in advance for your help.Gary K." |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2005-09-02 : 07:29:27
|
| You'd have to create them on the original server if you wanted to keep the log shipping destination in standby/read-only mode. |
 |
|
|
|
|
|
Create indexes on logged shipped read only server?