Post reply

How to backup SQL 2000 Master db from the command line?

  • May 5, 2008 at 7:02 am

    #190001

    I would like to create a batch file that backs up the master database to a file on the D: drive. I'm thinking something like ...

    SQLMaint.exe -D Master -BkUpDb D:\master.bak

    any ideas ???

    Thanks!

  • May 5, 2008 at 7:18 am

    #810647

    That looks like it should work, I'd just be cautious of the security context. Will this be executed from another application or by someone who is running it manually?

    If it's something that will executed on a schedule, why not just schedule it using the SQL agent? Additionally, to get around some of the security concerns, I'd perhaps think of creating a Sql agent job that does the backup and calling sp_startjob

    -Luke.

    To help us help you read this[/url]For better help with performance problems please read this[/url]

  • May 5, 2008 at 7:23 am

    #810652

    at the command prompt type:

    isql -SserverName -E -Q"backup database master to Disk = 'D:\backup\master.Bak' With Init "

    Sopheap

  • May 5, 2008 at 7:41 am

    #810673

    I tried your isql command and it works perfectly.

    Just what I was looking for.

    Thanks!

  • May 5, 2008 at 6:43 pm

    #810989

    🙂

    Sopheap

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

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