Post reply

How can we move mdf files from one drive to another with tsql

  • May 22, 2008 at 5:31 am

    #191363

    How can we move mdf files from one drive to another with tsql i know how to do with ssms .

    Thaxxx

    Regards

    jagpal singh

  • May 22, 2008 at 5:43 am

    #819058

    Have you tried the trusty "Script action to new query window"?

    "Got no time for the jibba jabba!"
    -B.A. Baracus

  • May 22, 2008 at 5:49 am

    #819060

    yes but i need another script like in which i can attach that detach file with one script .

  • May 22, 2008 at 6:19 am

    #819077

    exec sp_detach_db ...

    exec master.xp_cmdshell 'move ...'

    exec sp_attach_db ...

    Or do you need a more detailled answer?

    Wilfred
    The best things in life are the simple things

  • May 25, 2008 at 4:22 pm

    #820083

    hi,

    thaxx for reply i know these syntax but i need more information about this .

Viewing 5 posts - 1 through 4 (of 4 total)

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