oranco
asked on
WSS 3.0 - where is the database stored?
Hi,
We did an WSUS update yesterday which resulted in the the disconnection of WSS 3.0 from the database. This problem has been addressed on EE previously at:
https://www.experts-exchange.com/questions/23355279/WSS-3-0-Cannot-connect-to-the-configuration-database.html
My problem is that in order to start this process i need to back up my database. I cannot open it via the sharepoint admin page. I also cannot find an instance of SQL running on that server to connect to. We also tried using the stsadm but since there is no connection between Wss 3.0 and the database, it returned an error that it couldnt locate the farm.
Where else should we be looking?
thanks
O
We did an WSUS update yesterday which resulted in the the disconnection of WSS 3.0 from the database. This problem has been addressed on EE previously at:
https://www.experts-exchange.com/questions/23355279/WSS-3-0-Cannot-connect-to-the-configuration-database.html
My problem is that in order to start this process i need to back up my database. I cannot open it via the sharepoint admin page. I also cannot find an instance of SQL running on that server to connect to. We also tried using the stsadm but since there is no connection between Wss 3.0 and the database, it returned an error that it couldnt locate the farm.
Where else should we be looking?
thanks
O
ASKER
thanks for your message but it is the WSS 3.0 database i have lost, not the WSUS.
I need to find the WSS 3.0 database to back it up before following the instructions laid down in the solution i enclosed above.
I need to find the WSS 3.0 database to back it up before following the instructions laid down in the solution i enclosed above.
OK so how was WSUS Setup via SQL?
ASKER
Hi - forget about WSUS - that's just the cause of this mess. I need WSS
This is for Sharepoint! Hang on let me take a look
Can you look in the following location:
C:\Program Files\Microsoft SQL Server\MSSQL$Sharepoint\Da ta
Is there a database here?
If so follow this article to backup the db:
http://support.microsoft.com/kb/843580
C:\Program Files\Microsoft SQL Server\MSSQL$Sharepoint\Da
Is there a database here?
If so follow this article to backup the db:
http://support.microsoft.com/kb/843580
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
zephyr, you got it... we just found it ourselves by searching for mdf files on the server.
re backups, do you have any idea how to automate them? i run periodic bkups via the CA but manual is not the way i like to do things and backup-exec sharepoint module is too costly!
re backups, do you have any idea how to automate them? i run periodic bkups via the CA but manual is not the way i like to do things and backup-exec sharepoint module is too costly!
you can use a batch script that runs stsadm backup, and schedule it using Scheduled Tasks.
there are lots of options out there.
http://www.codeplex.com/spbackup
http://blog.integrii.net/?p=122
http://msftplayground.com/archive/2008/12/08/scheduling-sharepoint-backup.aspx
i use a batch script similar to this one:
http://docupoint.blogspot.com/2007/02/backup-script-for-sharepoint-2007.html
but modified to report errors.
i also do SQL level backups. if you're using the simple/standalone WSS, i am not sure it supports automated SQL level backups.
you should also be aware of what stsadm & central admin do and do not backup:
http://blog.tomaselfving.com/2009/03/sharepoint-2007-backuprestore-options.html
the first link i posted above seems to handle those things that stsadm by itself does not back up.
there are lots of options out there.
http://www.codeplex.com/spbackup
http://blog.integrii.net/?p=122
http://msftplayground.com/archive/2008/12/08/scheduling-sharepoint-backup.aspx
i use a batch script similar to this one:
http://docupoint.blogspot.com/2007/02/backup-script-for-sharepoint-2007.html
but modified to report errors.
i also do SQL level backups. if you're using the simple/standalone WSS, i am not sure it supports automated SQL level backups.
you should also be aware of what stsadm & central admin do and do not backup:
http://blog.tomaselfving.com/2009/03/sharepoint-2007-backuprestore-options.html
the first link i posted above seems to handle those things that stsadm by itself does not back up.
%systemdrive%\WSUS\MSSQL$W
You are better off using ntbackup
http://blogs.technet.com/sus/archive/2008/05/21/wsus-how-to-backup-and-restore-wsus-using-the-wizard-mode.aspx