Post reply

Script to Create 100 Databases

  • June 17, 2003 at 10:13 am

    #461774

    It ran successfully! 🙂

    Thank you very much, Everett, for all your assistance.

    WM

  • June 17, 2003 at 10:48 am

    #461785

    One last question, Everett:

    How do I create a dump device for each database in the script?

    Thank you.

    WM

  • June 17, 2003 at 11:55 am

    #461791

    Hello.

    I unfortunately don't have any experience with the DUMP command beyond BOL which suggests it shouldn't be used (GURUS: IS THIS TRUE FOR A ONE TIME SHOT?).

    I ran the following script using the BACKUP command, it could probably be modified to use the DUMP command

    declare

    @BackUpvarchar(500),

    @DatabaseNamevarchar(500)

    Set @DatabaseName = 'Northwind'

    Set @BackUp = 'EXEC sp_addumpdevice ''disk'', ''' + @DatabaseName +

    ''', ''d:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\' + @DatabaseName + '.dat''' + CHAR(13) +

    'BACKUP DATABASE ' + @DatabaseName + ' TO ' + @DatabaseName

    exec(@BackUp)

    Everett

    Edited by - ewilson10 on 06/17/2003 11:58:18 AM



    Everett Wilson
    ewilson10@yahoo.com

  • June 17, 2003 at 2:31 pm

    #461821

    Thanks again for your help, Everett.

    I got it to work.

    WM

Viewing 4 posts - 16 through 18 (of 18 total)

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