Results 1 to 5 of 5
  1. #1
    Join Date
    Feb 2004
    Posts
    93

    Unanswered: how to increase tablespaces in Sql server

    Can someone tell me how to increase tablespaces in SQL Server?

    Is the syntax the same as Oracle? Is there a wizard in Enterprise Manager?

    Cheers
    Cheers
    Etravels

  2. #2
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    There is no concept of tablespaces in sql server...

    well ok, if you consider creating separate file structures...then that would be close....

    what are you trying to do?
    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.

  3. #3
    Join Date
    Feb 2004
    Posts
    93

    cheers--

    hiya

    Yeh, I figured that (as in oracle you can increase the size of the tables),

    The disk is 99% full (DB) and we are installing a new disk. We would like data to be written to the new disk (this is a temporary measurement until we upgrade the server) How do we set Map the data across?

    Cheers
    Cheers
    Etravels

  4. #4
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Dump and Restore?
    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.

  5. #5
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    The data for database files is written in parallel, while for log files sequencially.
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

Posting Permissions

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