Topic: DataBase Auto Backup

DataBase Auto Backup

Аll MU Server admins, this guide will help you backup your database using sql job agent.


Above is the Script which will backup your database:

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

1. Create a folder called "DBAutoBackUp" in "D:\MuServer\" folder
2. Now go to Start>All programs>Microsoft SQL Server>Enterprise Manager

3. Follow the images below:
Step 1
http://img384.imageshack.us/img384/199/90927323.jpg
Step 2
http://img525.imageshack.us/img525/9363/52850400.jpg
Step 3
http://img203.imageshack.us/img203/7193/45729840.jpg
Step 4
http://img134.imageshack.us/img134/1355/43274608.jpg
Step 5
http://img23.imageshack.us/img23/9071/57587949.jpg
Step 6
http://img246.imageshack.us/img246/285/56143023.jpg
Step 7
http://img246.imageshack.us/img246/9329/70815809.jpg
Step 8
http://img96.imageshack.us/img96/6291/31430333.jpg
4. Ok, when you finish, you may Right Click the Job and select Start Job
5. The job continue to occure depends on the Occure Time you set for that Job.

Credit:
- 6efa

Re: DataBase Auto Backup

show