.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
david stephan
Post New Web Links

Backup of ShareService Provider database using Central Admin fails

Posted By:      Posted Date: October 21, 2010    Points: 0   Category :SharePoint
 
Anybody have an idea of what causes this?  It's very consistent on one of my farms.


View Complete Post


More Related Resource Links

Backup through Central Admin fails; works using stsadm

  
Hi, I'm trying to schedule automatic backups of my SharePoint 2007 site.  I wrote a .vbs script that does the backup with the following line:   objShell.Run "cmd /c stsadm.exe -o backup -directory """ & BACKUP_DIR & SITE_DIR & """ -backupmethod full -item ""Farm\Windows SharePoint Services Web Application\SharePoint - SharePointSites"" > """ & CURR_DIR & "log.txt""", 0, True   I ran the vbs script from the command line and everything worked fine.  I used the Windows Task schedule to run the script as a scheduled task.  The script ran fine and the backup completed successfully (according to the logs), but now if I go to the Central Admin page and try to do a restore, I get the error:   The backup/restore job failed. In order to rerun the backup/restore the timer job must be deleted from the Timer Job Definitions page. Failure Message: Backup or restore is already running.   The odd thing is I can do another backup or restore using stsadm at the command line and it works fine.  I can also run the scheduled task to do another backup and that works fine too.  I just can't do any backups or restores from Cetnral Admin anymore.   Any suugestions or ideas? Thanks. -Cynthia

Full Farm Backup Fails on Windows Sharepoint Services Search Database

  
I am just now starting to us central administration to backup the entire sharepoint farm.  All content backups fine except for the Search Database.  In looking through the backup log, it appears that the search database may not exist.  How can I determine if the search database actually does exist and if it does not can it be recreated?

Central Admin Console Fails to Start

  
I recently uninstalled Sharepoint 3 and reinstalled on WHS (Server 2003). After the second installation the Team Page displayed but I could not get the Central Admin console to come up in the browser to configure the system. Just getting a "Cannot display the webpage" message. The URL is http://servername:32184 which is the same as it was for the first installation where it worked fine. Any ideas of what the issue might be?Thanks.Jerry

BackUp and Restore through Central Administration fails

  

Hi,

 

I took the backup through Central Administration.

 

Now I installed MOSS as Server farm installation on 2 different servers.I mean, one is Application server and the second one is the Database server.

While Restoring the Backup :

I could not connect to the Database server.

But if I restore the same backup on a stand alone/Single server installation of MOSS, I could succeed.

 

Hence for a server farm installation of MOSS on 2 different server, Why I could not connecct to the Database server,while restoring ?

 

Is there any special configuration I need to configure for Database server Access.

 

can anybody tell me, the step by step restore process of a backup through Central Administration for the Server farm installation(2 different servers in the farm.).

 

 

Membership Provider - Login fails after change in database name

  

Hi Experts,

I am in the process of deploying an website developed in ASPNet 2.0 and using the login control and membership provider features. The site was deployed fine and was working perfectly till I changed the database name and user name to access the database. I changed the accordingly in the web.config to point to the new database. Everyting is working file except when the user tries to login into the website.

The error log says that login failed because it is trying to open the old database.

Any idea how I can solve the issue? Thanks for your help.

Regards,

Sudipta


BACKUP WITH CHECKSUM against an encrypted database - restore fails

  

I have five databases sitting on a new SQL 2008 R2 server.  The databases originated on SQL Server 7, went through both a SQL 2000 and a SQL 2005 upgrade, and last month were migrated to this new SQL 2008 server.  All five databases are in SQL 2005 compatibility mode.  All five databases are using SQL 2008's full database encryption.

Over the weekend, I changed the page verification of these databases from "torn page" to "checksum".  Nightly full backups were completed on Sunday night, and successfully restored to our reporting and hot-standby servers.  Yesterday, I added the WITH CHECKSUM keyword to the backup jobs.  Nightly full backups ran last night, completed successfully.  The restores of those same backups to reporting and standby FAILED, with several assertion failure messages.

Today, I created a brand new database, in SQL 2008 compatibility mode and "checksum" page verification.  BACKUP WITH CHECKSUM produces a restorable backup.  I then enabled encryption on that database, and did the same BACKUP WITH CHECKSUM operation.  The resulting backup cannot be restored, NOT EVEN on the same server.  The restore appears to complete, giving the normal output stating how many pages it processed, but the "recovery" portion of the restore throws an exception.


Backup distribution database fails

  

 We recently did a windows update on our 2003 server. After the restart, one of our database backup jobs keep hanging. After a little troubleshooting i found that the job gets stuck on distribution database. i am able to backup all the user/system databases, but every time i try to backup distribution database, it just creates a 2kb file and keeps running. I have to manually kill the process. While the backup runs, there is no blocking as well.

The distribution databse is 300 MB and the backups worked fine before the restart.
I have peer to peer replication setup on the machine.

Any clues why i can't backup the database?
Any help would be appreciated.

thanks


Sharepoint SQL migration using restore from central admin backup

  

I have a SharePoint 2007 farm which consists of a single application server and a separate SQL box.

The DB is SQL 2000. The objective is to upgrade to SQL 2008.

I have read countless articles on how to migrate the DB server from 2000/2005 to 2008. There does not seem to be a consensus on which approach is best.  One approach I do not see much written about is one I tried and successfully implemented.

What I did was simply take advantage of the built in backup feature in the central administration site. I performed a full backup of the site and copied the back up to a development server in a different domain.

I then created a new farm in the development environment and pointed to a 2008 SQl database. The only databases in the farm after I created the farm were the config_Db and central administration DB.

Need Oracle Data Provider .CS File for Oracle 10g Database connection !

  

Hi.,

I need a 'Wrapper.cs' file which takes care of the Database connection ( Oracle 10g) where

i can just call the method with my SQL Query

(eg)

Gridview1.DataSource = SampleWrapper.ExecuteDatatable("THE SQL QUERY");

Gridview1.DataBind();

Plz Post the link if there is any open source !    


ERROR [HY000] [Informix .NET provider][Informix]Database locale information mismatch

  

Hi, there is an upgrade to my infimacs server and my web application encounter this error after the infimacs is upgraded.

Below is the information on the server before/after the upgrade.

Before            After

---------       -----------  

Solaris 8      Solaris 10

IDS 9.40     IDS 11.50


The web server where the web application hosted is running IBM Informix Connect 2.81. There is no such error before the upgrade is done.

As a developer, i have IBM Informix Client-SDK 2.90 installed on my local pc and debug the page where the read is needed from infimacs but no such error found.

The error come out only when it is hosted on the web server where IBM Informix Connect 2.81 is installed.

I have gone through many articles and it suggest me to set the environement  variable in the server :  DB_LOCALE=en_us.819.

I haven't try this solution but i think that this might not be the best solution.

Is it possible to to to have this settin

SharePoint 2007 Central Admin - blank page, isapimodule error in IIS

  

I've got a Windows 2008 SP2 server runing x64.

When i try to access the SharePoint Central Admin site, I just get a blank page. No errors in the Windows logs, nothing showing up in the SharePoint logs. The IIS log shows a 500 error.

I enabled Failed Request Tracing for the 500 status code, which gives me the following information:

ModuleName IsapiModule

Notification 128

HttpStatus 500

HttpReason Internal Server Error

HttpSubStatus 0

ErrorCode 2147942593

ConfigExceptionInfo 

SQL2008 - Cannot Restore a new database from a full backup of a different one, database in use

  
I am trying to restore a brand new database from a copy of another one and am encountering an error message stating: System.Data.SqlClient.SqlError: The file <Backup source database file location> cannot be overwritten.  It is being used by database <Backup Source Database>. (Microsoft.SqlServer.Smo) I am running the Restore procedure with the REPLACE option and am wondering why it is stating that the source database is the database in use when I am trying to restore and overwrite a completely different database. This issue happens when running the replace both in C# using SMO and when manually restoring with SqlServer Management Studio Interesting note is, the original source database is created / deployed using a database project within VisualStudios 2010 and then deployed to SqlServer through VisualStudios. Any thoughts on why this is happening? Thanks in advance for any help!

Named Pipes provider error - backup script

  
I have a couple of installs of SQL Server 2005 Express.  One thing it doesn't provide is an agent to schedule jobs so I read where you can use Windows job scheduler to execute a batch job to in turn run a sqlcmd file.  I have that working on one server but on the other server I get the dreaded Name Pipes provider error and it goes on to talk about it may not be setup to allow remote connections.  If I check using Surface Configurator it is set to allow remote connections using both tcpip and named pipes.  To my knowledge all I want it tcpip but I enabled named pipes in an effort to get things working. About the only difference I can see is on the working system the database is a named instance (ie. Servername) versus default instance on the non-working system which shows up as (Servername\SQLEXPRESS).  Hopefully I have my terminology right here. Any tips on how to troubleshoot?  Does it depend on the username I am using?  Domain admin or local server admin or what have you? I should mention I can execute the backup script and it does work.  It is when I run the batch job that it fails. The batch job just says "sqlcmd -i d:\MSSQL_Jobs\backup.sql -o d:\Logs\sqlbackup_output.txt"

Can't restore database backup file in my database ? using sql server 2005. please help

  
VERY IMPORTANT i am trying to restore database.bak in sql server 2005 (i know the database.bak was also generated in sql 2005 server) i am trying to restore back up database .bak into the new database i just created in sql server 2005 i have saved my database .bak into c drive and when i select database .bak "From Device", it doesn't get populated in the list below and i see nothing and it keeps on prompting a message "You must select a restore source" Here's the screen shot:   PLEASE HELP..it's really important (i tried restoring database in sql server 2008 and it was sucessful but i am facing this problem in sql server 2005 only)  

Web Application list in Central Admin in 2007

  
Can somebody tell me where Central Admin pulls the data for: Central Administration > Application Management > Web Application List   Somehow, the name for one of my applications has changed, but the URL has remained the same.  The website content itself, the website in IIS, and the content database name all still appear to be intact and nothing has changed there.  Everything seems to be fine, I just happened to notice that the NAME of this one web application has changed and it's really bothering me that it could possibly be pointing to the wrong data.  HELP please!

How to Include Password during Database Backup over Tape

  
Hi All, We have EMC Backup Solution in our organization which does backup of all the databases. I want to know is there any way that i can include the password option whenever Backup runs. I dont want to modify any script at the EMS Backup solution side. I want to do it on the fly.         Mohd Sufian www.sqlship.wordpress.com Please mark the post as Answered if it helped.

Cannot find Manage services under Service Application of Central admin

  
We have Intranet solution based on SharePoint 2010 small farm. Somehow we don't see Manage services on server under the Service Applications in the central admin. Portal seem to work otherwise fine. When we opened the page to browser http://servername:14082/_admin/Server.aspx we received error: Access denied. We have tried to login with Admin, SP_Farm and SP_Admin user, but access denied every time. I checked who have Full user rights in the Central admin. It is SP_Admin Admins of the Sitecollection is SP_admin and Administrator. Why this happens?Kenny_I
Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend