Please start any new threads on our new site at We've got lots of great SQL Server experts to answer whatever question you can come up with.

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | Active Topics | Members | Search | Forum FAQ
Save Password
Forgot your Password?

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

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


United Kingdom
22859 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.

Go to Top of Page
  Previous Topic Topic Next 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.02 seconds. Powered By: Snitz Forums 2000