Results 1 to 4 of 4
  1. #1
    Join Date
    Sep 2007
    Posts
    1

    Question Unanswered: Export or Backup with SQL Server 2000

    Hi All
    I am using Sql Server 2000.
    The database is being used since 5 years and the transaction file (mdf) has increased upto 12Gb.
    We are thinking of reducing the size of the database and keeping only the data of the past 1 year. So I would like to know if there is some way of backup or export so that I can get latest 1 year data.
    Thanking You All

  2. #2
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    Strictly speaking, no SQL Server tool will do what you have in mind. You will have to go through each table, and determine what needs to stay, and what needs to go. In most systems, this boils down to a few "transactional" tables (the classic examples being orders or invoices), while most of the other tables can be left alone. The problems come about when you ask the business "Should we keep customer information for customers who have not ordered in the last year?"

  3. #3
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    now I have to wipe my margari....ah, coffe, off of my monitor

    How big is the database itself? 5 mg?
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  4. #4
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Let me ask, did you hear NPR this morning?

    Are you 1 of the 10 people they get for my services for the same price?

    Well worth it

    5 years with no backup...
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

Posting Permissions

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