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.

2.

3.

4.

5.

6.

7.

8.

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.

 

[ProjectTorquex2]

Re: [Guide] backup your database

wow good

 

[robscneider]

Re: [Guide] backup your database

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

 

[D4NyZ]

Re: [Guide] backup your database

Nice...

 

[robscneider]

Re: [Guide] backup your database

thanks for this..my problem are fixed

 

[HurryPoker]

Re: [Guide] backup your database

im glad i can help you guys!
Have fun and many players online

 

[ApophyS]

Re: [Guide] backup your database

how i restore the backup database???

 

[[RCZ]ShadowKing]

Re: [Guide] backup your database

how i restore the backup database???

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

 

[ApophyS]

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?????

 

[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....