please help . !!!!

[ERONX]

How can I recover or restore the _char table. Without backup
please help

[ERONX]

Originally Posted by ZαKuRα

add skype

done

[blapanda]

You have two options, either using third-party applications which might or not work, or simply recreate that database with a different name like "SRO_VT_SHARD_EMERGENCY", select the "bugged" table and replace it with the one which is working correctly via replace queries or simply deleting the table content manually and copy & pasting the other content into it.

[genralduk]

Why don't you create back 1 _ New Char?

 Spoiler

USE [SRO_VT_SHARD]
GO

/****** Object: Table [dbo].[_Char] Script Date: 18/11/2017 9:39:27 PM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[_Char](
[CharID] [int] IDENTITY(1,1) NOT NULL,
[Deleted] [tinyint] NOT NULL CONSTRAINT [DF__Char_Deleted] DEFAULT (0),
[RefObjID] [int] NOT NULL CONSTRAINT [DF__Char_RefObjID] DEFAULT (0),
[CharName16] [varchar](64) NOT NULL,
[NickName16] [varchar](17) NOT NULL CONSTRAINT [DF__Char_NickName16] DEFAULT (''),
[Scale] [tinyint] NOT NULL,
[CurLevel] [tinyint] NOT NULL CONSTRAINT [DF__Char_CurLevel] DEFAULT (1),
[MaxLevel] [tinyint] NOT NULL CONSTRAINT [DF__Char_MaxLevel] DEFAULT (1),
[ExpOffset] [bigint] NOT NULL CONSTRAINT [DF__Char_ExpOffset] DEFAULT (0),
[SExpOffset] [int] NOT NULL CONSTRAINT [DF__Char_SExpOffset] DEFAULT (0),
[Strength] [smallint] NOT NULL CONSTRAINT [DF__Char_Strength] DEFAULT (0),
[Intellect] [smallint] NOT NULL CONSTRAINT [DF__Char_Intellect] DEFAULT (0),
[RemainGold] [bigint] NOT NULL CONSTRAINT [DF__Char_RemainGold] DEFAULT (0),
[RemainSkillPoint] [int] NOT NULL CONSTRAINT [DF__Char_RemainSkillPoint] DEFAULT (0),
[RemainStatPoint] [smallint] NOT NULL CONSTRAINT [DF__Char_RemainStatPoint] DEFAULT (0),
[RemainHwanCount] [tinyint] NOT NULL CONSTRAINT [DF__Char_RemainHwanCount] DEFAULT (0),
[GatheredExpPoint] [int] NOT NULL CONSTRAINT [DF__Char_GatheredExpPoint] DEFAULT (0),
[HP] [int] NOT NULL CONSTRAINT [DF__Char_HP] DEFAULT (200),
[MP] [int] NOT NULL CONSTRAINT [DF__Char_MP] DEFAULT (200),
[LatestRegion] [smallint] NOT NULL CONSTRAINT [DF__Char_LatestRegion] DEFAULT (0),
[PosX] [real] NOT NULL,
[PosY] [real] NOT NULL,
[PosZ] [real] NOT NULL,
[AppointedTeleport] [int] NOT NULL CONSTRAINT [DF__Char_AppointedTeleport] DEFAULT (0),
[AutoInvestExp] [tinyint] NOT NULL CONSTRAINT [DF__Char_AutoInvestExp] DEFAULT (1),
[InventorySize] [int] NOT NULL CONSTRAINT [DF__Char_EngagedCOS] DEFAULT (0),
[DailyPK] [tinyint] NOT NULL CONSTRAINT [DF__Char_DailyPK] DEFAULT (0),
[TotalPK] [smallint] NOT NULL CONSTRAINT [DF__Char_TotalPK] DEFAULT (0),
[PKPenaltyPoint] [int] NOT NULL CONSTRAINT [DF__Char_PKPenaltyPoint] DEFAULT (0),
[TPP] [int] NOT NULL CONSTRAINT [DF__Char_TPP] DEFAULT (0),
[PenaltyForfeit] [int] NOT NULL CONSTRAINT [DF__Char_PenaltyForfeit] DEFAULT (0),
[JobPenaltyTime] [int] NOT NULL CONSTRAINT [DF__Char_PenaltyTime] DEFAULT (0),
[JobLvl_Trader] [tinyint] NOT NULL CONSTRAINT [DF__Char_JobLvl_Trader] DEFAULT (1),
[Trader_Exp] [int] NOT NULL CONSTRAINT [DF__Char_Trader_Exp] DEFAULT (0),
[JobLvl_Hunter] [tinyint] NOT NULL CONSTRAINT [DF__Char_JobLvl_Hunter] DEFAULT (1),
[Hunter_Exp] [int] NOT NULL CONSTRAINT [DF__Char_Hunter_Exp] DEFAULT (0),
[JobLvl_Robber] [tinyint] NOT NULL CONSTRAINT [DF__Char_JobLvl_Robber] DEFAULT (1),
[Robber_Exp] [int] NOT NULL CONSTRAINT [DF__Char_Robber_Exp] DEFAULT (0),
[GuildID] [int] NULL CONSTRAINT [DF__Char_GuildID] DEFAULT (0),
[LastLogout] [smalldatetime] NOT NULL,
[TelRegion] [smallint] NOT NULL CONSTRAINT [DF___char__TelRegion__4C2C2D6D] DEFAULT (0),
[TelPosX] [real] NOT NULL CONSTRAINT [DF___char__TelPosX__4D2051A6] DEFAULT (0),
[TelPosY] [real] NOT NULL CONSTRAINT [DF___char__TelPosY__4E1475DF] DEFAULT (0),
[TelPosZ] [real] NOT NULL CONSTRAINT [DF___char__TelPosZ__4F089A18] DEFAULT (0),
[DiedRegion] [smallint] NOT NULL CONSTRAINT [DF___char__DiedRegio__4FFCBE51] DEFAULT (0),
[DiedPosX] [real] NOT NULL CONSTRAINT [DF___char__DiedPosX__50F0E28A] DEFAULT (0),
[DiedPosY] [real] NOT NULL CONSTRAINT [DF___char__DiedPosY__51E506C3] DEFAULT (0),
[DiedPosZ] [real] NOT NULL CONSTRAINT [DF___char__DiedPosZ__52D92AFC] DEFAULT (0),
[WorldID] [smallint] NOT NULL CONSTRAINT [DF__Char__WorldID] DEFAULT (1),
[TelWorldID] [smallint] NOT NULL CONSTRAINT [DF__Char__TelWorldID] DEFAULT (1),
[DiedWorldID] [smallint] NOT NULL CONSTRAINT [DF__Char__DiedWorldID] DEFAULT (1),
[HwanLevel] [tinyint] NOT NULL CONSTRAINT [DF___Char__HwanLevel__6BF3B593] DEFAULT ((1)),
CONSTRAINT [PK__Char] PRIMARY KEY CLUSTERED
(
[CharID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY],
CONSTRAINT [IX__Char] UNIQUE NONCLUSTERED
(
[CharName16] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO