Hey all
I'm busy building an SQL management module into my server application. The aim of this part of the program is to:
- Create the database if it doesn't exist already
- Update the database with change scripts if necessary
- Backup the database at predefined times
While these tasks aren't very difficult to do in themselves, the program needs to do all this with SQL server 2000, 2005 & 2008(Express or Enterprise versions)
The part I'm focusing on now is the backups.
I've written a utility that uses SMO to do the backups before using SMO, but it seems that SMO was exclusive to SQL 2005.
DMO on the other hand was what was commonly used to backup SQL 2000... Is it still relivant? As in can i backup SQL server 2000, 2005 & 2008 using DMO?
Another option I saw was to do the backups by issuing T-SQL statements to the SQL server. T-SQL being a standard the same T-SQL code should be able to backup SQL server 2000, 2005 & 2008. Can someone please confirm this? And also if the method(C# Classes) of executing T-SQL scripts are the same for SQL server 2000, 2005 & 2008.
Any other thoughts and ideas are appreciated :)