back-up Windows service for database backup.
-
Hi, I need to write a windows service that will take a backup of the database tables and their data to a file when the server goes down and at the end of day everyday. Can anybody tell me how do I go about it? For the back-up do I need to use SQL-DMO or is there some other way out? Thanks in advance, Aakar.
-
Hi, I need to write a windows service that will take a backup of the database tables and their data to a file when the server goes down and at the end of day everyday. Can anybody tell me how do I go about it? For the back-up do I need to use SQL-DMO or is there some other way out? Thanks in advance, Aakar.
For my money, SQL-DMO is the way to go. It allows you to stay within the confines of the application and is just a cleaner implementation (IMHO!) I attempted to invoke sqlo from within C# and it did work, but catching any exceptions was a bit awkward. /dave ---- If you always do what you always done, you'll always get what you've always got - Anonymous