How to make a quick backup of your database:

A simple aid.

Use the query below to make a quick backup.

Open your SMSS, click on New Query and put this code.

Change 'D: \ Backup_Shaiya_DB \ PS_ChatLog.bak' to the letter and directory you wish to retain only the file name.

Save the query for future backups.

Code:

USE OMG_GameWEB
GO
BACKUP DATABASE OMG_GameWEB
TO DISK = 'D:\Backup_Shaiya_DB\OMG_GameWEB.bak';
GO

USE PS_Billing
GO
BACKUP DATABASE PS_Billing
TO DISK = 'D:\Backup_Shaiya_DB\PS_Billing.bak';
GO

USE PS_ChatLog
GO
BACKUP DATABASE PS_ChatLog
TO DISK = 'D:\Backup_Shaiya_DB\PS_ChatLog.bak';
GO

USE PS_GMTool
GO
BACKUP DATABASE PS_GMTool
TO DISK = 'D:\Backup_Shaiya_DB\PS_GMTool.bak';
GO

USE PS_GameData
GO
BACKUP DATABASE PS_GameData
TO DISK = 'D:\Backup_Shaiya_DB\PS_GameData.bak';
GO

USE PS_GameDefs
GO
BACKUP DATABASE PS_GameDefs
TO DISK = 'D:\Backup_Shaiya_DB\PS_GameDefs.bak';
GO

USE PS_GameLog
GO
BACKUP DATABASE PS_GameLog
TO DISK = 'D:\Backup_Shaiya_DB\PS_GameLog.bak';
GO

USE PS_StatData
GO
BACKUP DATABASE PS_StatData
TO DISK = 'D:\Backup_Shaiya_DB\PS_StatData.bak';
GO

USE PS_Statics
GO
BACKUP DATABASE PS_Statics
TO DISK = 'D:\Backup_Shaiya_DB\PS_Statics.bak';
GO

USE PS_UserData
GO
BACKUP DATABASE PS_UserData
TO DISK = 'D:\Backup_Shaiya_DB\PS_UserData.bak';
GO