Results 1 to 2 of 2
  1. #1
    Join Date
    May 2007

    Unanswered: Backing up SQL server database.

    hi all,

    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.

    How can I do this?

    Thanks in advance.

  2. #2
    Join Date
    Mar 2003
    Reading, UK
    Move the data into archive tables and import those tables into a new database and take their backup.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts