[Guide] DataBase Auto Backup

ReaL

New Member
Joined
Apr 13, 2008
Messages
1,244
Reaction score
656
Hi to all MU Server admins, this guide will help you backup your database using sql job agent.
Този Guide ще ви помогне да си backup-нете датабазата с помощта на SQL Job Agent-а!
Code:
DECLARE @ads varchar(70)
SET @ads = N'D:\MuServer\DBAutoBackUp\'+REPLACE(REPLACE(CAST(getdate() AS varchar), ' ', '_'), ':', '_')
SELECT @ads
BACKUP DATABASE [MuOnline] TO DISK = @ads WITH INIT , NOUNLOAD , NAME = N'MuOnline AutoBackUp', NOSKIP , STATS = 10, NOFORMAT

Above is the Script which will backup your database
Това горе е скриптът, който ще backup-не датабазата ви!

Create a folder called "DBAutoBackUp" in "D:\MuServer\" folder :)
Създайте папка "DBAutoBackUp" в "D:\MuServer\" :)

Now go to Start>All programs>Microsoft SQL Server>Enterprise Manager
Тук няма нужда от превод ^^

Follow the images below.
Следете долу-посочените картинки

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

1. 404 Not Found
2. 404 Not Found
3. 404 Not Found
4. 404 Not Found
5. 404 Not Found
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
Добре, когато приключите, натискате десен бутон върху задачата и давате на Start Job
The job continue to occure depends on the Occure Time you set for that Job.
Задачата продължава да се изпълнява, взависимост от това, през колко време сте я сложили (вижте картинките)

Tested! Тествано!
GL, Късмет,
ReaL
 
Last edited:

ReaL

New Member
Joined
Apr 13, 2008
Messages
1,244
Reaction score
656
I said it's tested by me and a friend with 97d+99i, so it works on every DB...
S1 S2 S3... All DBs :)
Saves the file and then overwrites it every time the Job is executed ;)
 

Protect

Active Member
Joined
May 30, 2008
Messages
989
Reaction score
150
asd

I said it's tested by me and a friend with 97d+99i, so it works on every DB...
S1 S2 S3... All DBs :)
Saves the file and then overwrites it every time the Job is executed ;)

Another good work from u Congratuations,u are the best :2:
 

ReaL

New Member
Joined
Apr 13, 2008
Messages
1,244
Reaction score
656
Thx, Protect ;)
I forgot to tell ya, that it 'creates' a very lil lag in the serv (which i had never experience, but so i've heard - my mashine is not so good, the net too...) :)
 

RhysFox

New Member
Joined
Jun 30, 2008
Messages
918
Reaction score
299
Много хубаво :) Мерси :cheezy:
 

Apeli

New Member
Joined
Oct 5, 2008
Messages
40
Reaction score
2
Много ми трябваше точно това! Браво!
 

ReaL

New Member
Joined
Apr 13, 2008
Messages
1,244
Reaction score
656
Очаквайте скоро да бъде малко по-изпипано и стабилизирано ^^
 

Lesh0

Active Member
Joined
Apr 22, 2008
Messages
705
Reaction score
89
на мене и този ми върши работа !!
 

GrandeuR

Member
Joined
Oct 27, 2008
Messages
51
Reaction score
5
The_cue ако желаеш, можеш да го споделиш с нас.
 

MadBoy

New Member
Joined
Apr 27, 2008
Messages
805
Reaction score
152
Look my problem :( >
I Wan't To Back Up the Accounts Cuz Need Change Version


nj7irlyii5xff5ovaonm.jpg


zj4gduxowlts25rxo688.jpg
 
Last edited:

ReaL

New Member
Joined
Apr 13, 2008
Messages
1,244
Reaction score
656
It's Ok, yea, that's just the backup of your MuOnline DB :}
 
  • Like
Reactions: MadBoy

MadBoy

New Member
Joined
Apr 27, 2008
Messages
805
Reaction score
152
[Guide] DataBase Auto Backup

It's Ok, yea, that's just the backup of your MuOnline DB :}

ok :handshake:if i delete now... the MuOnline and Ranking Databes what do it after?