Welcome!

Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!

Join Today!

backup your database

HOT z
Joined
Sep 9, 2005
Messages
316
Reaction score
8
Hi to all MU Server admin, this guide will help you backup your database using sql job agent.


Code:
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.
HurryPoker - backup your database - RaGEZONE Forums

2.
HurryPoker - backup your database - RaGEZONE Forums

3.
HurryPoker - backup your database - RaGEZONE Forums

4.
HurryPoker - backup your database - RaGEZONE Forums

5.
HurryPoker - backup your database - RaGEZONE Forums

6.
HurryPoker - backup your database - RaGEZONE Forums

7.
HurryPoker - backup your database - RaGEZONE Forums

8.
HurryPoker - backup your database - RaGEZONE Forums


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.
 
Last edited:
Newbie Spellweaver
Joined
Nov 14, 2007
Messages
42
Reaction score
0
Re: [Guide] backup your database

btw .when i run the jobs nothing happen.. its say...last run failed..status not running.. :(
 
Junior Spellweaver
Joined
Aug 19, 2008
Messages
121
Reaction score
0
Re: [Guide] backup your database

Nice...
 
Newbie Spellweaver
Joined
Nov 14, 2007
Messages
42
Reaction score
0
Re: [Guide] backup your database

thanks for this..my problem are fixed :D
 
HOT z
Joined
Sep 9, 2005
Messages
316
Reaction score
8
Re: [Guide] backup your database

im glad i can help you guys!:p
Have fun and many players online ;)
 
Elite Diviner
Joined
Mar 22, 2008
Messages
408
Reaction score
50
Re: [Guide] backup your database

how i restore the backup database???
 
Elite Diviner
Joined
Mar 22, 2008
Messages
408
Reaction score
50
Re: [Guide] backup your database

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?????
 
Joined
Jan 22, 2005
Messages
889
Reaction score
80
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
Code:
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....
 
Last edited:
Back
Top