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 |
|
pithhelmet
Posting Yak Master
183 Posts |
 Posted - 2008-10-22 : 10:54:13
|
| Hi Everyone,The request has come across that the executives would like to perform operations on data at a certain point in time.Currently, we do not have any temporal methodologies in place to go back in time and perform a query on the data at that point in time.Restoring backups is a complete waste of time - IMOrestore data from last year for a simple query is not a good roi for a dba.SOOO - Is it possible to take a snapshot of the database(s) daily, and move them offline into a near-line medium and allow a user to "check out" the data and place it into the archive server for retrieval?OR, I read a little about partitioning and heard that you can create a partition for each month, and on the last day, create a new partition for the new month???anyone have any comments on these ideas? |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-10-22 : 11:40:00
|
| It will take same amount of time to restore if you use database snapshots. You should be careful while restoring database from database snapshots as it can revert original database and this is not good option. Table partitioning or Partition views will be best in your scenerio as you partition based on Partitioned month and you can split old partition to archive tables. |
 |
|
|
|
|
|
Snapshot or partitioning