Change font size
It is currently Thu Feb 21, 2019 8:45 pm

Forum rules


{L_IMAGE}
Please only post about software that directly relates to opensim, thank you.



Post a new topicPost a reply Page 1 of 1   [ 3 posts ]
Author Message
 Post subject: Asset SQL server file how do you tell?
PostPosted: Sat Jan 26, 2019 1:27 pm 
Furious Typer
User avatar

Joined: Tue Oct 16, 2012 8:46 pm
Posts: 104
Location: Orlando, Florida
We've been hit hard with Ransomware. We paid a company to remove one version of it then to have another one hit us in 8 hours while the servers were updating... Only thing I was able to rescue before the Ransomware got to it was our SQL server. We're not sure if it is our asset server SQL file or not. Is there a way to tell if it is the asset server SQL file? I bought new servers and we are going to be recording, but if we do have our old regions with our builds on it, it would make life so much better.


Top
 Profile  
 
 Post subject: Re: Asset SQL server file how do you tell?
PostPosted: Sat Jan 26, 2019 1:55 pm 

Joined: Sat May 28, 2016 5:13 am
Posts: 3
Best way is to try to load them via the database tools.

Is it the database file structure or a backup file with .sql ending?

Case 1) database file structure

put those files in the exact same location as they were on the previous installation and use the same version of database software. Let the configuration point to that data directory.

Case 2) backup file with .sql ending

the latter can be tested whether it can be loaded by regular data restore tools.


If both do not help things get complicated, in that case the file structure is corrupted or incomplete.


Top
 Profile  
 
 Post subject: Re: Asset SQL server file how do you tell?
PostPosted: Sat Jan 26, 2019 2:02 pm 
Site Admin

Joined: Sun Jul 04, 2010 8:20 pm
Posts: 480
Sorry to hear of the troubles. Whats inside the sql depends how the grid was configured really. If you had all in one database and used standard assetservice your db might have everything you need with possibly a few exceptions (maptiles, etc)
On the other hand, if you were using fsassets, which does not store assets inside the database, restoration might be more difficult requiring transferring data from backup, etc.


Top
 Profile  
 
Display posts from previous:  Sort by  
Post a new topicPost a reply Page 1 of 1   [ 3 posts ]


Who is online

Users browsing this forum: No registered users and 6 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
cron


Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group
610nm Style by Daniel St. Jules of Gamexe.net