SQL Backup

I am new to SQL server, but I have gotten it set up on my DiscountASP account and it works with DotNetNuke. Now I need to know how to back up the SQL database so if I corrupt that database, I can restore it. Please remember I have little SQL Server experience! What is the simplest method?

Thanks.

Paul

 

I don't have any local copy of SQL and I don't really know what DTS is.


I am running XP PRO SP2 and W2000 SP4 on several machines locally. What is the easiest way to set up SQL on a W2000 box and use it as you have stated? This is the only thing I will use it for so less is more.


Thanks,


Paul

 

Bruce,


I have purchased a copy of SQL Server 2000 developers edition. This is a bit daunting, however. Before I install it on a local W2000 machine, I would like to have some specifics on what steps I will need to perform to back up my discountasp.net SQL server database and what parts or tools I need to install here to do that.


Thanks


Paul

 

OK,


I will do a full install on a W2000 machine and try to make a local copy. What connection parameters will I need?


Thanks,


Paul