DataBase Backup Job [IMG GUIDE]

[Liselotte]

Hi to all MU Server admin, this guide will help you backup your database using sql job agent.

DECLARE @file varchar(70)
SET @file = N'D:\BACKUP'+REPLACE(REPLACE(CAST(getdate() AS varchar), ' ', '_'), ':', '_')
SELECT @file
BACKUP DATABASE [MuOnline] TO DISK = @file 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.

Credits:
mafiux for the new script
DWT

 

[GODANGEL]

it will be of great use to ALL Admins

 

[djspankman]

Very nice indeed liselotte, now if someone doesn't get this guide it's pretty much impossible to help that person xD.

 

[Xurbus]

great guide, but if something happens to the current db, how to i restore from sql?

 

[Dios]

Does this overwrite the files? I mean, If you backup every 3 hours will the second backup overwrite the first one?

Im still looking for the perfect backup method like explained on this post: http://forum.ragezone.com/mu-server-client-help/help-what-best-backup-methods-206598.html

I already have the program seted to upload the file to my hosting automaticly and would like to make a guide on how to have safe backups so people stop loosing their servers ^^

Edit: Added to Rz Guide Center

 

[Liselotte]

Does this overwrite the files?

Yes

PS: very neat guide center ^^

 

[Pinoyrealm]

wow nice, there will be no problem regarding the lags and everything when this job is operating right?

 

[Liselotte]

yep, it take only 2-4 secs to fully backup the database.

 

[Pinoyrealm]

on the job it says fail... i dont know why, i made a folder and put the database bacup on it,D:/muserver/db backs/muonline.bak, but still its failed, any posible problem on me?... i will appreciate someone help me...

 

[Liselotte]

make sure Sql Server Agent is Enable

 

[gnomiux]

Re: [Guide] DataBase Backup Job [IMG GUIDE]

When I finish all things by this guide (P.S. I Can't see the last pic) and I try to start the job it show no erorr just this (SQL Agent enabled).

 

[Dios]

Re: [Guide] DataBase Backup Job [IMG GUIDE]

make sure Sql Server Agent is Enable

Read above

 

[gnomiux]

Re: [Guide] DataBase Backup Job [IMG GUIDE]

Make your last picture work.. :bomb:

 

[neukjochie]

Re: [Guide] DataBase Backup Job [IMG GUIDE]

WTF

gnomiux
Ur rIGHT

 

[gnomiux]

Re: [Guide] DataBase Backup Job [IMG GUIDE]

Mines still don't work It shows no erorr but it wont start.. :bad:

 

[Pinoyrealm]

Re: [Guide] DataBase Backup Job [IMG GUIDE]

well i have suggestion for you... just go to your database right click just like what you do when you are restoring and choose backup then point it to your backup files or MuOnline.bak then click schedule then choose when you want to set it up...

 

[gnomiux]

Re: [Guide] DataBase Backup Job [IMG GUIDE]

Thanks -Jumong-, you helped me alot , now it's working.. 8)

 

[susiraukes]

Re: [Guide] DataBase Backup Job [IMG GUIDE]

How to make backup if my server's dbs are on C:\muserver\db\
??

 

[susiraukes]

Re: [Guide] DataBase Backup Job [IMG GUIDE]

always same ****. Error icon and The job failed. Please help

 

[Liselotte]

Re: [Guide] DataBase Backup Job [IMG GUIDE]

change the Directory to C:\xxx\xxx instead of D:\xxx\xxx