[@RotooW]

Еще раз Здравствуйте
На автомате случайное
Вместо удаления строк в таблице удалил Таблицу

Use RF_User
DELETE from tbl_rfaccount
DELETE from tbl_UserAccount
DELETE from tbl_UserBan
DELETE from tbl_UserBan_Log
DELETE from tbl_UserCount_Log
DELETE from tbl_StaffAccount
Use RF_World_Novus
DELETE from tbl_base
DELETE from tbl_general
DELETE from tbl_Guild
DELETE from tbl_GuildBattleRank
DELETE from tbl_guildbattleresullog
DELETE from tbl_GreetMsg
DELETE from tbl_EventPoint
DELETE from tbl_AccountTrunk
DELETE from tbl_AccountTrunk_Extend
DELETE from tbl_aminepersonal_inven
DELETE from tbl_AccountTrunkCharge
DELETE from tbl_animuslog
DELETE from tbl_animusdata
DELETE from tbl_inven
DELETE from tbl_ItemCharge
DELETE from tbl_itemcombine_ex_result
DELETE from tbl_NpcData
DELETE from tbl_OreCutting
DELETE from tbl_patriarch_candidate
DELETE from tbl_patriarch_comm
DELETE from tbl_patriarch_elect
DELETE from tbl_pcbangitem
DELETE from tbl_PostRegistry
DELETE from tbl_PostStorage
DELETE from tbl_pvporderview

Неподскажите как восстановить

[@Salomey]

Как ты мог ее удалить? Неужели просто запрос этот нельзя было тупо выполнить?
___________________________
ПО ТЕМЕ:

USE [RF_User]
GO

/****** Object: Table [dbo].[tbl_UserAccount] Script Date: 12/22/2012 15:51:05 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[tbl_UserAccount](
[serial] [int] IDENTITY(1,1) NOT NULL,
[id] [binary](16) NOT NULL,
[createtime] [datetime] NOT NULL,
[createip] [char](16) NOT NULL,
[lastlogintime] [datetime] NOT NULL,
[lastlogofftime] [datetime] NOT NULL,
[totallogmin] [int] NOT NULL,
[lastconnectip] [char](16) NOT NULL,
[pushclosetime] [datetime] NOT NULL,
[pusherip] [char](16) NOT NULL,
[JoinCode] [int] NOT NULL,
[LoginFailureCnt] [tinyint] NOT NULL,
[fire_on] [smalldatetime] NOT NULL,
[fire_warning] [smalldatetime] NOT NULL,
[uilock] [tinyint] NOT NULL,
[uilock_pw] [binary](13) NOT NULL,
[uilock_failcnt] [tinyint] NOT NULL,
[uilock_update] [smalldatetime] NOT NULL,
[uilock_hintindex] [tinyint] NOT NULL,
[uilock_hintanswer] [binary](17) NOT NULL,
[uilock_find_pass_failcnt] [tinyint] NOT NULL,
[gpoint] [int] NOT NULL,
CONSTRAINT [PK_tbl_rfuser] PRIMARY KEY CLUSTERED
(
[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY],
CONSTRAINT [IX_tbl_rfuser] UNIQUE NONCLUSTERED
(
[serial] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO

ALTER TABLE [dbo].[tbl_UserAccount] ADD CONSTRAINT [DF_tbl_rfuser_CreateTime] DEFAULT (getdate()) FOR [createtime]
GO

ALTER TABLE [dbo].[tbl_UserAccount] ADD CONSTRAINT [DF_tbl_rfuser_createip] DEFAULT ((0)) FOR [createip]
GO

ALTER TABLE [dbo].[tbl_UserAccount] ADD CONSTRAINT [DF_tbl_rfuser_LastLogTime] DEFAULT (getdate()) FOR [lastlogintime]
GO

ALTER TABLE [dbo].[tbl_UserAccount] ADD CONSTRAINT [DF_tbl_rfuser_lastlogintime1] DEFAULT (getdate()) FOR [lastlogofftime]
GO

ALTER TABLE [dbo].[tbl_UserAccount] ADD CONSTRAINT [DF_tbl_rfuser_TotalLogMin] DEFAULT ((0)) FOR [totallogmin]
GO

ALTER TABLE [dbo].[tbl_UserAccount] ADD CONSTRAINT [DF_tbl_rfuser_lastconnectip] DEFAULT ((0)) FOR [lastconnectip]
GO

ALTER TABLE [dbo].[tbl_UserAccount] ADD CONSTRAINT [DF_tbl_rfuser_pushclosetime] DEFAULT (getdate()) FOR [pushclosetime]
GO

ALTER TABLE [dbo].[tbl_UserAccount] ADD CONSTRAINT [DF_tbl_rfuser_pusherip] DEFAULT ((0)) FOR [pusherip]
GO

ALTER TABLE [dbo].[tbl_UserAccount] ADD CONSTRAINT [DF_tbl_rfuser_JoinCode] DEFAULT ((0)) FOR [JoinCode]
GO

ALTER TABLE [dbo].[tbl_UserAccount] ADD CONSTRAINT [DF_tbl_useraccount_loginfailurecnt] DEFAULT ((0)) FOR [LoginFailureCnt]
GO

ALTER TABLE [dbo].[tbl_UserAccount] ADD CONSTRAINT [DF_tbl_useraccount_fire_on] DEFAULT (getdate()) FOR [fire_on]
GO

ALTER TABLE [dbo].[tbl_UserAccount] ADD CONSTRAINT [DF_tbl_useraccount_fire_warning] DEFAULT (getdate()) FOR [fire_warning]
GO

ALTER TABLE [dbo].[tbl_UserAccount] ADD CONSTRAINT [DF_tbl_useraccount_uilock] DEFAULT ((0)) FOR [uilock]
GO

ALTER TABLE [dbo].[tbl_UserAccount] ADD CONSTRAINT [DF_tbl_useraccount_uilock_pw] DEFAULT ((0)) FOR [uilock_pw]
GO

ALTER TABLE [dbo].[tbl_UserAccount] ADD CONSTRAINT [DF_tbl_useraccount_uilock_failcnt] DEFAULT ((0)) FOR [uilock_failcnt]
GO

ALTER TABLE [dbo].[tbl_UserAccount] ADD CONSTRAINT [DF_tbl_useraccount_uilock_update] DEFAULT ((0)) FOR [uilock_update]
GO

ALTER TABLE [dbo].[tbl_UserAccount] ADD CONSTRAINT [DF_tbl_useraccount_uilock_hintindex] DEFAULT ((0)) FOR [uilock_hintindex]
GO

ALTER TABLE [dbo].[tbl_UserAccount] ADD CONSTRAINT [DF_tbl_useraccount_uilock_hintanswer] DEFAULT ((0)) FOR [uilock_hintanswer]
GO

ALTER TABLE [dbo].[tbl_UserAccount] ADD CONSTRAINT [DF_tbl_useraccount_uilock_find_pass_failcnt] DEFAULT ((0)) FOR [uilock_find_pass_failcnt]
GO

ALTER TABLE [dbo].[tbl_UserAccount] ADD CONSTRAINT [DF_tbl_UserAccount_gpoint] DEFAULT ((0)) FOR [gpoint]
GO

[@RotooW]

как я ее могу удалить , на Автомате Делит и все)
Вопрос по запросу , если я удалю еще каку ю то таблицу , в этом запросе нужно будет поменять только Корни ?
или вообще как сделать полное восстановление , т.е восстановить все таблицы которые были удалены ?

[@Salomey]

Сообщение от RotooW

как я ее могу удалить , на Автомате Делит и все)
Вопрос по запросу , если я удалю еще каку ю то таблицу , в этом запросе нужно будет поменять только Корни ?
или вообще как сделать полное восстановление , т.е восстановить все таблицы ?

Нет... там процедуры разные совсем и колонки.

[@4a4i]

из бэкапов, если конечно ты их делал.

[@Salomey]

Сообщение от 4a4i

из бэкапов, если конечно ты их делал.

Я более, чем на 100% уверен, что бекапов нет, да не суть, он мне в ЛС отписал уже.