HOW TO BACKUP CROSSFIRE 2.0 DATABASE

[markondes]

HOW TO BACKUP CROSSFIRE 2.0 DATABASE

1ST CREATE A FOLDER WITH NAME SQLBACKUP IN C:\

2ND OPEN SQL STUDIO 2019 AND CLICK NEW QUERY

3RD PLACE THE COMMAND BELOW AND CLICK EXECUTE

BACKUP DATABASE [CF_SA_GAME]
TO DISK = 'C:\SQLBACKUP\CF_SA_GAME.BAK'
WITH INIT, STATS = 10;

BACKUP DATABASE [CF_SA_GUILD]
TO DISK = 'C:\SQLBACKUP\CF_SA_GUILD.BAK'
WITH INIT, STATS = 10;

BACKUP DATABASE [CF_SA_LOG]
TO DISK = 'C:\SQLBACKUP\CF_SA_LOG.BAK'
WITH INIT, STATS = 10;

BACKUP DATABASE [CF_SA_MAC_LOG]
TO DISK = 'C:\SQLBACKUP\CF_SA_MAC_LOG.BAK'
WITH INIT, STATS = 10;

BACKUP DATABASE [CF_SA_WEB_DB]
TO DISK = 'C:\SQLBACKUP\CF_SA_WEB_DB.BAK'
WITH INIT, STATS = 10;

BACKUP DATABASE [G4BOX_SA_BILL_DB]
TO DISK = 'C:\SQLBACKUP\G4BOX_SA_BILL_DB.BAK'
WITH INIT, STATS = 10;

BACKUP DATABASE [HGW]
TO DISK = 'C:\SQLBACKUP\HGW.BAK'
WITH INIT, STATS = 10;

BACKUP DATABASE [SGGM]
TO DISK = 'C:\SQLBACKUP\SGGM.BAK'
WITH INIT, STATS = 10;


4TH WAIT FOR IT TO FINISH AND CHECK IF THE FILES .BAK WERE CREATED WITH THE NAME OF THE DATABASES

5TH IF EVERYTHING GOES WELL YOU WILL HAVE 8 FILES WITH THE NAMES BELOW INSIDE THE SQLBACKUP FOLDER, THESE FILES ARE THE BACKUP OF THE DATABASE!

CF_SA_GAME.BAK
CF_SA_GUILD.BAK
CF_SA_LOG.BAK
CF_SA_MAC_LOG.BAK
CF_SA_WEB_DB.BAK
G4BOX_SA_BILL_DB.BAK
HGW.BAK
SGGM.BAK