Results 1 to 5 of 5
  1. #1
    Join Date
    Jul 2010
    Location
    ISHHHH
    Posts
    130

    Unanswered: SQL Server 2005 max size/record limit

    I would like to know what SQL server 2005 does when it reaches the max records/size of DB. If I want to delete the records after this point, how can I program the server to delete all or some records and then start adding new ones from the begin id or start adding? What are the different ways to do it?
    WiTh Tnks & ReGaRdS
    mAtHuKuMaLi

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Eh?

    -PatP
    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

  3. #3
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,799
    Provided Answers: 11
    There is a limit to the size of a single record (exclusive of varchar/varbinary(max) columns), but I do not think there is a limit on the number of rows.

  4. #4
    Join Date
    Feb 2010
    Posts
    19
    If you're asking what I think you're asking, a DB can become full when it reaches the maximum size you specified for it. At that point it becomes read-only. You can set the server to increase the maximum file size by 10% whenever that happens, which solves the immediate problem. If you don't have the space to keep enlarging the DB, or there's some reason to keep it a constant size, you could use an alert that's tied to the "max file size reached" event. The alert can run a script that deletes some records (by ID or date or whatever)--or does anything else you need done. Create the script, create the alert, and it's Miller Time.

  5. #5
    Join Date
    Jul 2010
    Location
    ISHHHH
    Posts
    130
    actually its a dought asked by my colleague i was not clear about the question asked by me any way what i want i get it thanks all
    WiTh Tnks & ReGaRdS
    mAtHuKuMaLi

Posting Permissions

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