May 5, 2008 at 7:02 am
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
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.
May 5, 2008 at 7:23 am
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
I tried your isql command and it works perfectly.
Just what I was looking for.
Thanks!
May 5, 2008 at 6:43 pm
🙂
Sopheap
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply