COMMANDS FOR CROSSFIRE 3.0 DATABASE

[markondes]

COMMAND TO CREATE USER cf30 WITH PASSWORD 1234

CREATE LOGIN [cf30] WITH PASSWORD = N'1234',
DEFAULT_DATABASE = [master],
CHECK_EXPIRATION = OFF,
CHECK_POLICY = OFF;
GO


COMMAND TO CREATE THE CROSSFIRE 3.0 DATABASES

CREATE DATABASE [CF_CN_Bill];
CREATE DATABASE [CF_CN_CLAN];
CREATE DATABASE [CF_CN_GAME];
CREATE DATABASE [CF_CN_LOG];
CREATE DATABASE [CF_CN_WEB];

COMMAND TO RESTORE THE DATABASE FROM .BAK FILES

-- =============================================
-- 1. IN CF_CN_Bill
-- =============================================
ALTER DATABASE [CF_CN_Bill] SET SINGLE_USER WITH ROLLBACK IMMEDIATE;
RESTORE DATABASE [CF_CN_Bill]
FROM DISK = N'C:\pmang\db\CF_CN_Bill.BAK'
WITH FILE = 1, NOUNLOAD, REPLACE, STATS = 10;
ALTER DATABASE [CF_CN_Bill] SET MULTI_USER;
GO

USE [CF_CN_Bill];
IF EXISTS (SELECT * FROM sys.database_principals WHERE name = N'cf30')
ALTER USER [cf30] WITH LOGIN = [cf30]; -- remap orphaned user
ELSE
CREATE USER [cf30] FOR LOGIN [cf30];
ALTER ROLE [db_owner] ADD MEMBER [cf30];
GO

-- =============================================
-- 2. IN CF_CN_CLAN
-- =============================================
ALTER DATABASE [CF_CN_CLAN] SET SINGLE_USER WITH ROLLBACK IMMEDIATE;
RESTORE DATABASE [CF_CN_CLAN]
FROM DISK = N'C:\pmang\db\CF_CN_CLAN.BAK'
WITH FILE = 1, NOUNLOAD, REPLACE, STATS = 10;
ALTER DATABASE [CF_CN_CLAN] SET MULTI_USER;
GO

USE [CF_CN_CLAN];
IF EXISTS (SELECT * FROM sys.database_principals WHERE name = N'cf30')
ALTER USER [cf30] WITH LOGIN = [cf30];
ELSE
CREATE USER [cf30] FOR LOGIN [cf30];
ALTER ROLE [db_owner] ADD MEMBER [cf30];
GO

-- =============================================
-- 3. IN CF_CN_GAME
-- =============================================
ALTER DATABASE [CF_CN_GAME] SET SINGLE_USER WITH ROLLBACK IMMEDIATE;
RESTORE DATABASE [CF_CN_GAME]
FROM DISK = N'C:\pmang\db\CF_CN_GAME.BAK'
WITH FILE = 1, NOUNLOAD, REPLACE, STATS = 10;
ALTER DATABASE [CF_CN_GAME] SET MULTI_USER;
GO

USE [CF_CN_GAME];
IF EXISTS (SELECT * FROM sys.database_principals WHERE name = N'cf30')
ALTER USER [cf30] WITH LOGIN = [cf30];
ELSE
CREATE USER [cf30] FOR LOGIN [cf30];
ALTER ROLE [db_owner] ADD MEMBER [cf30];
GO

-- =============================================
-- 4. IN CF_CN_LOG
-- =============================================
ALTER DATABASE [CF_CN_LOG] SET SINGLE_USER WITH ROLLBACK IMMEDIATE;
RESTORE DATABASE [CF_CN_LOG]
FROM DISK = N'C:\pmang\db\CF_CN_LOG.BAK'
WITH FILE = 1, NOUNLOAD, REPLACE, STATS = 10;
ALTER DATABASE [CF_CN_LOG] SET MULTI_USER;
GO

USE [CF_CN_LOG];
IF EXISTS (SELECT * FROM sys.database_principals WHERE name = N'cf30')
ALTER USER [cf30] WITH LOGIN = [cf30];
ELSE
CREATE USER [cf30] FOR LOGIN [cf30];
ALTER ROLE [db_owner] ADD MEMBER [cf30];
GO

-- =============================================
-- 5. IN CF_CN_WEB
-- =============================================
ALTER DATABASE [CF_CN_WEB] SET SINGLE_USER WITH ROLLBACK IMMEDIATE;
RESTORE DATABASE [CF_CN_WEB]
FROM DISK = N'C:\pmang\db\CF_CN_WEB.BAK'
WITH FILE = 1, NOUNLOAD, REPLACE, STATS = 10;
ALTER DATABASE [CF_CN_WEB] SET MULTI_USER;
GO

USE [CF_CN_WEB];
IF EXISTS (SELECT * FROM sys.database_principals WHERE name = N'cf30')
ALTER USER [cf30] WITH LOGIN = [cf30];
ELSE
CREATE USER [cf30] FOR LOGIN [cf30];
ALTER ROLE [db_owner] ADD MEMBER [cf30];
GO

HOW TO BACKUP CROSSFIRE 3.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_CN_GAME]
TO DISK = 'C:\SQLBACKUP\CF_CN_GAME.BAK'
WITH INIT, STATS = 10;

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

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

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

BACKUP DATABASE [CF_CN_WEB]
TO DISK = 'C:\SQLBACKUP\CF_CN_WEB.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 5 FILES WITH THE NAMES BELOW INSIDE THE SQLBACKUP FOLDER, THESE FILES ARE THE BACKUP OF THE DATABASE!

CF_CN_Bill.BAK
CF_CN_CLAN.BAK
CF_CN_GAME.BAK
CF_CN_LOG.BAK
CF_CN_WEB.BAK