SQL Server Performance

mdfs and ldfs

Discussion in 'Getting Started' started by lara99, Aug 20, 2008.

  1. lara99 New Member

    hi all i am trying to move 800 gigs of mdfs and ldfs from one location to another location.
    can u guys please suggest what is the fastest medium to write those file,
    should it be a tape drive or a disk drive or a pen drive. or there is some thing else please suggest.
    thans
    lara99, Aug 20, 2008
    #2

  2. Luis Martin Moderator

    Other location means other server?
    Luis Martin, Aug 21, 2008
    #3

  3. melvinlusk Member

    Do you have gigabit ethernet? If so, just copying the files across the network is what I would do.
    melvinlusk, Aug 21, 2008
    #4

  4. shivjagdale New Member

    hi,
    I think database detatch and attach option is good for this specific purpose....
    Thanks,
    Shivaji Jagdale
    shivjagdale, Aug 22, 2008
    #5

  5. moh_hassan20 New Member

    [quote user="lara99"]
    i am trying to move 800 gigs of mdfs and ldfs from one location to another location.
    [/quote]
    Is the new location within LAN or other Remote site ?
    Is the current database storage on SAN /or RAID array or local drive?
    moh_hassan20, Aug 22, 2008
    #6

  6. Luis Martin Moderator

    To many answerers for to many feedback.[:(]
    Luis Martin, Aug 22, 2008
    #7

  7. lara99 New Member

    thanks for many responses, I am on remote site and i am using detach and attach for now, do you guys please suggest what are the different things i have to take care of, like do I have to create indexes, do I have to create the users again. please suggest.
    Thanks all.
    lara99, Aug 23, 2008
    #8

  8. Luis Martin Moderator

    Only users and jobs.
    For that take a look in Microsoft web.
    Luis Martin, Aug 24, 2008
    #9

Share This Page