Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in

Content with tag archiving Rss

   Items 1 to 6 of 6   

An Automated Process to Archive Big Tables

Many databases have large tables with hundreds of millions of rows. However, many of these tables are simply keeping a log or history data that can be archived and kept outside the user database in a special archive database.   Read more...
By Leo Peysakhovich 2013/07/10 | Source: | Category: archiving
Rating: |  Discuss |   Briefcase | 6,811 reads

Archiving SQL Server Data Using Partitioning

Many companies now have a requirement to keep data for long periods of time. While this data does have to be available if requested, it usually does not need to be accessible by the application for any current transactions. Data that falls into this category are a good candidate for archival.  Read more...
By Additional Articles 2012/10/22 | Source: | Category: archiving
Rating: (not yet rated)  Rate this |   Briefcase | 3,397 reads

Keep Data Forever

Today Steve Jones talks about some of the issues with keeping data around a long time and a new archival medium.  Read more...
By Steve Jones 2011/08/25 | Source: | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 155 reads


It seems that archival isn't on the mind of most designers when they first build a database, which is OK, but DBAs ought to be building skills to implement this if the data size grows large.  Read more...
By Steve Jones 2011/06/20 | Source: | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 452 reads

Changing the Past

This Friday Steve Jones explores archived data. Can you restate past results or change old data? This week Steve Jones asks how data professionals feel about this and what guidance they give to their customers.  Read more...
By Steve Jones 2011/01/21 | Source: | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 94 reads

Function to Return Date and Time String for File Archiving

This function will return a string in sortable format YYYYMMDD-hhmmssnnn to append to file names for archiving.  Read more...
By Joshua A. Walker 2009/02/18 | Source: | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 1,400 reads
   Items 1 to 6 of 6   
editorial (3)    
archive file (1)    
date (1)    
dba (1)    
friday poll (1)    
function (1)    
miscellaneous (1)    
partition (1)    
time (1)