[SHARE] Auto Backup System (batch file)

[xXxExosoulerxXx]

Features and advantages:

* Single batch file, no unknown programs to run.

* Does its job no matter what SQL Agent feels about you and server settings/components status.

* Easy to use.

 

You can make it daily or whatever you want (warning: backup file names are set to daily with overwriting).

 

How to use

1. Remove second extension (.txt) from the filename.

2. Place it somewhere :)

3. Open the file (check it out to make sure it does no harm to your server :)) and set basic settings:

SET ServerName=[i]mssql_server_name[/i]
SET BackupsDir=[i]Path to some folder for backups[/i]
SET LogsDir=[i]Path to some folder, where you wanna see your logs spam :P[/i]

4. Check the Parent process section, you may want to delete/add some databases from/to backup cycle. To add a new database, simply copy the line and edit the database name.

5. Set up your scheduler to run it at desired interval: Start -> Settings -> Control Panel -> Scheduled Tasks -> Add Scheduled Task, browse to script, set up run interval, start time and other stuff, enter administrator's login/password/confirm it, and we're done.

6. Check the script. Your MSSQL Server settings may prohibit this type of logon, so you have to set it up to audit failed logon attempts.

 

P.S. It's better to schedule this tool to run when your online is minimal. Other way your players will experience some SS-delays when backing up lin2world, but that depends.

 

 

HERE

 

 

src:postpacific.com

[Stefoulis15]

Nice Share.....

 

 

 

P.S: Gratz For Not Stealing The Work Of Other Ppl Again ... (Me...)

 

[Draagoon]

nice one xxxxXxExosoulerxXx

[Exofil]

the post has already posted !

look one minute here : http://www.maxcheaters.com/forum/index.php?topic=22296.0

[fdLP.]

There you say exofil is a Guide .. i dont see anything the same .... he made a guide .... this 1 just a guide without screens ....

[Auryx]

Tnx man for posting

[lion2486]

thx

[gandalf0007]

ESTOE S FOR ASER BACK AUTOMATIC UP????

[mariano2008]

ESTOE S FOR ASER BACK AUTOMATIC UP????

SPANISH= jajajaja tenes peor ingles q yo, pero si es un programita para hacer autos backups ^_^

 

ENGLISH= yes, this is for make auto backup, thanks for share :D

[avaton]

nice job.ty ;)

[AntiVirusCZ]

Czech: Díky, funguje to a vyplatí se to zapnout, protože z navicatu mám noční můry.

English: Thank you, it works and shall be paid to turn because of navicat I have nightmares.

[Expini]

good job thank you :D

it work for me

[ZeRo*]

good job thank you :D

it work for me

lol man!! This topic is from 2008...Check the dates before you post and read our rules.

 

1st warning...Next time -1 karma.

Locked.