SQL Server 2000 backup techniques to a client machine: Possible?

I have a client who wants to be able to backup his own data on SQL Server 2000 himself, but he does not have Enterprise Manager nor does he have a remote location to store it to. He's running Win ME with Office 2K on a laptop, and the data in the database would be somewhere between 5000-10000 records spread across an as-yet-undetermined number of tables.

My initial thought is to set up an Access 2000 database (since he has Access 2000), have all of the information erased every time, and have it repopulated with the information each time. Then, when the database was repopulated, he could click on a hyperlink and download it himself, giving him a copy.

The language I would plan on using is either ASP/VBScript or more likely ASP.net/VB.net . Would this be a feasible way to go about doing this? Would it be able to back up stored procedures and things of that nature as well? And if this is not the best way, what would be a better way? I'm looking for something short, sweet, relatively non-technical and to the point. If necessary, I can program something but I would prefer something that I can say "here you go, here's how you do it, that's it, that's all." Thanks.

 

 

 

 

Top