SQL Server Issue

Discussion in 'NZ Computing' started by Kach, May 13, 2004.

  1. Kach

    Kach Guest

    We're running SQL Server 2000 Personal Edition on laptop.
    It's actually used in mobile location as a server,
    where a desktop is also hooked to the SQL Server.
    Every week, the laptop is brought back to replicate with the main server.

    Unfortunately, the laptop is running out of space,
    and adding another internal hard drive is out of the question.

    Anyone knows what kind of performance impact will there be
    if we connect USB 2.0 drive to the laptop?
    Is it safe to write the transaction log to the USB drive,
    while the database remain on the internal drive?

    How about making use of the desktop hard disk space?

    Thanx
    Kach
    Kach, May 13, 2004
    #1
    1. Advertising

  2. Kach

    Steve Guest

    Kach wrote:
    > We're running SQL Server 2000 Personal Edition on laptop.
    > It's actually used in mobile location as a server,
    > where a desktop is also hooked to the SQL Server.
    > Every week, the laptop is brought back to replicate with the main server.
    >
    > Unfortunately, the laptop is running out of space,
    > and adding another internal hard drive is out of the question.
    >
    > Anyone knows what kind of performance impact will there be
    > if we connect USB 2.0 drive to the laptop?
    > Is it safe to write the transaction log to the USB drive,
    > while the database remain on the internal drive?
    >
    > How about making use of the desktop hard disk space?
    >
    > Thanx
    > Kach
    >
    >
    >
    >

    Hi Kach,

    As with all 2.5inch disks, it's the drives themselves that are the
    limiting factor. I doubt that you'll see any difference at all between
    the internal and external drives. In fact, if you share your database
    across the two, things may actually improve.

    As long as it _is_ USB 2.0, of course!


    Good luck,

    Steve
    Steve, May 13, 2004
    #2
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Brian Whiting
    Replies:
    2
    Views:
    692
    Brian Whiting
    Dec 29, 2005
  2. Aibak
    Replies:
    3
    Views:
    4,230
    Aibak
    Apr 8, 2004
  3. Tommy
    Replies:
    1
    Views:
    1,765
    Mr. Arnold
    Nov 29, 2007
  4. Vicky
    Replies:
    0
    Views:
    666
    Vicky
    Apr 6, 2007
  5. Replies:
    0
    Views:
    1,430
Loading...

Share This Page