SharePoint - SharePoint & SQL Backup

The SQL Server that I was using for SharePoint just crashed down. I
restored it using backups but now SharePoint will not connect to it. Any
ideas?

  Shady Khorshed replied...

Hi Artificer,

same problem happened to me and finally i discovered that the SQL backup
will not restore the functionality of the MOSS application, so we decided to
take daily MOSS backups not SQL backup



Regards,
Shady Khorshed

  Mike Walsh replied...

There are lots of SharePoint products and versions (and even several SQL
Server versions that work with them)

So which SharePoint product/version and which SQL Server version are you
asking about ?

Mike Walsh
WSS FAQ www.wssfaq.com / wss.collutions.com
no private e-mail questions please

  Artificer replied...

Sharepoint 2007 enterprise on server farm configuration & SQL Server
2005 enterprise edition!

MOSS 2007 fails during full installation even id 27745 SharePoint We have SQL 2008 installed on separate machine but in same domain, installed all as per the instructions here http: / / blogs.msdn.com / sharepoint / using full installation. Started wizard, inserted sql server \ instance name, username / password, port number. It starts but hangs on second stage. Looks like something went wrong with creation AdminContent database. SQL Databases show following databases:Sharepoint_config and long one having Admin_content. Did I miss something making fresh installation? I've installed sharepoint 2007 before on other 2 machines (one for MOSSportal and second with SQL2008 with instance everything went fine but now. . . . Errors in EvenViewer: 1) Event Type: Error Event Source: Windows SharePoint Services 3 Event Category: General Event ID: 27745 Description: The description for Event ID ( 27745

Using Sharepoint 2010 for data storage but still running full Access client with vba and normal forms SharePoint Some time ago, Albert Kallah wrote that with Access 2010 it was possible to store access 2010 data on Sharepoint 2010 but still run the Access client in windows much as a "normal" access client accessing the data on Sharepoint 2010. sits on SharePoint. You can also have the application sit on SharePoint and a copy gets pulled down sure local machine when you click on and on the SharePoint site, you will need access installed for this to occur. So, in this case we physically separated. Previously you had to limit Access users to a LAN, or use terminal server or maybe even replication via the internet. This seems much slicker. Again my interest is

MOSS Search crashing after Infrastructure Update SharePoint Issue: Each morning our search in MOSS 2007 sp1 has crashed. This is people search do with the backup process since it seems to occur sometime at night. We do SQL DB Maint. Plan that only backs up the db's (no reorg of indexes etc in the logs: 11 / 11 / 2008 16:18:26.92 w3wp.exe (0x0594) 0x1350 Windows SharePoint Services Web Parts 89a1 Monitorable Error while executing web part: Microsoft.Office.Server.Search.WebControls.SrhdcGenericException: Your search cannot be completed because of a service error. Try your or contact your administrator for more information. - --> System.TypeInitializationException: The type initializer for 'Microsoft.Office.Server.EvaluatorModeProvisioning.OfficeServerProductToProvision' threw an exception. - --> System.Security.SecurityException: Request for the permission of type 'System at System.Reflection. . . 11 / 11 / 2008 16:18:26.92* w3wp.exe (0x0594) 0x1350 Windows SharePoint Services Web Parts 89a1 Monitorable . . . . Assembly.VerifyCodeBaseDiscovery(String codeBase) at System.Reflection.Assembly.GetName(Boolean copiedName) at System.Reflection.Assembly.GetName() at Microsoft.Office.Server.EvaluatorModeProvisioning.OfficeServerProductToProvision. . ctor(String id, String name, String provisioningAssemblyWithoutExtention, String fullyQualifiedProvisioningClass) at Microsoft.Office Server.EvaluatorModeProvisioning.OfficeServerProductToProvision. . cctor() The action that failed was: Demand The type of the first permission

EWA - Error displaying Excel chart SharePoint I am getting following error when trying to load a pivot chart using Excel web persists. Here is the other information 1. The excel sheet is having ODC connection to Sharepoint List. 2. I am using SSO 3. The connection is lying in Trusted Data connection Excel Services Web Front End 6k38 Medium ExcelServerProxy.ExecuteWebMethod: sending request of type OpenWorkbook, to server = http: / / hddlntdmt996523:56737 / SharedPMO / ExcelCalculationServer / ExcelService.asmx, session = (null), state id = 0 04 / 02 / 2008 36 w3wp.exe (0x0974) 0x0754 Excel Services Excel Services Cache 5c9o Medium BaseWorkbook.CacheStream: Fetching Server \ FileCache \ SharedPMO-1036824305 \ 54c5a6ce-c6ca-4413-8a39-d2aa1658ceac.xlsx.xlserver" 00000002-d2e0-0db4-0000-000050f7b00b 1swd Medium BaseWorkbook.LoadWorkbookJob: Loading BaseWorkbook from disk - starting from file C: \ WINDOWS \ TEMP \ Excel Server \ FileCache \ SharedPMO-1036824305 \ 54c5a6ce-c6ca-4413-8a39-d2aa1658ceac.xlsx.xlserver. 00000002-d2e0-0db4-0000-000050f7b00b d2e0-0db4-0000-000050f7b00b 04 / 02 / 2008 16:56:33.66 SSOSRV.EXE (0x0AAC) 0x1408 SharePoint Portal Server SSO 0 Medium CSsoResourceManager succeeded in getting the connection string 04 / 02 / 2008 16:56:33.66 SSOSRV.EXE (0x0AAC) 0x1408 SharePoint Portal Server SSO 0 Medium Provider = SQLOLEDB;Extended Properties = 'Server = HDDLNTDMT996523;Database = SSO;Trusted_Connection = yes

Migrate to New Server SharePoint I'm currently running windows sharepoint services 2.0 on a Windows 2000 server runninh SQL 2000. I want to migrate this to a new server which runs / will run Windows 2003 with windows sharepoint services 3.0. Sharepoint services will be using the windows internal database not full blown SQL on this new