Reset Database

I am fairly new to SQL 2000. I have a program called Websense that monitors
all internet traffic and records it to a SQL database. The database is
growing, and I want to reset it every 2 months just to keep it relatively
small, but I don't know the best way to do this. Should I manually do a
backup of the database after 2 months, and then re-create the database fresh
or is there a more efficient way? I also want to have a backup of the
database for an indefinite period of time just in case I need to restore a
previous copy.Yes you could make a full backup of the database, and then truncate the
tables.
The following article will get you started with implementing an archive
plan: http://vyaskn.tripod.com/sql_archive_data.htm
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
What hardware is your SQL Server running on?
http://vyaskn.tripod.com/poll.htm
"Allison" <no@.email.com> wrote in message
news:edpWWobuDHA.1060@.TK2MSFTNGP12.phx.gbl...
I am fairly new to SQL 2000. I have a program called Websense that monitors
all internet traffic and records it to a SQL database. The database is
growing, and I want to reset it every 2 months just to keep it relatively
small, but I don't know the best way to do this. Should I manually do a
backup of the database after 2 months, and then re-create the database fresh
or is there a more efficient way? I also want to have a backup of the
database for an indefinite period of time just in case I need to restore a
previous copy.|||Hi Allison,
My name is Michael and I would like to thank you for using Microsoft
newsgroup.
I agree with Vyas that you need to archive data from the database for the
purpose of keeping your database small. The suggestion in the article
provided by Vyas looks good. My only concern is that I am not quite clear
what your restore requirements are. Can you describe it in detail? What do
you mean by "indefinite period of time"?
As I understand, when the database is fully backed up from the data of the
last 2 months, it is hard to restore the data in the backup files together.
For example, last 4 months data or last 6 months data will be hard to
restore. You can only restore one backup file within the 2 months data to
the current database each time. Have I addressed your concern correctly?
For more information regarding this issue, please refer to the following
articles:
329833 Support WebCast: Microsoft SQL Server 2000: Understanding Backup and
http://support.microsoft.com/?id=329833
325257 Support WebCast: SQL Server 2000 Database Recovery: Backup and
Restore
http://support.microsoft.com/?id=325257
I am standing by for your response.
Regards,
Michael Shao
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.