Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
blaupaunc
Starting Member
1 Post |
 Posted - 2006-06-14 : 09:02:43
|
| 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
22859 Posts |
Posted - 2006-06-14 : 09:55:55
|
| 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 |
 |
|
|
|
|
|
Recovering Deleted Databases