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

Credits:
mafiux for the new script
DWT

[MentaL]

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

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]

make sure Sql Server Agent is Enable

Read above

[gnomiux]

Make your last picture work.. :bomb:

[neukjochie]

WTF

gnomiux
Ur rIGHT

[gnomiux]

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

[Pinoyrealm]

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]

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

[susiraukes]

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

[susiraukes]

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

[Liselotte]

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

[susiraukes]

oki thx :P

[razu3]

Nice guide, but how can I make a backup of the db on other pc (direct/static ip)

Thx!
:)

[Ch4rLi3]

how to restore the backup file?

[hermes]

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

Thank you DUDE !!! now it worked :wiggle:

THX !

[DarkMaster.]

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

I have this error too!