SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Recovering Deleted Databases
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

blaupaunc
Starting Member

1 Posts

Posted - 06/14/2006 :  09:02:43  Show Profile  Reply with Quote
Hi guys,
Our company knowledgebase resides in the sharepoint services database in sql server.The name of the database is sharepoint.It was created when we installed the sharepoint services in the system.All our knowledgebase that we upload to the sharepoint web application is stored in this database.when we did a reinstallation of sharepoint services for the installation of a project server the sharepoint database in the sql server got deleted and the new installation created a new database by the same name but the data is missing.We dont have any backups of the old database.Is there anyway to recover the database by using any tools or by any other methord.Any valuble suggessions???I need help.

Thanks in advance
Blauapaunc

Kristen
Test

United Kingdom
22403 Posts

Posted - 06/14/2006 :  09:55:55  Show Profile  Reply with Quote
Is it possible that an automated backup was running for SQL Server that picked up all databases? if so there may be backup files available (which will be deleted after their retention time expires).

Other than that you are looking at normal disk recovery tools - the more you use the machine in the meantime the less the chance of recovering the files.

If SQL Server has reused the database (rather than deleting it and creating a new one) and you have no backup files then I doubt there is anything left.

A tape backup may have some information (i.e. of the native MDF / LDF files), although the files will have been in-use was SQL Server was running. However, if there is a tape backup from when SQL Server was stopped, for any reason, that would be useful as the files would not have been in use.

Kristen
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000