Registered users    
MembershipMembership:
Latest New UserLatest:Phil Clarkson
New TodayNew Today:5
New YesterdayNew Yesterday:6
User CountOverall:22929
Private messaging    
You must be logged in to use this module.
Top 10 posters    
NamePosts
Mariette Knap12490
Marina Roos12181
Eriq Neale2071
Michael Patrick1901
Stan Guinn1817
Robert Pearman1720
Nick Pieters1425
Stewart Brown609
Kevin D.563
Eddie Kerr534
Welcome unauthorized visitor    
If you want to join us in the discussions on this forum you need to register first. Registration is free! If you are already a registered user please login to join the forum.
Small Business Server Support Forum    
Forums > Microsoft Smallbusiness Server > SQL Server 2000
Subject: MSDE DB's after restore
Prev Next
You are not authorized to post a reply.

Author Messages
Glyn Emmett User is Offline
Hampshire UK
Member since
10/13/2006

Registered Users
Posts: 33
3/06/2008 08:56 AM  
Hi,
 
Hopefully someone can help me out with an issue I have...
 
Had to restore a server from Backup and the MSDE databases don't appear to have come back correctly.
 
The folders are present under the program files\sql server\... directory but when I try to start the related services for each they fail.
 
I have managed to get SBS monitoring working again by using the SBS setup and re-installed it. That service now starts correctly and is producing the monitoring reports. Which suggests that the underlying MSDE is working.
 
Can anyone tell me the easiest way to bring back on line the db's for SOPHOS, SHAREPOINT and WSUS?
 
Thanks.
Glyn Emmett
Marina Roos User is Offline
The Netherlands
Member since
3/24/2005

Forum Admins
Posts: 12181
3/06/2008 05:12 PM  
Hi Glym,
 
I am wondering about how you did the backup and restore, because with a full backup all should have been restored without a problem. Can you explain exactly what you did?
Marina Roos Smallbizserver.Net AdministratorMission accomplished. We have joined the branch office to our SBS 2003 Headquarters and have the same user experience on the branch office as we have on our local  network at the Headquarters. Want to know how? Signup up for a subscription and get instant access to the article series 'How to add an additional Domain Controller from a remote office to the SBS domain'
Glyn Emmett User is Offline
Hampshire UK
Member since
10/13/2006

Registered Users
Posts: 33
3/06/2008 05:29 PM  
Hi Marina,
 
Sure. The restore was not very clean. The site is using Arcserve and I did the following steps :-
  1. Installed base SBS (CD1).
  2. Installed Arcserve
  3. Restored all sessions in full to C drive.
  4. Rebooted. The server failed just after the boot menu with incorrect hal or dll missing. Not the exact error message but something similar. Every attempt to reboot the server failed. I could press F8 and tried each of the options but nothing worked. 
  5. In the end I booted from CD1 and took the repair option.
  6. This has given me a working system but is not 100% correct. I was running out of time so had to hand it back over to the client so they could continue to operate.
  7. The SBS monitoring is now working but the other MSDE databases aren't.
Any help appreciated.
 
Regards,
Glyn Emmett
Marina Roos User is Offline
The Netherlands
Member since
3/24/2005

Forum Admins
Posts: 12181
3/06/2008 05:59 PM  
Hi Glyn,
 
Seems to me that you didn't have a system state backed up. If you would have used SBS backup, you wouldn't have this problem. Without knowing what errors exactly you have, it will be hard to give you instructions on how to continue, but I think a new install of Sophos, Intranet and WSUS will be necessary.
Marina Roos Smallbizserver.Net AdministratorMission accomplished. We have joined the branch office to our SBS 2003 Headquarters and have the same user experience on the branch office as we have on our local  network at the Headquarters. Want to know how? Signup up for a subscription and get instant access to the article series 'How to add an additional Domain Controller from a remote office to the SBS domain'
You are not authorized to post a reply.
Forums > Microsoft Smallbusiness Server > SQL Server 2000 > MSDE DB's after restore


ActiveForums 3.7
Forum policy    
These Discussion Forums are dedicated to the discussion of the Small Business Server and related server and client software. For the benefit of the community please observe the following posting guidelines:
  1. No Advertising. This includes promotion of commercial products and non-commercial products which are not directly related to Small Business Server and related server and client software.
  2. No Flaming or Trolling.
  3. No Profanity, Racism, or Prejudice.
  4. Site Moderators have the final word on approving/removing a thread or post or comment.
Copyright 2002-2008 Concentrix b.v.    :   Page generated in 0.2343765 seconds.   :   Terms Of Use   :   Privacy Statement