Does anyone know if there is a way to run a command at the DOS prompt
to make a complete flat file (.bak) backup of a database? I know you
can do this using the enterprise manager by right clicking on the
db..., but I am curious to find out if I can add a command into my
batch scripts as part of my code migration procedures?
Thanks!
-Mike
You could use osql e.g.
osql -Q "BACKUP DATABASE pubs TO DISK = 'e:\backups\pubs.bak'" -E
Ray Mond
|||Yes, Ray, Perfecto!! That's what I was looking for. Thanks for the
help...
Happy Holidays!!
Showing posts with label promptto. Show all posts
Showing posts with label promptto. Show all posts
Sunday, February 12, 2012
Subscribe to:
Posts (Atom)