[Guide] DataBase Auto Backup

[ReaL]

Hi to all MU Server admins, this guide will help you backup your database using sql job agent.
Този Guide ще ви помогне да си backup-нете датабазата с помощта на SQL Job Agent-а!

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

 

[Sunwalker]

that is cool i test it and it work

 

[ReaL]

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]

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]

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]

Много хубаво Мерси :cheezy:

 

[masterhack]

ReaL зъл си

 

[Mortred]

Thanks

 

[morgoth94]

Yo-Yo тенкс много РеаЛ!

 

[MadBoy]

Absolute. Approved Work.. ReaL 10/10 mean

 

[NikeR]

мм браво много полезно ::

 

[Apeli]

Много ми трябваше точно това! Браво!

 

[ReaL]

Очаквайте скоро да бъде малко по-изпипано и стабилизирано ^^

 

[1ns0mn1a]

имам го доста по изпипан

 

[Lesh0]

на мене и този ми върши работа !!

 

[1ns0mn1a]

щом така си решил

 

[GrandeuR]

The_cue ако желаеш, можеш да го споделиш с нас.

 

[MadBoy]

Look my problem >
I Wan't To Back Up the Accounts Cuz Need Change Version

 

[ReaL]

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

 

[MadBoy]

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