server wipe

[ApocalypseP]

Hi how do you go about doing a server wipe.


Probibly is simple but i new to this please help
ty

 

[maxpmes]

Hi how do you go about doing a server wipe.


Probibly is simple but i new to this please help
ty

Try use this SQL code:

USE [DATABASE]
GO


Set NoCount On              
Declare @Tabelas Table (Idx Int Identity(1,1), TblName Varchar(100))              
Insert into @Tabelas (TblName)              
Select Table_Name From Information_Schema.Tables Where Table_Type = 'Base Table'               
              
Declare @Start Int              
Declare @End Int              
Declare @Command Varchar(1000)              
              
Select @Start = 1, @end = Max(Idx) From @Tabelas              
While @Start <= @End              
Begin              
  Select @Command = 'Truncate Table ' + TblName + '' From @Tabelas Where Idx = @Start              
   Exec(@Command)              
 Set @Start = @Start + 1              
End

 

[jbrannon2]

or, you could just delete the databases and then restore your initial ones from the original backups you used to begin with

 

[lifestream]

just restoring new clean db is easiest - else you are left with loooads of "log" tables that zone generates.

But alternatively, if u just wanna wipe char data - in SSMS look for RF WORLD inventory table, accounttrunk, general, base, guild, buddy - rightclick on them -script as - drop and create-new window. And run the script u get for each table. Also do that for rf user useraccount table.

It resets the tables and cleans them. But db is still full of junk.

 

[ckdut]

delete your database RF_NOVUS and restore it again