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


Top 5 Contributors of the Month
Kaviya Balasubramanian
Imran Ghani
Post New Web Links

backup failed!

Posted By:      Posted Date: September 26, 2010    Points: 0   Category :ASP.Net
 

Friends,


when im trying to do backup of my database , i getting backup error messsage, please help me to fix this problem

Error message

Msg 3007, Level 16, State 1, Line 1
The backup of the file or filegroup "mydatabase_Dev" is not permitted because it is not online. BACKUP can be performed by using the FILEGROUP or FILE clauses to restrict the selection to include only online data.
Msg 3013, Level 16, State 1, Line 1
BACKUP DATABASE is terminating abnormally.


i run select * from sys.master_files query and found that all database's are online, and also i deleted my fulltext catalog to fix this problem but still im getting the same error, any suggestion?


more  detail error message

===================================

Backup failed for Server 'servername'.  (Microsoft.SqlServer.SmoExtended)

------------------------------
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.50.1600.1+((KJ_RTM).100402-1540+)&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Backup+Server&LinkId=20476

------------------------------
Program Location:

   at Microsoft.SqlServer.Management.Smo.Bac


View Complete Post


More Related Resource Links

Backup failed for Object Shared Search Index failed in event OnBackup.

  
Hi, Farm level backup completed with 2 errors on SharePoint server 2007 through STSADM command line. Error details: Error: Backup failed for Object Shared Search Index failed in event OnBackup. For more information, see the error log located in the backup directory. Error: Object Shared Search Index failed in event OnPrepareBackup. For more information, see the error log located in the backup directory.     WebException: The current operation timed-out after 3600 seconds. Debug:    at Microsoft.Office.Server.Search.Administration.SearchSharedApplication.Microsoft.SharePoint.Administration.Backup.IBackupRestore.OnPrepareBackup(Object sender, SPBackupInformation args)    at Microsoft.SharePoint.Administration.Backup.SPBackup.RunPrepareBackup(SPBackupRestoreObject node) Error: Object Shared Search Index failed in event OnBackup. For more information, see the error log located in the backup directory.     Object Shared Search Index failed in event OnPrepareBackup. For more information, see the error log located in the backup directory.     WebException: The current operation timed-out after 3600 seconds     WebException: The current operation timed-out after 3600 seconds [26/08/2010 14:23:44]: Debug:    at Microsoft.Office.Server.Search.Administration.SearchSharedApplication.Microsof

Backup/restore Failed don't exist timer jobs

  

According to John Ferringer, i'm moving this post from "SharePoint Products > SharePoint Products and Technologies Forums > SharePoint - Setup, Upgrade, Administration and Operation (pre-SharePoint 2010) > Backup/restore Failed don't exist timer jobs".

Hi Folks, i'm recieving this message when i try to make a site collection/farm/site backup "The backup/restore job failed because there is already another job scheduled. Delete the timer job from the Timer Job Definitions page, and then restart the backup/restore job.". I'm going to central administration/monitoring/timer jobs/check jobs status but i can not find anything.

My scenario:

- W2008 R2 EE

- MOSS 2010 EE

- MOPS 2010

- SQL Serve

Differential backup failed because the previous backup metadata for Database of SQL Server

  

I'm developing a VSS requestor that backs up Microsoft SQL Server, among other things. Full backups and restores work just fine. A differential backup always fails though, giving an error in the event log with Event ID 8197:

"Differential backup failed because the previous backup metadata for Database <dbname> of SQL Server instance <instance> is corrupted"

and the writer is in the state "VSS_WS_FAILED_AT_POST_SNAPSHOT" with error hr=0x800423f4

When my full backup runs, the differential_base_xxx fields in sys.databases are updated and correctly reflect the time that the full backup was taken.

The documentation I have read on the SqlServerWriter says that the metadata is recorded in the VSS event BackupComplete, which is definitely being called. During backup I see the writer state move from waiting for backup complete to stable.

I'm using SQL Server 2008 R2 on Windows 2008 R2. There are no other versions of SQL Server installed on that machine.

Can anyone suggest why this is happening?

thanks

James


Restore database backup with Copy_Only option failed ?

  

When we failed to restore a backup from a BAK file for SQL Server 2008.

 

Then we find that the backup is created by using BACKUP xxxx COPY_ONLY parameter.  When we attempt  to restore from Management Studio (with the database changed to single user mode), we get the error message "There is NOTHING in the "Select the backup sets to restore".

 

We would like to seek your advice on

1) Whether we can restore the database from Management Studio GUI ?

2) If not, can you suggest a SQL Script for the backup ?

 

Thanking you in anticipation.


Backup failed for Server 'MAINSERVER'

  

HI All,

I AM USING SQL EXPRESS 2008 

Whaen i Try from my local Computer to Tack Backup DataBase from Server to my locak Hardisk i found below Error

"Unhandled exception has occurred in your application. if you click the application will ignore this error and attempt to continue. if you click Quit the application will close immediately

Backup failed for Server 'MAINSERVER'

 

ITS URGENT 

 

REGARDS!


Transaction log backup job failed suddenly

  

Hi- 

 

We are using SQL Server 2000. There is a maintenance plan to backup three databases on a daily basis (full-backup) and their transactional log every 4 hours.

All the jobs have been running well, however, since last 3 days the transactional log backup job has been failing for one of the three databases. Transactional logs are stored on same location on disk. 

 

I checked to confirm that there is enough space on the disk. Performed DBCC command on the database and that returned 0 errors.

 

I noticed the following errors:

From SQL server log:

“BACKUP failed to complete the command BACKUP LOG [XXXXXXXXXX] TO  DISK = N'H:\XXXXXXXXXXXXXX.TRN' WITH  INIT ,  NOUNLOAD ,  NOSKIP ,  STATS = 10,  NOFORMAT”

 

From Database Maintenance Plan History:

“[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 3241: [Microsoft][ODBC SQL Server Driver][SQL Server]The media family on device 'H:\XXXXXXXXXXXXXXXX.TRN' is incorrectly formed. SQL Server cannot process this media family. [Microsoft][ODBC SQL Server Driver][SQL Server]BACKUP LOG is terminating abnormally”

Any help would be greatly appreciated. I've been a developer and now have to take c

Restore of database backup done by script failed

  

Hi,

In my C++ application (with MFC) developed in Visual Studio 2010 the user has an option to take a backup of the current database. This is done by executing a Stored Procedure which takes the database name and backup file name as parameters:

CREATE PROCEDURE sp2_backup_database @DATABASE nvarchar(100), @FILENAME nvarchar(260)
WITH ENCRYPTION
AS
SET NOCOUNT ON
Begin
  Exec ('Backup Database [' + @DATABASE + '] TO  DISK = ''' + @FILENAME + '''
      WITH COPY_ONLY, NOFORMAT, INIT,  NAME = ''' + @DATABASE +
      '-Full Database Backup'', SKIP, NOREWIND, NOUNLOAD, STATS = 10')
   Return @@ERROR
End
GO

All this works fine, the backup is done properly by the SP.
What is bothering me is that when trying to make a restore of the database from the backup file the restore fails with a message like (freely translated from Swedish):

"Restore failed for [the SQL Server]. (Microsoft.SqlServer.SmoExtended)
Additional information:
System.Data.SqlClien.SqlError: RESTORE can not process the database [Database-name] since it's in use by this process. It's recommended to use master database during this task."

The only way I can

SMO Backup failed using Sql Server 2008 R2

  

Hello,

To do database backup with C# I am using the following code:

 Server myServer = new Server(new Microsoft.SqlServer.Management.Common.ServerConnection(lServer, lUserID, lPassword));
                Microsoft.SqlServer.Management.Smo.Backup oBackup = new Microsoft.SqlServer.Management.Smo.Backup();
                oBackup.Action = BackupActionType.Database;
                oBackup.Database = lDatabase;
                oBackup.Devices.Add(new BackupDeviceItem(mBackupFileName, DeviceType.File));
                oBackup.Initialize = true;
                oBackup.Checksum = true;
                oBackup.ContinueAfterError = true;
                oBackup.Incremental = false;
                oBackup.LogTruncation = BackupTruncateLogType.Truncate;
         &

Restore Job has been failed with error message as "Skipped log backup file. Secondary DB"

  

We have already configured log shipping on server. But now restore job failed with error message as "Skipped log backup file. Secondary DB"

Kindly provide resolution steps for same.


SQL Server Backup and Restore (video)

  
Restore your full backup, then run a few queries before you keep restoring transaction logs. Brent shows how to use the Standby option for restores.

In this five minute video, Brent demonstrates how to do it by creating a database, populating data, and then showing what disaster recovery is like by doing RESTORE WITH STANDBY.

How to backup SMS from windows mobile Pocket PC to computer

  
How to backup SMS from windows mobile Pocket PC to computer

Many Windows Mobile Pocket PC Phone users could not backup their SMS to txt file or view on computer. I found this software offers a SMS Messages backup solution to Backup all SMS messages for Windows Mobile Phones onto computer and keep them safe. Here is the user's guide:

Sys.Net.WebServiceFailedException: The server method '' failed with the following error:

  

 Hello...

Let's say we have 2 time consuming functions, aaa and aaa1 inside a aspx page.

[WebMethod]
        public static string aaa(int i)
        {
            Thread.Sleep(1000);
            return i.ToString();
        }

        [WebMethod]
        public static string aaa1(int i)
        {
            Thread.Sleep(1000);
            return i.ToString();
        }

 

 

<div>
        <asp:ScriptManager ID="ScriptManager1" runat="server" EnablePageMethods="true">
        </asp:ScriptManager>
        <span id="displayspan"></span>
        <br />
        <input type="button" value=

WebMatrix conversion failed when converting from a character string to uniqueidentifier?

  

I am trying to retrieve xml from a small function in my .cshtml page. Its throwing me an error. This however, runs fine in a console/form environment.

It takes 3 parameters and 1 exception.

myDll.GetXML(year, username, uniqueidentifier, out ex);

When I run this page I get the error, "Conversion failed when converting from a character string to uniqueidentifier."

Or a stack of.

System.Data.SqlClient.SqlException (0x80131904): Conversion failed when converting from a character string to uniqueidentifier.

   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()

   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)

   at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()

   at System.Data.SqlClient.SqlDataReader.get_MetaData()

   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)

   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBeha

Failed to create AppDomain

  

Recently updated my system to use Visual Studio 2010, and projects will no longer compile. All of them give the error "Failed to create AppDomain." Intellisense does not work either (except for standard HTML tags), and individual pages will also not compile.

Points of note:

  • All sites are hosted on UNC shares (although it doesn't work on a new site created on local drive either)
  • Language is mostly C#
  • No explicit code is creating AppDomain objects
  • Sites compiled fine under both VS 2005 and 2008 both before and after VS 2010 installation
  • Sites compile and run fine from the IIS server on the remote machines (one IIS 6, one IIS 7)


Things I've tried (some obviously shouldn't have any bearing on it, but I've tried just about everything that anyone suggested on any forum I could find, most of which seemed to apply to IIS, not VS):

  • renaming/deleting security.config
  • running caspol -reset
  • re-registering asp.net: aspnet_regiis.exe -ua / aspnet_regiis.exe -i
  • removing VS 2005, 2008, 2010, and then re-installing just VS 2010
  • adding the UNC path to the local intranet zone (internet options control panel)
  • adding the UNC path to LocalIntranet_Zone in the ASP.Net 2.0 control panel (runtime security policy/machine/al

helped needed: ASP LDAP authentication failed in IE 8

  

I use the following code to do the user authentication through Active Directory using LDAP.

try
{
entry = new DirectoryEntry("LDAP://" + server, user_name, password);
if (!string.IsNullOrEmpty(entry.Name))
{
EmployeeNetId = entry.Username.Substring(0, 3);

// Retrieve EmployeeId, and Employee Full Name
GetEmployeeId(EmployeeNetId);
}
}
catch
{
EmployeeId = -1;
}

It works for Chrome, Firefox with no problem. But with IE 8, it works sometimes, and failed on some computers. When it failed, I figured that I need to check SSL 2.0 in IE 8 Internet Options.  It's weird because in those computers that IE 8 works, SSL 2.0 is also unchecked.

Am I using some deprecated method? Or How do I specifiy the SSL version options in the LDAP connection?


WCF The Security Support Provider Interface (SSPI) negotiation failed

  

I am using a wcf service that I created, when both hosting machine and the client machine are on the same domain everything works just fine. When I publish the client app to the webserver in the DMZ I am getting the following error:

SOAP security negotiation with 'http://10.0.0.14:3790/Bullfrog/QBService/QBService' for   
target
'http://10.0.0.14:3790/Bullfrog/QBService/QBService' failed. See inner exception  
for more details.The Security Support Provider Interface (SSPI) negotiation failed.


Here is my service main where I set up the service


   

 Uri baseAddress = new Uri("Http://10.0.0.14:3790/Bullfrog/QBService");
      ServiceHost selfHost = new ServiceHost(typeof(QBService), baseAddress);

            try
            {
                selfHost.AddServiceEndpoint(
                    typeof(IQBService

Intermittant error: "A connection attempt failed because the connected party did not properly respon

  

Greetings,

I'm having a doozy of a problem, and can't find a solution.  I have a WFC Web Service installed to a pair of servers, and accessed through a load balancer.  I am accessing the service from an ASP.NET client app, also via WCF.  The Client is not load balanced.

I'm getting an intermittant error:

(Inner Most Exception) System.Net.Sockets.SocketException:  A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond x.x.x.x:80

(Middle Exception) System.Net.WebException: Unable to connect to the remote server

(Outer Exception) System.ServiceModel.EndpointNotFoundException:  Could not connect to http://<MYSite>/<MYApp>/<MYService>.svc. TCP error code 10060: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond x.x.x.x:80.

I can reproduce this error with about 20% reliability if I execute the exact same page request on the client from 2 browsers at the same time.  When the problem occurs, the successful p

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