close

Top Panel

Top Panel
Sunday, 05 September 2010

Visit our forum

Click here to visit our forum for more support.

Free MuOnline File Hosting

We provide free file hosting @ no cost. Visit this link to start using our service!
DataBase Backup - SQL Agent Method [MSSQL 2000] Print
Written by Administrator   
Friday, 04 April 2008

This guide will help you backup your database using sql job agent.

*

BACKUP DATABASE [MuOnline] TO DISK = N'
D:\MuServer\db backs\MuOnline.bak' WITH INIT , 
NOUNLOAD , NAME = N'MuOnline backup', NOSKIP , 
STATS = 10, NOFORMAT

Above is the SQL Script that will backup your database.

NOTE: The red path must exist on your computer, this is where the database gonna go when you do the backup.

Now hit "Start>All programs>Microsoft SQL Server>Enterprise Manager"

Follow the images below step by step:

  1. http://img260.imageshack.us/img260/6180/sqljob1qk1.jpg
  2. http://img183.imageshack.us/img183/9038/sqljob2ul8.jpg
  3. http://img260.imageshack.us/img260/9082/sqljob3ik1.jpg
  4. http://img260.imageshack.us/img260/3343/sqljob4ap5.jpg
  5. http://img183.imageshack.us/img183/3746/sqljob5fa8.jpg
  6. http://img183.imageshack.us/img183/5959/sqljob6du1.jpg
  7. http://img183.imageshack.us/img183/9548/sqljob7my4.jpg
  8. http://img142.imageshack.us/img142/315/sqljob8up6.jpg

When you finish, right click the job that you just created and select start.

*Thanks to mig1st4ck for the script.
Last Updated ( Friday, 04 April 2008 )
 
< Prev