What is the best practise for SQL 2005 disaster recovery. Pls. assist.
View Complete Post
We are testing the Disaster REcovery scenario for SharePoint 2010 in multi-tenancy environment. The process I did is:
1. Created a sharepoint environment in a multi tenant scenario ( partioned the services while creating) and created few tenants with 1 or 2 site collections. (Parent Farm)
2. Created another environment with the same partioned mode. (DR Farm)
3. Tried to copy the site collection which is utilizing the Managed Metadata and restore it in DR farm along with the Parent Managed Metadata.
Everything is restored without error in the DR Farm (Site Collection and Service application and proxy). But, when I go to the term store (in tenant) I see a message like below:
"The Managed Metadata Service or Connection is currently not available. The Application Pool or Managed Metadata Web Service may not have been started. Please Contact your Administrator. "
Also, the document library's managed metadata column value which was referring to the Managed Metadata it's greyed out (Read-Only).
My question is: How can I restore the service application and make it work and also how can i associate the site collection to use the Service Application which it was referring to previously.
I don't know if I need to restore the subscription also. I am not able to get enough information. In TechNet, w
Ive been tasked with researching adequate backup procedures for a bit of web software that we sell. Its basically a website and an express sql database that is deployed onto a customer server. Over the time the databse will fill up with conent and we want
to be able to advise the customer how they can back our software up.
Im wondering we could do nightly backups of the sql server but can this be automated with sql server management studio express?
If not can we do replication or databse mirroring?
Anyway any help would be much appreciated not sure what the best approach is.
A few weeks ago i made a sql backup of all the sql 2008 database (just SharePoint dbs).
Lost that server. Had .baks on a backup drive offsite.
I restored the databases to a new windows server 2008/microsoft sql 2008 database server. I can connect to sharepoint_config.... but without knowing the passphrase I’m stuck.
I’m not sure what the passphrase is and resetting isn’t working (using SharePoint power shell ) due to me not being connected to that farm.
Anything i can do here? Thanks for any help that can be provided.
I've got one Database Server sql 2005, which play also the role of the publisher ; with actually 50 databases.
Each database contains 2 publications (one for desktop, and the second for windows mobile).
This is merge replication.
The way of sync is done with IIS (sqlcesa.dll and replisapi.dll)
I want to be able to be ready if something occurs on my servers.
About the IIS, it's not a problem I guess I can easily duplicate them.
I've got also night backup (.bak) of all the database.
But about the SQL Server database with merge publication, how can I solve the troubles :"my sql server crashs" ?
I read something about peer to peer replication ; is it the solution ? I mean, i create a peer to peer replication between 2 servers on the datacenter. Then I add checks on my applications to be able to switch from server A to B if problem.And if one
crash, I just have to work with the second ; and as soon as the first server is reinstall I just reconfigue the peer to peer between the servers ?
Or is there other solution when there is replication on the server ? (I mean; if it was just a simple database, i'm sure there are easy steps for this).
I want to have a solution that will bring me a service level quality very high if something wrongs happens.
Windows SharePoint Services helps improve collaboration and workflow while protecting documents and intellectual property. But one feature is conspicuously missing - an easy way to back up and restore deleted files from document libraries. In this article, the authors take advantage of the extensibility of WSS and its server-side and client-side object models to build a restore feature that works like the Recycle Bin in Windows Explorer.
Maxim V. Karpov and Eric Schoonover
MSDN Magazine February 2005
I have table A in database A , in table A i have trigger to insert record to database B table A, each update and insert of database A -table A, triiger fire and insert record in database B table A, when i try to update some times asp.net application gives error
"Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding."
and then error log says System.Data.SqlClient.SqlException: Database 'database B is being recovered. Waiting until recovery is finished. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean ret
I am using the ASP.Net password recovery control. By default the user needs to enter their username before an email gets sent out to them.
If it possible instead of entering the username, email is used instead? Alot of my users forgets their username but not email.