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 |
|
tpowell_3557
Starting Member
9 Posts |
 Posted - 2008-04-14 : 14:56:23
|
| We are considering using a DB Snapshot for our warehouse when we migrate to SQL 2005. Since the DW is updated only once a month it appears a perfect fit. However, our third party querying tool says: "Querying still might be possible. However we do not officially certify this on any versions of (our product)". This may be over-cautious but I don't want to have issues with our DW. What is your experience? Are snapshots as transparent to the client applications as they seem or do you know of issues?Tom |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-04-14 : 22:53:33
|
| Our in-house app queries db snapshot and works fine. But why use snapshot if db is updated monthly? |
 |
|
|
tpowell_3557
Starting Member
9 Posts |
Posted - 2008-04-15 : 09:30:35
|
| We do all the load processing into a staging DB, run checks against it, and then backup and restore to the DW. The backup and restore takes about 5 hours. By using a snapshot we can eliminate that 5 hours of downtime. Thoughts?Tom |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-04-15 : 22:36:23
|
| That may generate lot of disk activities during data loading, since sql has to copy pages to snapshot first before changing them. By the way, backup staging db shouldn't take down DW. |
|
|
|
tpowell_3557
Starting Member
9 Posts |
Posted - 2008-04-16 : 08:22:13
|
| You're right of course about the backup, fuzzy communication on my part. About the changes though, our DW is essentially static during the month. It takes an act of congress for a change mid-month so we aren't concerned about the write overhead. However, it sounds like you are hesitant about DB snapshots. Are they as transparent as advertised? Have you had problems? I'd appreciate any inputs.Tom |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-04-16 : 22:04:20
|
| Yes we have issues with snapshot, server has 1450 os error on snapshot when load data to source db. Still working with Microsoft on the issue now. |
|
|
|
tpowell_3557
Starting Member
9 Posts |
Posted - 2008-04-17 : 08:46:46
|
| Hope it works out.Tom |
|
|
|
|
|
|
Database Snapshot