How to make a quick backup of your database:

[patoringa]

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.

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

[kalle801]

Thank You, this is Very Very Helpfull!

[Pliks]

How do OMG_GameWEB.bak -> OMG_GameWEB ?

[[GM]Recover]

umm this has been released with a CMD command with it

[Bаne]

At any point, wrong section, this is a release and belongs in the development section.

[lilprohacker]

#moved