|
Home > Archive > MS SQL Server Tools > December 2005 > command line tools to make flat backups
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
command line tools to make flat backups
|
|
| melson@gmail.com 2005-12-28, 3:23 am |
| 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
| |
| Ray Mond 2005-12-28, 3:23 am |
| You could use osql e.g.
osql -Q "BACKUP DATABASE pubs TO DISK = 'e:\backups\pubs.bak'" -E
--
Ray Mond
| |
| melson@gmail.com 2005-12-28, 3:23 am |
| Yes, Ray, Perfecto!! That's what I was looking for. Thanks for the
help...
Happy Holidays!!
|
|
|
|
|