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-04-27 : 07:55:57
|
| Dora writes "I have a production database which has about 200 tables. I need to create a read-only server so that the load on the server is shared between the two servers. This report server should be up to date with the production server and we cannot drop connections on the report server to restore the backups. so logshipping is not a solution for me. Is there any other solution possible ? Thank you very much in advance." |
|
|
mr_mist
Grunnio
1870 Posts |
Posted - 2005-04-27 : 08:28:46
|
| Hmm. Well if you wait until the next version then you can restore whilst a database is online I believe. Until then, maybe you could look at replication.-------Moo. :) |
 |
|
|
|
|
|
Read-Only server creation