BACKUP MSDE

WE HAVE A COLLECTION OF STUDENT MANAGEMENT MODULES THAT
USE THE MICROSOFT SQL SERVER DESKTOP ENGINE (MSDE). OUR
USER BASE IS MOSTLY IT ILLITERATE SO WE NEED TO DEVELOP A
SIMPLE ONE CLICK PROCEDURE FOR BACKING UP THE DATABASE
AND SOME OTHER USER FILES LIKE WORD ABD EXCEL. IS IT
POSSIBLE TO USE MICROSOFT BACKUP FOR THIS PROCESS AND IF
POSSIBLE, IS IT NECESSARY TO STOP THE SERVER WHILE DOING
SO.You will have to write an application that sends the native BACKUP command
to SQL Server, to backup the required databses. You could also make use of
SQL DMO object model for this purpose.
And no, the databases and server can be online while the backups are
happening.
See SQL Server 2000 Books Online for more information on BACKUP command.
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"JOHN HAMILTON" <anonymous@.discussions.microsoft.com> wrote in message
news:fefa01c3f226$7f71cf70$a501280a@.phx.gbl...
WE HAVE A COLLECTION OF STUDENT MANAGEMENT MODULES THAT
USE THE MICROSOFT SQL SERVER DESKTOP ENGINE (MSDE). OUR
USER BASE IS MOSTLY IT ILLITERATE SO WE NEED TO DEVELOP A
SIMPLE ONE CLICK PROCEDURE FOR BACKING UP THE DATABASE
AND SOME OTHER USER FILES LIKE WORD ABD EXCEL. IS IT
POSSIBLE TO USE MICROSOFT BACKUP FOR THIS PROCESS AND IF
POSSIBLE, IS IT NECESSARY TO STOP THE SERVER WHILE DOING
SO.|||MANY THANKS NARAYANA...