I am new to SQL server. I have a database in my company which has grown up and occupied space more than 4 GB. It is currently holding data of past 5 years. The old data requires no update at all . Rarely, some select operations are performed on these data.
I want to backup the old data to DVD ( or other media) by freeing up the space used. And, I have to work on the old data sometimes but very rarely.