[Mini-Release] 8.1 Database in SQL-Format

[Xijezu]

Hey,

Since I saw a lot of people having problems with the restore of the Databases, I thought about converting them into the .sql-format instead of using the regular .bak-format.

What's the difference?
Those "scripts" will create a completely new and empty database, means the .ldf (Log-File) is empty (the most releases do have a .bak with full of unnecessary stuff), so you wont get any errors like "The .bak is too big for SQL Express" or similar.
Also those .sql-files are compatible with every SQL Server version out (e.g. SQL 2005, SQL 2008, etc...).

INFO:

• The Auth in this release is originally the Auth by Pyrok's 6.2(?) release, it does NOT contain the IPBan-table.
• To create the Arcadia-database, run the Arcadia-Structs.sql, then the Arcadia-Content.sql
• Don't use this script if you already have an Auth/Arcadia/Telecaster, it will drop those!

Just double-click on the .sql-file and click on execute (or press F5).

I didn't test them, so if there are any issues, please post them here.

Download:

Sincerely yours,

Xijezu.

[eziorav]

Thanks Xijezu for this release
i thought that you've left rappelz @_@
welcome back

[c1ph3r]

1. Correct me if i'm wrong but there are missing a lot of indexes in the telecaster script^^ Looks like your break was too long :P

2. I allready released the complete 8.1 telecaster script.

I added the official 8.1 Telecaster Script with all Indexes for Character DB. This script isn't created by me i found it somewhere in the internet...

And my old IDX Fix for the 7.4 Scripts don't know if this will fix all problems in the 8.1 Script.

[aspergere]

Originally Posted by c1ph3r

1. Correct me if i'm wrong but there are missing a lot of indexes in the telecaster script^^ Looks like your break was too long :P

2. I allready released the complete 8.1 telecaster script.

I added the official 8.1 Telecaster Script with all Indexes for Character DB. This script isn't created by me i found it somewhere in the internet...

And my old IDX Fix for the 7.4 Scripts don't know if this will fix all problems in the 8.1 Script.

How put telecaster 8.1.sql in my telecaster.bak ??
Dont any understand

[speedkaka13]

you're a Great German Legend thanks so much.
nice release

[thund22222]

The subject of the beautiful and fabulous, but I don't know why this table IPBan.

[TheOnlyOneRaskim]

Originally Posted by speedkaka13

you're a Great German Legend thanks so much.
nice release

Calm down, he's only a Human like all other. o.0

[skullman1919]

can someone help me i try to put all 3 files in mine sql server
but some dont work ( arcadia+auth+telecaster)

can anyone send me the files for a 8.1 server plz (working plz)

[stt_blaine]

can someone help me i try to put all 3 files in mine sql server
but some dont work ( arcadia+auth+telecaster)

can anyone send me the files for a 8.1 server plz (working plz)

[skullman1919]

Originally Posted by stt_blaine

is it a english version ?

and where is the auth file ?

and the telecaster file dont work getting this error
TITLE: Microsoft SQL Server Management Studio
------------------------------

Specified cast is not valid. (SqlManagerUI)

------------------------------
BUTTONS:

OK
------------------------------

plz help me

[thund22222]

Originally Posted by skullman1919

is it a english version ?

and where is the auth file ?

and the telecaster file dont work getting this error
TITLE: Microsoft SQL Server Management Studio
------------------------------

Specified cast is not valid. (SqlManagerUI)

------------------------------
BUTTONS:

OK
------------------------------

plz help me

Use SQL 2012 full version you can choose full version during the installation of the Program.

[skullman1919]

Originally Posted by thund22222

Use SQL 2012 full version you can choose full version during the installation of the Program.

i use x32 setup

if i run that version i get a error

TITLE: Microsoft SQL Server 2012 Service Pack 1 Setup
------------------------------

The following error has occurred:

There is a problem with this Windows Installer package. A DLL required for this installation to complete could not be run. Contact your support personnel or package vendor.

plz help me

and the i click ok then this error comes up

TITLE: Microsoft SQL Server 2012 Service Pack 1 Setup
------------------------------

The following error has occurred:

Service 'SQL Server VSS Writer' (SQLWriter) failed to start. Verify that you have sufficient privileges to start system services.

someone can help me with it

[ThunderNikk]

Originally Posted by skullman1919

i use x32 setup

You need 64 bit.

[skullman1919]

Originally Posted by thndr

You need 64 bit.

mine pc is maybe weird it say i use a 64bit but when i look in mine C:map

then i got a progam files and progam files x86

and x86 is 32bit ( i think)

[GetRealLifeBear]

Nice Release