Post reply

Command for adding new drives?

  • August 27, 2015 at 2:44 pm

    #1822930

    JaybeeSQL (8/27/2015)

    GilaMonster (8/26/2015)

    That would be a far better question, because there's no SQL command to add drives to a server. 😉

    Firstly, you don't want to move the binaries, as that would require a reinstall of SQL. To move database files, ALTER DATABASE ... MODIFY FILE, then take the DB offline, move the files (via Windows Explorer), bring the DB back online

    Was always going to let the binaries stay put on C:\, I think MS still recommend they reside on the same drive as the OS.

    Couple of further questions please....

    Should the system databases be best moved in any particular order?

    Any objection however to scripting out the file move part?

    Leave the system dbs not much point in moving them as already stated, for help moving the user database files see my article at this link[/url]

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • September 1, 2015 at 8:04 am

    #1823637

    Hi all,

    Management want this tested - don't ask why, there's no gain except getting a baseline - but it's a Profiler trace, pre-and-post disk additions.

    Gila recently suggested the T-SQL Replay template for another matter - ok to use for this test?

Viewing 2 posts - 16 through 16 (of 16 total)

You must be logged in to reply to this topic. Login to reply