Need some SharePoint Help....

[mooseracing]

I trying to test out our full backups I run of MOSS 07 using the command line, stsadm or somethign close to that spelling.


anyway I have a test enviro setup, I try to restore th backups through central admin and they fail everytime. It seems everywhere I read, you just follow through cental admin.

The most common errors were about remote connections not being allowed, but those ended up being syntax errors in my db name (helpful error message). I've gotten so many different errors its drivign me nuts. I just did a backup of my test enviro to see if I was doing a backup/restore right and everythign restored fine except for the project site, which I can handle since I could work that down.

Is there some decent writes up on this. I can't get the simple 4 steps to work.

 

[mooseracing]

This is the common error I get when i use backup and restore in Central Admin....

Object WSS_Content1 (previous name: WSS_Content) failed in event OnPostRestore. For more information, see the error log located in the backup directory. SPException: Cannot attach database to Web application. Use the command line tool or Central Administration pages to attach the database manually to the proper Web Application

If i use stsadm, then I can't rename the server.

All I want to do is take a backup from the production server, throw it in a test enviroment.

 

[mooseracing]

ttt

 

[mooseracing]

Ok... for anyone else out there that runs into issues here is what I have done to get my backup working correctly on another machine.

First off screw MS and Central admin and the stsadm tool. It was worthless for me. Before this is all said and done I will still be looking into backup software solution thats not built into MOSS 07.

Basically I install MOSS and MOPS and applied all updates. All this will be done in SQL mgr Tools. I then backed up the WSS_Content DB (may be a different one that is defined for your content DB) and moved it over to the new server. I had to create a new blank DB on the new server named WSS_Content. You may have to delete any WSS_Content there is on your test server. Also check the overwrite option, otherwise it won't overwrite any data there, ask me how I know, sometimes it did and other times it didn't.

I did an iisreset, checked my SP page and couldn't get in. Don't forget to chagne the Site Farm Collection Admins, now I can get in. Also now my IT page isn't working, just says error. Took me a few mins to figure out what I had orginally done there to be different than the others. Oh yea I installed the HelpDesk Template, oh yeah I remember reading templates don't move with backups. So go through the extraction process of setting up your templates. Yay it works again.

I'm taking a break from this right now, as I've spen 2-3 days on backup and restore in between other IT work. I now get the joy of getting the Project data restored, hopefully since it goes a little easier but my head needs a break.

Hopefully this tidbit helps someone out there, I couldn't imagine being only a MOSS/MOPS Admin.....