APD Toronto
asked on
MSSQL Dump
Hi Experts
Does MS SQL have a dump all databases, similar to the following in MySQL:
Thank you
Does MS SQL have a dump all databases, similar to the following in MySQL:
mysqldump --opt --all-databases -r c:\mysql_dump.txt -u root -p123
Thank you
bcp http://technet.microsoft.com/en-us/library/ms162802.aspx
ASKER
But, here you specify the db name. My goal is for ALL databases (present & future)
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
got it, was missing my \ in my path.
Final step... I saved the above as backup.sql, now how can I execute it from a batch file? I think I need to use sqlcmd but how do I specify the script file, user, password?
Final step... I saved the above as backup.sql, now how can I execute it from a batch file? I think I need to use sqlcmd but how do I specify the script file, user, password?
I don't know. Click on "Request Attention" above to get more people to look at your question.
ASKER
figured out o my own.