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 |
|
coolerbob
Aged Yak Warrior
841 Posts |
 Posted - 2008-05-16 : 06:35:03
|
| I think I've read some conflicting advice in BOL. Maybe someone can clarify it for me.Under "Database Mirroring and Database Snapshots" it says:"You can take advantage of a mirror database that you are maintaining for availability purposes to offload reporting. To use a mirror database for reporting, you can create a database snapshots on the mirror database and direct client connection requests to the most recent snapshot"To my mind, to enjoy a noteworthy performance gain, that mirror database would need to be on another server. But then you read under "Database Snapshots":"Multiple snapshots can exist on a source database and always reside on the same server instance as the database."So how do you get the snapshot to the mirror? |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2008-05-16 : 09:30:25
|
| the word snapshot is being used in different context...loosely interpreted, it means a copy at the point the action was done--------------------keeping it simple... |
 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-05-16 : 10:13:28
|
| They are just the snapshot of database. You can use it for reporting purposes in mirroring database. you can have multiple database snapshot in Mirror server. It is empty in the beginning but as database pages gets updated and modified m it takes up spaces. Remember you can't modify database snapshot. |
|
|
|
|
|
|
Mirroring & Snapshots?