March 12, 2003 at 3:34 pm
I have a database on SQL Server 2000.
Due to space restriction, i have to empty the database every week to create space/room for new data to get stored. But i also wanna save somewhere the data which is to be taken out every week. What should be best strategy to do this ?.
I mean should i backup the database or export etc ?.
Thanks very much in advance.
Mack
March 12, 2003 at 9:35 pm
Both have their own advantages:
Backup : If you have only one table which is big, backup might be a better option. One of the reason being that you can query system tables and get the location of the backup file. You can backup over the network also to some other location.
File : You might be able to save space by sending data to a file but you would have to manually keep track of all the files. you can always script the same and keep a record but if it is one big table, i might go for the prior option.
Hope someone else can also suggest something better.
March 13, 2003 at 2:35 am
No easy answers, depends on disk space available. If you have restrictions for the database, ie cannot create new table, copy & delete then your only choice is to export the data offline. I would look at the life time expectancy of your data to decide how to offline the data. I personally would export the data as text and backup to magnetic media. The reason for this would be possible future upgrades of SQL and their compatibility. For instance, a year later you want to retrieve data, can you guarantee that the backup is still compatible?
Far away is close at hand in the images of elsewhere.
Anon.
March 13, 2003 at 3:59 am
I would say it depends most on how long you need to retain the data. If a short period like a few years then a backup should suffice. If however it needs to be permanently retrieveable then I would export to a text file to ensure in 10/20/30 years it should be fully reteiveable (don't see text changing much).
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply