Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 322
  • Last Modified:

Sybase server files have been deleted by mistake!

Hi,
I've a very big problem which is that ost of Sybase server files were deleted. Is there any way to recover from this disaster?
Sybase version 12.5.3 installed on windows 2003 server
P.S: I don't have backup from Sybase directory.
Appreciate fst response.

Thanks in advance,
Ramez Nabil
0
Ramez
Asked:
Ramez
  • 4
  • 3
2 Solutions
 
MASTechnical Department HeadCommented:
Check this site they will do once off recovery job
www.clickzones.net
0
 
Joe WoodhousePrincipal ConsultantCommented:
Which files do you mean? The actual software? You can simply reinstall (and re-patch) that.

Or do you mean Sybase device files which your databases were stored on?

Or database backups written to disk?

Or...?
0
 
RamezAuthor Commented:
Hi Joe,
I mean the installation directory of Sybase (The actual software)
I'v the Sybase devices in another place.
Thanks
0
[Webinar] Cloud and Mobile-First Strategy

Maybe you’ve fully adopted the cloud since the beginning. Or maybe you started with on-prem resources but are pursuing a “cloud and mobile first” strategy. Getting to that end state has its challenges. Discover how to build out a 100% cloud and mobile IT strategy in this webinar.

 
Joe WoodhousePrincipal ConsultantCommented:
You'll need to reinstall, and apply the same patch level that you were using. Or if you have it on any other machine in your workplace (exactly the same version), you can copy it.

That will get you the binaries back. You'll also need:

- the interfaces file (SQL.INI on Windows machines) which is like a hosts file for Sybase. This is much simpler if you always used the same master interfaces file - just copy it from somewhere else.
- the configuration file. If ASE is still running and you can still connect to it, you can write this out using a special command. If not, well, you'll have to manually reconstruct it. Don't get anything wrong.

On UNIX machines you'd also need to recreate the RUN_SERVER file, but on Windows that's all done as services in the registry, so you're fine.
0
 
RamezAuthor Commented:
OK great, i did all of this and i still have the instnces running, but i can't start any backup server, it gives me a msg says: "Access is denied" when i start its service from windows services.
Thanks Joe
0
 
Joe WoodhousePrincipal ConsultantCommented:
Re. Backup Server: check that one isn't already running? Ensure there's an entry for it in your SQL.INI.

Re. ASE: you need to regenerate the config file. You can do this if the instance is still running by connecting to it and running

   sp_configure "configuration file", 0, "restore", "[path and filename to where the config file should be]"
   go


The config file is normally called [SERVER].cfg (replace with your server name), and normally lives in %SYBASE%. (However you can't use that variable in the command above, you'll have to fully expand it and give the absolute path.)
0
 
RamezAuthor Commented:
The problem of backup server which was "Access is Denied" which appears when start the backup server from windows services ,, This problem was fixed by give the user that start the service full control permission on Sybase directory.

Also we have created the config. files.
Thanks a lot guys

Ramez Nabil
0
 
RamezAuthor Commented:
The solution was helpful in starting the Sybase server services and creating the config. files but it was partially as i did start the backup servers on my own.
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now