How to Backup database - SQL Server 2000

Hello,

I was looking around for some tutorials about how to backup my database in my hard disk using SQL Server 2000 Enterprise Manager.

Can someone explain me in a friendly and step-by-step method? (screenshots preferred)



Thanx so much in advance

 

http://www.microsoft.com/technet/prodtechnol/sql/2000/books/c11ppcsq.mspx#EEHAC

 

If you search the web, there are tons of examples and articles around this subject. There are 2 main ways to backup a db with SQL Server.

1. Script it - You can run a script to perform the backup. An very simple example would be Backup database dbname to disk="c:\dbname.bak" . You could also schedule that script using SQL Agent.

2. Use the Maintenance Wizard - The maintenance wizard can set up automated jobs to backup all your databases on the server. You simply go through the steps and tell it what time to backup the databases. For example, you could do a full backup for all dbs every night at 11pm. That would be the simplest method to get started.

 

I hope this tutorial will help http://www.2000trainers.com/article.aspx?articleID=69&page=3

 

Interesting links.

I like to work with ASP and MS access files but I'm just learning that they are no as safe as I could think off.


SQL Server 2000 sounds like a good idea because I don't like MySQL and the every day more annoying phpMyAdmin