Cant Recover Data files

Question

Post reply

Cant Recover Data files

Tzachir

Valued Member

Points: 60
More actions
December 28, 2007 at 10:28 pm

#377748

HI.
I'm using Windows share point services v3 with IIS6.0 with SQL 2005.
when I originally installed all of them the default place where the SQL data files where saved where C drive, after 6 month of using the share point the data got really big and needed to be moved. I’ve mad a backup and moved the file "WSS_Content.mdf" and "WSS_Content_log.ldf" to a new folder, 2 days ago I’ve notice that also a file called "Sharepoint_config" was getting too big and tried to move it too. then it all got messed up, I couldn’t reopen my web, I’ve tried few times and when it was very messy I’ve uninstalled the IIS and WSS and reinstalled them back, I was able to recover my back up file (from 2 month ago). I saved the latest file I’ve had before the changes called "wss_content.mdf", when I recover the previous version and I try to attach the latest file instead of the one in the backup I couldn’t reopen the web again.
Can anyone tell me how to get back my old data? even not in the form of the website just to be able to pull the files out.

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

Adam Haines SSC-Insane Points: 23217 More actions · Answer 1

Have you tried to reinstall sharepoint services to an existing database?

http://office.microsoft.com/en-us/projservadmin/HA011653991033.aspx

My blog: http://jahaines.blogspot.com

Todd Klindt SSC Journeyman Points: 80 More actions · Answer 2

If WSS_Content.mdf is current and has all of your content then this should be easy. Shut down WSS and IIS and move your Config DB in SQL. Once it's where you want start WSS and IIS back up and rerun the SharePoint Configuration Wizard in Administrative Tools. Tell it you want to connect to an existing Config DB, then point it at your Config DB. If that doesn't work you can reinstall WSS which will create a new Config DB. Just make sure you have SQL configured to create it in the right place. Then you can attach your existing WSS_Content.mdf to the new installation, which will have all of your content.

I haven't tried the first method, but it should work.

Good luck,

tk

Tzachir Valued Member Points: 60 More actions · Answer 3

Hi.

I’ve moved the wss_content db to e drive (originally c driver) then I’ve copied the old Wss_content to the same folder instead of the new, I’ve started the DB content but all I get now when I try to brows thru the iis manager is “that the page cannot be found, HTTP 404 - File not found”, when I go to the explorer I get “An unexpected error has occurred”.

please tell me if i'm using the write lines

C:\Program Files\Microsoft SQL Server\90\Tools\binn

sqlcmd -S \\.\pipe\mssql$microsoft##ssee\sql\query -E

ALTER DATABASE SET SINGLE_USER WITH ROLLBACK_IMMEDIATE

go

EXEC sp_detach_db @dbname = 'Content_Database_name'

go

EXEC sp_attach_db @dbname = 'Content_Database_name', @filename1 = 'drive:\path\Data\ _log.ldf'

go

Tzachir Valued Member Points: 60 More actions · Answer 4

HI, tks for the help.

I have tried to install it as the article says but surprisingly the step in the article are not as the one when i open the file, the file version that i have is 12.0.4518.1014

Adam Haines SSC-Insane Points: 23217 More actions · Answer 5

I cannot find a better article to demonstrate step-for-step instruction, but there should be a similar option in your version. Different versions may have different looking screens, but the process will always be the same.

If you want to go another route Todd has given solid information on how to remedy your problem. Have you tried what he posted?

My blog: http://jahaines.blogspot.com

Tzachir Valued Member Points: 60 More actions · Answer 6

HI.

Yes i did try Todd’s way but it also didn’t work, I’ve also replayed after his post with all the commands I’ve used.

I’ve tryied also to make it as in the article but still it dose not work, at one point i get stuck and cant move forward.

Any other ideas?

I’ve seen articles about Microsoft SQL Server Management Studio Express do you know if this can help me?

Todd Klindt SSC Journeyman Points: 80 More actions · Answer 7

Tzachir (1/4/2008)
I’ve seen articles about Microsoft SQL Server Management Studio Express do you know if this can help me?

If you don't specify an SQL Server for it to use, WSS v3 uses something called Windows Internal Database (WID). By contrast, MOSS 2007 uses SQL 2005 Express. I know that SQL Server Management Studio Express will work with MOSS, but I have doubt about it working with WID. It's a free download and install so it's at least worth trying.

tk