Post reply

Database Mirroring

  • September 13, 2010 at 8:13 am

    #146957

    Hello there

    I need to create an run (DOS) execution file and add parameters to it.

    ALTER DATABASE [DB] SET PARTNER FORCE_SERVICE_ALLOW_DATA_LOSS

    Can be an .vbs an .batch file please let me know something !!

    I would like run from aplication only double clik

    i have arround 10 database!

    please help me!!

  • September 21, 2010 at 11:30 am

    #1225088

    Hi

    One way to do this is using osql.exe

    http://msdn.microsoft.com/fr-fr/library/ms162806.aspx

    Create a .cmd file with your osql commands, in this case one command per database/server

    osql -Syourserver -dyourdb -E -icommand.sql -oOUTPUTFIL.txt

    Create the command.sql file with T-SQL code.

    Let us know how this works for you, hopefully you are not in too much trouble there trying to fix all those mirrors 😛

    Maxim

  • October 11, 2010 at 5:47 am

    #1234912

    Thanks For your reply,

    Task is completed.!!!!

    The process was the following, create a. bat file per database and then create a. vbs to call for each .bat file and only have to take a single click. lolz.....

    thanks a million my brother!

Viewing 3 posts - 1 through 2 (of 2 total)

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