Results 1 to 4 of 4
  1. #1
    Join Date
    Apr 2002
    Posts
    9

    Unanswered: Out of space on 6.5 DB

    Need to know how to shrink a 6.5 DB. When going inot Shrink dialog it won't let me change it to any amount less thatn what it is already set to.

    DBCC won't let me do it bc I have to be in single mode.

    Any other options? I know in 7/2K you can:
    Backup Database dbname with truncate_only and then restore the bak file.

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Wow, you're looking for a history lesson here! I'd first try to blow out the log using:
    Code:
    DUMP TRANSACTION myDB WITH TRUNCATE_ONLY
    You are correct, SQL 6.5 won't (actually can't) shrink a database unless that database is in single user mode.

    -PatP

  3. #3
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    I thought that in order to shrink a 6.5 database (device files and all, that is), was to create a new database smaller than the first, and try to import all the data in from the old.

  4. #4
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    That's one way, but dumping the log is often enough, and if you can put the database into single user mode you can shrink them. In some ways, 6.5 would allow you to do things that 2000 can't do because the 6.5 device manager is so much "simpler minded" that it can do things that aren't possible in a more sophisticated environment.

    -PatP

Posting Permissions

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