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

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

backup Config Manager

Posted By:      Posted Date: October 06, 2010    Points: 0   Category :Sql Server

The SA is trying to backup the config manager under the maintenance plan.  However, she is getting an error saying it cannot find the path under that backup file.  I was wondering if she even needs to backup the config manager since it is part of the management studio application.  Does anyone know if it needs to be backed up or not?

Thank you for your help.

View Complete Post

More Related Resource Links

custom role manager, type error in Web.config

Hello everybody.I am developping a role provider for AD.I have copy in the root directory of my project in VS2010 the file MyAdamRoleProvider.vb which is an example of a book.I have declared in my web.config the role provider like this: <connectionStrings> <add name="ADService" connectionString="LDAP://webcubedev/OU=webcube,DC=wcdev,DC=local"/> <add name="ADServiceRole" connectionString="LDAP://webcubedev/OU=webcube,DC=wcdev,DC=local"/> </connectionStrings> <system.web> <roleManager enabled="true" defaultProvider="ActiveDirRP"> <providers> <add name="AspNetActiveDirectoryMembershipProvider" type="MyAdamRoleProvider" connectionStringName="ADService" connectionStringRoleName="ADServiceRole" /> </providers> </roleManager> When I debug, the error is "Impossible de charger le type 'MyAdamRoleProvider'"In english : "can't load 'MyAdamRoleProvider' type"I don't see what is wrong, can you help me?

SQL Server Analysis Services Backup error "Errors in the metadata manager. Either the database with


I get the following error when this perl script tries to backup the database using ASCMD.exe 2008 command line tool

<return xmlns="urn:schemas-microsoft-com:xml-analysis"><root xmlns="urn:schemas-
microsoft-com:xml-analysis:empty"><Exception xmlns="urn:schemas-microsoft-com:xm
l-analysis:exception" /><Messages xmlns="urn:schemas-microsoft-com:xml-analysis:
exception"><Error ErrorCode="3239313412" Description="Errors in the metadata man
ager. Either the database with the ID of &#39;xyz_old&#39; does not exi
st in the server with the ID of &#39;ABCD\Sql_AS&#39;, or the user doe
s not have permissions to access the object."
Source="Microsoft SQL Server 2008
Analysis Services" HelpFile="" /></Messages></root></return>

I have tried using different account for impersonation but everything fails.

Any help would be really appreciated.


Best Practices for SQL Backups - Snapshots vs Replay Manager vs SQL Maintenance Plans vs Backup Exec

Hi, can anyone give me some information on the best practice for backing up sql backups?  For example, is it better to use snapshots vs SQL Maintenance plans, etc.  Any info is greatly appreciated.

Thank You!

FileGroup Backup Using IBM Tivoli Storage Manager!

Hello Guys

My company is using IBM Tivoli Storage Manager for sql server backup/restore operations. I just need to know is there a way to use sql server filegroup backup option using this tool.

Let me quickly share the overall requirement with you; we want to take backup of specific sql server tables using IBM Tivoli Storage Manager. My first query; is this possible using this tool. If yes then how? or is there any other workaround available?

-Salman Shehbaz.

Config Manager gives error "The specified module could not be found. [0x8007007e]"

I've been using SQL Server 2008 Express Edition on my development pc for several months now.  It has recently started giving me an error when I attempt to run the SQL Server Configuration Manager  (SQLServerManager10.msc).  I have uninstalled completely and reinstalled twice which has not solved the problem.  I can run the Management Studio just fine and everything works, I just can't run the Configuration Manager which is an issue.

Full error message is as follows:

Cannot connect to WMI provider.  You do not have permission or the server is unreachable.  Note that you can only manage SQL Server 2005 and later servers with SQL Server Configuration Manager.
The specified module could not be found. [0x8007007e]

I have tried the workaround listed here: https://connect.microsoft.com/SQLServer/feedback/Workaround.aspx?FeedbackID=443459 however I did not have a sqlmgmproviderxpsp2up.mof file in my local install.  I copied the one from my production installation and ran the mofcomp.exe program successfully but it did not solve the issue.

Clean Web.Config Files (VS 2010 and .NET 4.0 Series)

.NET 4 includes a new version of the CLR, and a new .NET 4 specific machine.config file (which is installed side-by-side with the one used by .NET 2, .NET 3 and .NET 3.5).

The new .NET 4 machine.config file now automatically registers all of the ASP.NET tag sections, handlers and modules that we've added over the years, including the functionality for:

.ASP.NET Dynamic Data
.ASP.NET Routing (which can now be used for both ASP.NET WebForms and ASP.NET MVC)
.ASP.NET Chart Control (which now ships built-into ASP.NET V4)
What this means is that when you create a new "Empty ASP.NET application" project in VS 2010, you'll find that the new default application-level web.config file is now clean and simple:

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:

browser gives jibberish when State manager (sql) is turned on


Hi all, we're testing our web app with a state manager so that we can do distributed rollouts. We're not getting any errors, but we are getting jibberish returned for every page request. 

(it won't even let me paste it in here)

HOw do I get it to serve the pages normally?


reading values from config files in NUnit tests


One of my NUnit tests has to read in some values from config files.  In my main application this process works perfectly well, however when I run the unit test, the code that reads in the values from the config files doesnt read anything in.  Ive tried putting app.config in my unit test project (I even tried web.config) but nothing seems to work.  Are there any special steps involved when reading from config files in an nunit test ?

NUnit and config files


Ive created an NUnit test project in my solution and have added 3 tests.  They all fail with the same error

SetUp : System.TypeInitializationException : The type initializer for 'Systems.Utils.ConstantHelpers' threw an exception.
  ----> System.NullReferenceException : Object reference not set to an instance of an object.


SetUp : System.TypeInitializationException : The type initializer for 'Systems.Utils.ConstantHelpers' threw an exception.

  ----> System.NullReferenceException : Object reference not set to an instance of an object.

heres the test method

        public void CreateDataContext_ConnectionString_ReturnsDataCon

Getting users list reporting to manager from LDAP


Dear All,

I need to get list of users reporting to a particular manager from the Active directory.

In the active directory there is manager property with contains the data in the following way.


Please help me in building the filter condition.

I am using the following

pUserName="Gegore Lid";

strSearch = "(&(objectClass=user)(objectCategory=user)((Manager cn=" + pUserName + "))";

DirectorySearcher dSearcher = new DirectorySearcher(dEntry, strSearch);

            //Account properites to load
            string[] arrPropertiesToLoad = { "displayName", "department", "manager", "sAMAccountName", "EmployeeNumber", "Title" };

          SearchResultCollection sResultColl = dSearcher.FindAll();

 the above code is not returning any result.

Please help me in this.



Getting list of users reporting from specific Manager from Active Directory


Dear All,

I am have requirement like displaying all the user information reporting to specific manager from Active Directory.

Please help me regarding this.



Modifying connection String in Web config using Install Wizard



Im trying to create a Web Deployment Project, the built in setup and deployment is very good in Visual Studio, i need to able to add an additional step in the setup to change the connection string in the Web config file. Ive seen a lot of articles on how to do this and in particular this http://weblogs.asp.net/scottgu/archive/2007/06/15/tip-trick-creating-packaged-asp-net-setup-programs-with-vs-2005.aspx#7162670 I am however stuck on the final part of this tutorial, im using the code Scott provided but have two errors,  heres part of my code where the errors are

using System;
using System.Configuration;
using System.Configuration.Install;
using System.ComponentModel;
using System.Diagnostics;
using System.IO;
using System.DirectoryServices;

 void ConfigureDatabase(string targetSite, string targetVDir, string connectionString)
            // Retrieve "Friendly Site Name" from IIS for TargetSite
            DirectoryEntry entry = new DirectoryEntry("IIS://LocalHost/" + targetSit

Web deployment project - web.config section replacement does not add remove tag


I have a web application that is actually installed as a component of a third party site.  In some configurations, I need to remove certain connection strings and re-add them.  I'm replacing this web.config section with a xml file that includes the following:

      <remove name="MyOverridenConnection"/>
      <add connectionString="Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=MyDb;Data Source=MyServer" name="MyOverridenConnection"

For some reason the remove tag is left out during the substitution and I end up with the following in the installed config:

      <add connectionString="Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=MyDb;Data Source=MyServer" name="MyOverridenConnection"

Is there any way to issue removes in replaced sec

Toolbox: Easy File Backup, Exploring Files And Folders Inside Visual Studio, Multiple Monitor Softwa


If the responsibility for creating, managing, and executing routine backups is yours, these tools will make it easier. Also see how you can browse folders and files from inside Visual Studio.

Scott Mitchell

MSDN Magazine May 2009

Going Places: How Connection Manager Connects


Marcus Perryman explains the correct use of Connection Manager when a Windows Mobile application requires network data.

Marcus Perryman

MSDN Magazine December 2008

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