The key component of SQLDMO is sqldmo.dll. Of course, this COM DLL needs several other DLLs to run properly.I use a very useful FREE tool TOAD for SQL Server. It only requires SQLDMO. But I do not want to install SQL Server or its client tools, so I spent some time figuring out the minimum files needed by SQLDMO.Here is a listing of C:\Program Files\Microsoft SQL Server on my Windows 2000 Pro box: Volume in drive C is SYSTEM Volume Serial Number is 947A-9043 Directory of C:\Program Files\Microsoft SQL Server08/26/2004 01:25p <DIR> . 08/26/2004 01:25p <DIR> .. 07/20/2004 03:43p <DIR> 80 08/26/2004 01:25p 0 list.txt 08/24/2004 05:57p <DIR> toad for sql server 1 File(s) 0 bytes Directory of C:\Program Files\Microsoft SQL Server\8007/20/2004 03:43p <DIR> . 07/20/2004 03:43p <DIR> .. 07/20/2004 03:49p <DIR> tools 0 File(s) 0 bytes Directory of C:\Program Files\Microsoft SQL Server\80\tools07/20/2004 03:49p <DIR> . 07/20/2004 03:49p <DIR> .. 07/20/2004 04:06p <DIR> binn 07/20/2004 03:47p <DIR> books 0 File(s) 0 bytes Directory of C:\Program Files\Microsoft SQL Server\80\tools\binn07/20/2004 04:06p <DIR> . 07/20/2004 04:06p <DIR> .. 07/20/2004 03:44p <DIR> resources 05/31/2003 06:01p 4,215,360 sqldmo.dll 07/13/2000 10:13a 84,938 sqldmo80.cnt 07/13/2000 10:17a 2,101,214 sqldmo80.hlp 12/17/2002 04:25p 29,248 sqlresld.dll 12/17/2002 04:25p 94,784 sqlsvc.dll 12/17/2002 04:25p 49,728 w95scm.dll 6 File(s) 6,575,272 bytes Directory of C:\Program Files\Microsoft SQL Server\80\tools\binn\resources07/20/2004 03:44p <DIR> . 07/20/2004 03:44p <DIR> .. 07/20/2004 03:45p <DIR> 1033 0 File(s) 0 bytes Directory of C:\Program Files\Microsoft SQL Server\80\tools\binn\resources\103307/20/2004 03:45p <DIR> . 07/20/2004 03:45p <DIR> .. 12/17/2002 04:22p 585,728 sqldmo.rll 08/06/2000 01:50a 24,576 sqlsvc.rll 2 File(s) 610,304 bytes Directory of C:\Program Files\Microsoft SQL Server\80\tools\books07/20/2004 03:47p <DIR> . 07/20/2004 03:47p <DIR> .. 11/21/2003 05:48p 120,986 sqldmo.chi 11/21/2003 05:48p 1,542,396 sqldmo.chm 2 File(s) 1,663,382 bytes Directory of C:\Program Files\Microsoft SQL Server\toad for sql server08/24/2004 05:57p <DIR> . 08/24/2004 05:57p <DIR> .. 07/29/2004 02:38p 116,831 TOADSQL.chm 07/29/2004 04:08p 1,042,944 TOAD_SS.exe 07/30/2004 11:22a 8,450 TOAD_SS.htm 08/25/2004 11:43a 3,435 TOAD_SS.INI 4 File(s) 1,171,660 bytes Total Files Listed: 15 File(s) 10,020,618 bytes 23 Dir(s) 1,602,129,920 bytes freeHope this information is useful to you.
I am not an expert on SQL, so I am guessing that if database backup can be done via pure SQL statements, I think you sure can do it using ADO.Or if you are familiar with C/C++ programming, you can try DBLIB for C. But I personally never had experience on that. :-(
Volume Serial Number is 947A-9043 Directory of C:\Program Files\Microsoft SQL Server08/26/2004 01:25p <DIR> .
08/26/2004 01:25p <DIR> ..
07/20/2004 03:43p <DIR> 80
08/26/2004 01:25p 0 list.txt
08/24/2004 05:57p <DIR> toad for sql server
1 File(s) 0 bytes Directory of C:\Program Files\Microsoft SQL Server\8007/20/2004 03:43p <DIR> .
07/20/2004 03:43p <DIR> ..
07/20/2004 03:49p <DIR> tools
0 File(s) 0 bytes Directory of C:\Program Files\Microsoft SQL Server\80\tools07/20/2004 03:49p <DIR> .
07/20/2004 03:49p <DIR> ..
07/20/2004 04:06p <DIR> binn
07/20/2004 03:47p <DIR> books
0 File(s) 0 bytes Directory of C:\Program Files\Microsoft SQL Server\80\tools\binn07/20/2004 04:06p <DIR> .
07/20/2004 04:06p <DIR> ..
07/20/2004 03:44p <DIR> resources
05/31/2003 06:01p 4,215,360 sqldmo.dll
07/13/2000 10:13a 84,938 sqldmo80.cnt
07/13/2000 10:17a 2,101,214 sqldmo80.hlp
12/17/2002 04:25p 29,248 sqlresld.dll
12/17/2002 04:25p 94,784 sqlsvc.dll
12/17/2002 04:25p 49,728 w95scm.dll
6 File(s) 6,575,272 bytes Directory of C:\Program Files\Microsoft SQL Server\80\tools\binn\resources07/20/2004 03:44p <DIR> .
07/20/2004 03:44p <DIR> ..
07/20/2004 03:45p <DIR> 1033
0 File(s) 0 bytes Directory of C:\Program Files\Microsoft SQL Server\80\tools\binn\resources\103307/20/2004 03:45p <DIR> .
07/20/2004 03:45p <DIR> ..
12/17/2002 04:22p 585,728 sqldmo.rll
08/06/2000 01:50a 24,576 sqlsvc.rll
2 File(s) 610,304 bytes Directory of C:\Program Files\Microsoft SQL Server\80\tools\books07/20/2004 03:47p <DIR> .
07/20/2004 03:47p <DIR> ..
11/21/2003 05:48p 120,986 sqldmo.chi
11/21/2003 05:48p 1,542,396 sqldmo.chm
2 File(s) 1,663,382 bytes Directory of C:\Program Files\Microsoft SQL Server\toad for sql server08/24/2004 05:57p <DIR> .
08/24/2004 05:57p <DIR> ..
07/29/2004 02:38p 116,831 TOADSQL.chm
07/29/2004 04:08p 1,042,944 TOAD_SS.exe
07/30/2004 11:22a 8,450 TOAD_SS.htm
08/25/2004 11:43a 3,435 TOAD_SS.INI
4 File(s) 1,171,660 bytes Total Files Listed:
15 File(s) 10,020,618 bytes
23 Dir(s) 1,602,129,920 bytes freeHope this information is useful to you.