Hello, a user is missing a document and the user is sure the document was on a given site for 1-2 month ago. We have daily backup of the databases, but it is only the pure databases (from MSSQL). I have a test sharepoint 2007, can i just replace the databases with the restored databases and then grab the document or how ? JakobJakob Olsen

Jakob, On your test SharePoint 2007 farm, create a web application the same as your live server. Then restore your SQL content database backup (usually wss_content_guid or whatever you named it) to your test SQL server. Then under 'Content Databases' in application management you need to 'Add content database', enter the name of your restored content db and the server name for your test SQL instance. You should now be able to browse the website with an account with relevant permissions to the web application. You may wish to create a local HOSTS file entry to fool your machines DNS to point to the test web application. Regards, ConradConrad Goodman MCITP SA / MCTS: WSS3.0 + MOSS2007

Jakob, On your test SharePoint 2007 farm, create a web application the same as your live server. Then restore your SQL content database backup (usually wss_content_guid or whatever you named it) to your test SQL server. Then under 'Content Databases' in application management you need to 'Add content database', enter the name of your restored content db and the server name for your test SQL instance. You should now be able to browse the website with an account with relevant permissions to the web application. You may wish to create a local HOSTS file entry to fool your machines DNS to point to the test web application. Regards, ConradConrad Goodman MCITP SA / MCTS: WSS3.0 + MOSS2007

Jakobdo yes, all documents and their versions are stored in content database. So if you will attach backup of content database to existing testing Sharepoint environemnt, you will be able to copy this document. Check this article for details: Add, split, and merge content databases (Office SharePoint Server 2007) . Just ensure that your existing production environment will not have access to your testing environment. In other case there can be a risk that you production environment will accidentally use content database from test environment and it will be not easy to fix it.Blog - http://sadomovalex.blogspot.com CAML via C# - http://camlex.codeplex.com Graphs visualization in Sharepoint - http://spgraphviz.codeplex.com

Hello Conrad, i have restored the db. Made a new sharepoint web app. Connected the wss_content_GUID But if i browse: http://dev-server/_layouts/viewlsts.aspx The sharepoint site is empty. :o( How do i then get the info ? Am I missin something ?Jakob Olsen

Verify you have relevant permissions as the logged in account. In central admin, go to appl management, 'Policy for Web application' then add your username with full control for the dev-server web application. Then log back in to the site as this user and see if you can view the content.Conrad Goodman MCITP SA / MCTS: WSS3.0 + MOSS2007

Verify you have relevant permissions as the logged in account. In central admin, go to appl management, 'Policy for Web application' then add your username with full control for the dev-server web application. Then log back in to the site as this user and see if you can view the content.Conrad Goodman MCITP SA / MCTS: WSS3.0 + MOSS2007

Ok, i think i need to share this one... I did the following: Got the wss_content database from the backup system, 1½ month ago. I moved the file to my dev system. The system was installed as a sharepoint 2007 standalone, so i had to install mssql 2005. I did a restore of the database to mssql 2005. I created a new web application i sharepoint central administration. I tried to add the content db to sharepoint, but got the error: Unknown error. In ststadm i got this error: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 25 - Connection string is not valid) I had to create a local sql user, with full access to the db - wss_content. Then I was able connect the contentdb with this in stsadm: stsadm -o addcontentdb -url http://URL -databasename WSS_Content -databaseserver sqlserver -databaseuser ******** -databasepassword ******** I fired up my browser, but got alot of errors. I forgot all the solutions from the live server. (THE F WORD) I tried to get the files from /_layouts/viewlsts.aspx and directly by explorer view to the document libs, but i got the: File not found. I then remembered a nice tool: Sharepoint Manager 2007 - http://spm.codeplex.com/releases/view/22762, i started it, navigated to the new webapp, the right folder and there i found: The Document with a rightclick i got: DOWNLOAD. My day was saved. :o)Jakob Olsen