backup your database

[HurryPoker]

Hi to all MU Server admin, 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 Script which will backup your database

now go to Start>All programs>Microsoft SQL Server>Enterprise Manager

Follow the image below.

Note: ON the Script above(the one has red color) it must exist or else the job will gives you a error.

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

Ok, when you finish, you may Right Click the Job and select Start Job
The job continue to occure depends on the Occure Time you set for that Job.

[MentaL]

[ProjectTorquex2]

wow good

[robscneider]

btw .when i run the jobs nothing happen.. its say...last run failed..status not running.. :(

[D4NyZ]

Nice...

[robscneider]

thanks for this..my problem are fixed :D

[HurryPoker]

im glad i can help you guys!:P
Have fun and many players online ;)

[ApophyS]

how i restore the backup database???

[[RCZ]ShadowKing]

how i restore the backup database???

right click on database->all task->restore?

[ApophyS]

if i whana restore me datebase ho i sae it whit this backup job how i do it ??? the name of back up save it is somthing like this ...BACKUPJan__2_2009_12_00PM how i atach this?????

[JohnRose00]

can u give me the link of DATABASE BACKUP ??

help me plss

[commandcom]

if i whana restore me datebase ho i sae it whit this backup job how i do it ??? the name of back up save it is somthing like this ...BACKUPJan__2_2009_12_00PM how i atach this?????

yes you can
just use my old script as example

BACKUP LOG muonline WITH NO_LOG

USE [Muonline]
GO

DBCC SHRINKDATABASE(N'Muonline')

Declare @dateBackup Varchar(100)
Set @dateBackup = 'C:\Backup\muonline_' +
Convert(varchar, datepart( year , Getdate() )) + '-'+ 
Convert( varchar , datepart( month , Getdate() ) ) + '-'+ 
Convert( varchar, datepart( day , Getdate() ) ) + '.bak' 
BACKUP DATABASE [Muonline] TO DISK = @dateBackup WITH NOFORMAT, NOINIT, NAME = N'Muonline-Full Database Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10
GO

BACKUP LOG Muonline_Ranking WITH NO_LOG

USE [Muonline_Ranking]
GO

DBCC SHRINKDATABASE(N'Muonline_Ranking')

Declare @dateBackup Varchar(100)
Set @dateBackup = 'C:\Backup\Muonline_Ranking_' +
Convert(varchar, datepart( year , Getdate() )) + '-'+ 
Convert( varchar , datepart( month , Getdate() ) ) + '-'+ 
Convert( varchar, datepart( day , Getdate() ) ) + '.bak' 
BACKUP DATABASE [Muonline_Ranking] TO DISK = @dateBackup WITH NOFORMAT, NOINIT, NAME = N'Muonline_Ranking-Full Database Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10
GO

BACKUP LOG Muonline_Event WITH NO_LOG

USE [Muonline_Event]
GO

DBCC SHRINKDATABASE(N'Muonline_Event')

Declare @dateBackup Varchar(100)
Set @dateBackup = 'C:\Backup\Muonline_Event_' +
Convert(varchar, datepart( year , Getdate() )) + '-'+ 
Convert( varchar , datepart( month , Getdate() ) ) + '-'+ 
Convert( varchar, datepart( day , Getdate() ) ) + '.bak' 
BACKUP DATABASE [Muonline_Event] TO DISK = @dateBackup WITH NOFORMAT, NOINIT, NAME = N'Muonline_Event-Full Database Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10
GO

can u give me the link of DATABASE BACKUP ??

help me plss

what link? it is a sql script just 4 shot rows in lenght....