Hello, I would like to apologize in advance ... I am a software developer, not even close to a DBA. I know little to nothing about anything that isnt' a table, view or stored procedure. That being said, I am being asked by my employer, to act
as a DBA for a customer of ours. The problem is that they only want 30 days worth of data to exist at a time within our current database, and they want to archive all other data into another location, preferably on a removable storage device that can
be swapped out as it fills up.
I have no earthly clue as to what is available in the world of SQL server. But I can tell you that almost anything that does exist probably doesn't exist for this particular customer as they seem to be using SQL server 2000.
Most everything I get when I google is talking about 2005 and 2008 SQL server, and file groups and a bunch of other stuff which doesn't seem like even if i had 2005 or 2008 would even be practical for what our customer is trying to accomplish. Our
customer wishes to offload this data in such a way that it can be restored should they need to ever use it again .. but not in a way in which it is completely integrated with SQL server. I don't know, almost like a data dump into some sort of log file
that can be read back in to a temp table or something? I am not quite sure what is
View Complete Post