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

Top 5 Contributors of the Month
Post New Web Links

System databases corrupt recovery?

Posted By:      Posted Date: September 24, 2010    Points: 0   Category :Sql Server

For SQL2K5, If I have for ex. Master or msdb got corrupt/suspect and I need to restore the entire database system? what are the steps I need to follow? If I have a two weeks old master, msdb can I use that and keep all current databases? or I need to restore two week old sytem dbs and all those corresponding user databases two weeks ago?

Please provide steps and how do I recover (using admin console, etc)?


View Complete Post

More Related Resource Links

Cannot rebuild system databases in 2008R2

I'm trying to rebuild system databases, but after installing 2008 R2, this no longer work. Here is what I do: I open a command prompt in the below folder: C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\SQLServer2008R2 Here, I execute: SETUP /ACTION=REBUILDDATABASE /INSTANCENAME=a /SQLSYSADMINACCOUNTS=TK\Tibor /SAPWD=Pa$$w0rd /Q I get below error in the console window: The following error occurred: Exception has been thrown by the target of an invocation. Error result: 1152035024 Result facility code: 1194 Result error code: 43216 Please review the summary.txt log for further details There is no trace of the rebuild in the summary.txt file. A folder *is* however created in the log directory for the rebuild (20100601_163136), and in here I have a file named Detail_ComponentUpdate.txt. In this file, I can find below errorr, which I believe is the root of the problem. Can anybody else perform rebuild? Any ideas or hints? 2010-06-01 16:32:04 Slp: Running Action: ExecuteInitWorkflow 2010-06-01 16:32:04 Slp: Workflow to execute: 'INITIALIZATION' 2010-06-01 16:32:04 Slp: Error: Action "Microsoft.SqlServer.Configuration.BootstrapExtension.ExecuteWorkflowAction" threw an exception during execution. 2010-06-01 16:32:04 Slp: Microsoft.SqlServer.Setup.Chainer.Workflow.ActionExecutionException: Exception has been thrown by the target of an invocation. ---> System.

need help moving System Center SQL Databases to new SQL Server about30 databases to be moved...

We are running various System Center products, SCSM, SCVMM, SCCM, DPM, OPALIS. and a few other servers all using the same SQL server, which currently is a VM. We have configured and built a new Physical box that will replace this. In the past we have moved SQL databases by doing a full backup and then restoring the backup on the new server, then renaming the servers, both network name and internal sql name.  This has worked fine in the past. However I've never had to move 30 databases before, nor have I had to move reporting services. Is there a better method. a recomended method? 

"NT AUTHORITY\SYSTEM" access - to which databases/actions and why?

Subquestion from the question Purpose of "NT AUTHORITY\SYSTEM" login in SQL Server 2005 discussing removal of NT AUTHORITY\System from SysAdmin group in MS SQL Server 2005. Is my SQL Server 2008 R2 "NT AUTHORITY\SYSTEM" login is mapped (right click on --> Properties --> User Mapping) to: user dbo for db AdvenureWorks user "NT AUTHORITY\SYSTEM" for databases - maser - msdb - ReportServer - ReportServerTempDB But no mapping exists for databases tempdb model any manually new created database AdvenureWorks2008 AdvenureWorks2008R2 AdvenureWorksDW AdvenureWorksDW2008 AdvenureWorks2008R2 AdvenureWorksLT AdvenureWorksLT2008 AdvenureWorksLT2008R2 Why such mapping was created for AdvenureWorks but not all other sample databases and newly created databases? Why does ReportServerTempDB requires mapping but not tempdb?

Error While Rebuilding system databases

Hi, I installed my SQL Server with a wrong collation. I tried to rebuild the instance and when i tried doing that I am getting a weird error as given below. ALso the installation is picking the edition as evaluation instead of enterprise, i tried executing the install file and it went through to install a enterprise edition. I am not sure why the installer is picking up the evaluation edition instead of enterprise as the option is set.  Exception summary: The following is an exception stack listing the exceptions in outermost to innermost order Inner exceptions are being indented Exception type: Microsoft.SqlServer.Setup.Chainer.Workflow.NoopWorkflowException     Message:          The state of your SQL Server installation was not changed after the setup execution. Please review the summary.txt logs for further details. SugeshKumar SQL Server MVP http://sugeshkr.blogspot.com

Cluster SQL 2005 SP3 (system databases)


Hello All !

I have a MSCS cluster Windows 2003 Ent SP2 R2 (2 nodes en Active / Passive) and I install SQL 2005 SP3. I need to install 2 MS SQL Server instances on this cluster.

I have volumes shared disks: - Q for Quorum, M for MSDTC, L for logs, S for Datas, T for TempDB, X for Indexes

I want to put system databases on Y.

I have a doubt:

I have 2 SQL instances (ISQL1 and ISQL2), do I need a separate volume for the system DBs (master, model, msdb, tempdb) per instance?

or  do I need one volume for all the system DB (Y) for the 2 instances?

Thanks for advance for your ideas / help - Regards - Have a nice day ! RHUM2

Restricting access to System Databases for Windows User


Hi All,

     I was asked to provide access to windows user for only User databases in server. I added this user to db_reader role in all databases after creating login in Server. But here is the problem, this user can able to access System databases even I have n't assign any role for this login in system databases. Your response will be helpful  to fix this . Please let me know if I am missing here to understand it.





Getting server non system databases, getting database tables, getting table columns


I use next code to get server databases

string connectionString = "Data Source=DENIS\\SQLEXPRESS;Integrated Security=SSPI;";
DataTable tables = new DataTable("Tables");
using (SqlConnection connection =
    new SqlConnection(connectionString))
  SqlCommand command = connection.CreateCommand();
  command.CommandText = "sp_databases"; 
  command.CommandType = CommandType.StoredProcedure;


this.dataGridView1.DataSource = tables;

I've got many databases :

- model ( i guess it is system )

- master ( i guess it is system )

- tempdb ( i guess it is system )

- db1 ( my table )

and etc.

How to determinate what table is system.



FROM information_schema.Tables

So how to determinate what table is system or not.

Can I get tables of database

Recovery Model Indicator - Which system table?




I hope you can help as I am really scratching my head on this one.  I am pulling together an assessment of the Disaster Recovery readiness for an organisation I am working at.  Part of the assessment I am doing is the recovery model of each of the databases.


I have scripts that are already pulling lots of data from 40+ servers and 500+ databases.  However, I cannot seem to find anywhere within the MASTER or MSDB or the database itself where the Recovery Model flag is held.  Obviously I can right click on the database and click properties and it is there, but I need to automate this task (as it will probably be a weekly assessment).


I have checked sysdatabases and almost every other table, but nothing obvious as to where this flag is.


Any ideas? 

Recovery model in Search Server Express 2010 Databases



We have installed a Search Server 2010 Express. The Database is a SQL Server 2008 SP2 (Standard Version)

I'm not a SQL Crack, I am more the SharePoint specialist.

Now my question: Can I set the recovery model for all databases to "Simple" mode? (instead of full mode). Or is there any problem in functionality if i do this?

The default settings are, that some of this are simple and other databases are full.

Thanks a lot for your help.

Cant move system databases of SQL Server 2008 (Clustered) running in Windows 2008 with Service SID e



I was trying to move system databases of SQL Server 2008 on clustered emvironment running on Windows 2008.

I remember while doing the cluster installation somewhere it gave me a recomended option of using Service SID. I think that is the culprit here. Because if you see the "Security" of the DATA folder containing all the MDF and LDF (by default location) you will find a Group named "MSSQLSERVER" is having full access to that directory.

While moving the system databases you need that account (MSSQLSERVER) given access to the parent directory containing the MDF and the LDFs, But unfortunately you cannot add that account manually. Even I tried XCOPY to make sure that while copying the ACLs gets transferred properly to the destination, even that failed.

I think it does provide a solid Security but at the expense of Maintenance, which I cant agree.

Also I forgot to tell you that this Sevice SID option is available if you are using Windows Vista / Windows 2008 or above,

Does anyone has any experience of moving the system databases with Service SID enabled in a cluster environment.

As a testing just try to copy/xcopy/robocopy any folder having MSSQLSERVER group in the ACL and see what happens .. If you are lucky like me then you will get ACCESS DENIED error.

Have anyone faced the same error? I h

Site Recovery - Corrupt Backup

I was cleaning up some sites in my Sharepoint 2007 deployment by deleting them. I did not delete the main collection however I could not get to the root of the site after deleting one of the sites we were no longer using. I use DPM to backup the content database but RESTORE has failed and I am stuck. I deleted the main collection and re-created it , attaching it to the original wscontent.mdf thinking it would reconnect the many sites that we still use but it did not. The database is still showing 26 sites but they are not accessible through the original URLS. Is there anything I can do to get the content from these sites ..lists etc to link to the new application? thanks... Andrew

System Development Life Cycle

The Systems Development Life Cycle (SDLC) is a conceptual model used in project management that describes the stages involved in an information system development project from an initial feasibility study through maintenance of the completed application. Various SDLC methodologies have been developed to guide the processes involved including the waterfall model (the original SDLC method), rapid application development (RAD), joint application development (JAD), the fountain model and the spiral model. Mostly, several models are combined into some sort of hybrid methodology

The Agile System Development Life Cycle (SDLC)

The goal of this article is to describe the agile system development life cycle (SDLC), putting it in context from what you may have heard about within the agile community and more importantly within the context of your overall IT efforts.

Performance Tests: Precise Run Time Measurements with System.Diagnostics.Stopwatch

Everybody who does performance optimization stumbles sooner or later over the Stopwatch class in the System.Diagnostics namespace. And everybody has noticed that the measurements of the same function on the same computer can differ 25% -30% in run time. This article shows how single threaded test programs must be designed to get an accuracy of 0.1% - 0.2% out of the Stopwatch class. With this accuracy, algorithms can be tested and compared.

Data Recovery Software

Nokia mobile phone bulk SMS sending software sends unlimited text messages through a GSM based mobile phone connected with your computer system to other mobile phone. Bulk message broadcasting application sends business related messages, notifications, personal SMS, share market information, enterprise advertising news etc to any group or individual in a single click.
Group messaging wizard offers latest and advance technology to create and sends bulk text messages/SMS from your computer system or laptop/desktop via GSM based mobile phone to another mobile phone worldwide. Instant SMS sending software easily and smoothly works with all popular GSM mobile phone brands including LG, Nokia, Samsung, Sony Ericsson, Motorola etc. Nokia mobile phone mass SMS sending tool facilitates you to have strong relationship with your family, friends, customers etc.
GSM mobile phone SMS sending program is very useful utility for all small or large business enterprise to increase their business by sending event alerts, notifications, advertising to individual or group of customers. Mass messaging software provides solution to the user to send multiple SMS through GSM mobile phone connected through PC to nationally or internationally network based mobile phones.



hello i have the following problem

i have upload my content to hosting server but i get the following error

Security Exception

Description: The application attempted to perform an operation not allowed by the security policy.  To grant this application the required permission please contact your system administrator or change the application's trust level in the configuration file.

Exception Details: System.Security.SecurityException: Request for the permission of type 'System.Web.AspNetHostingPermission, System, Version=, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[SecurityException: Request for the permission of typ

Problem upgrading to MVC3 - System.Web.Routing



I'm trying to upgrade to .NET 4 and MVC 3.

When trying to compile my project, I get the error:

Error 1 The type or namespace name 'Routing' does not exist in the namespace 'System.Web' (are you missing an assembly reference?) C:\Users\spencer\Desktop\weblauncher\Common\MVCConfig.cs 4 18 Common

The type or namespace name 'Routing' does not exist in the namespace 'System.Web' (are you missing an assembly reference?)

I do have the System.Web.Routing in my references for the project.

BUT - when I try to view System.Web.Routing in the OBJECT BROWSER, nothing is inside!  The System.Web.Routing namespace is not in there - the entire thing is empty!  Could it that the dll is corrupted?  I tried to reinstall the .NET 4 and MVC 3 stuff, but its still empty!

The dll is coming from here:

C:\Program Files (x86)\Reference Assemblies\Microsoft\Framework\.NETFramework\v4.0\System.Web.Routing.dll

and the runti

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