Creating minute/hourly/daily/weekly backups.

[Keith]

You gotta create a Job for MSSQL, but If you know how to do that, and If you don't google it

DECLARE @DATE varchar(100),
@Filelocation varchar(50)



SET @DATE = DATENAME(MONTH,GETDATE()) + '_' + DATENAME(DAY,GETDATE()) + '_' + DATENAME(YYYY,GETDATE()) + '_' + DATENAME(HOUR,GETDATE()) + '_' + DATENAME(MINUTE,GETDATE()) + '_' + DATENAME(SECOND,GETDATE())
SET @FileLocation = 'C:\GunZ\Database\GunZ_'+ @DATE + '_.bak'

BACKUP DATABASE YOURDATABASENAME
TO DISK = @FileLocation
WITH INIT,
STATS

Change YOURDATABASENAME with your databases name
and the File location to where gunz is

Screen:


Credits: me, and google.


Creating a job

http://forum.ragezone.com/f245/how-t...1/#post4901822

Credits to the post creator.

[MentaL]

[Forean]

Wow THANK YOU this will provide Easyer Backups =]

[Katsuro]

This is quite a nice help to many servers. Especially when they get there Database hacked often.

[Joe9099]

Yeh its nice if you have a shit load of hard drive space.

Doing this by minutes would seriously skank your space

[Keith]

Yeh its nice if you have a shit load of hard drive space.

Doing this by minutes would seriously skank your space

You can set the time in the jobs, in MSSQL. Thats just a example screen shot.

[Joe9099]

Yeh i know, but if i used this, with my vps i would probably go weekly, but yeh good job

[Forean]

that would be cool if you could make it do daily, but insted of keeping all why not make it only make 5 and everyone new one it erases the oldest one.

\

[Projectix]

Good job, this is a nice TuT.

[Keith]

that would be cool if you could make it do daily, but insted of keeping all why not make it only make 5 and everyone new one it erases the oldest one.

\

I can't do that from MSSQL I think.

[[+]Daniel]

Thanks Keith, very helpful ;D

[Demantor]

Useful, thankx ^^

[CrashPoint]

good release :) there r som useful softs for backin up out there for lazy ppls :D but u hav to buy them -__-

P/S: How u gonna backup an 6Gb+ Database everymin ? lol

[cerealnp]

Interesting, good to see you back on Gunz Section =P

[Torrentspy]

sry but how to use this? put the code in .php then direct browser to it?

[Linear88]

No. It automatically programs by itself.