Rebuild Master? Error 9003
Oct 8, 1999
I copied the master's .ldf from Node 2. Now I get this error:
1999-10-08 16:46:22.52 kernel Attempting to initialize Distributed Transaction Coordinator.
1999-10-08 16:46:25.93 spid1 Starting up database 'master'.
1999-10-08 16:46:25.93 spid1 Opening file g:MSSQL7datamaster.mdf.
1999-10-08 16:46:25.93 spid1 Opening file g:MSSQL7datamastlog.ldf.
1999-10-08 16:46:25.95 spid1 Loading SQL Server's Unicode collation.
1999-10-08 16:46:25.96 spid1 Loading SQL Server's non-Unicode sort order and character set.
1999-10-08 16:46:25.99 spid1 Error: 9003, Severity: 20, State: 1.
1999-10-08 16:46:25.99 spid1 Cannot recover the master database. Exiting.
Looks like I'm screwed. Next problem - can you rebuild the master.mdf without the mastlog.ldf and how? Also, on an active/active SQL server setup, how would you re-install Node 1?
Help!
Mark Lowe
View 1 Replies
ADVERTISEMENT
Jan 8, 2004
I am performing a Rebiuld of the Master database using the REBUILDM utility on a SQL 2000 SP3 database which is clustered.
The utility starts off correclty, copying the correct MDF and LDF files to the hard drive, and the configuration bar goes across the screen 4 times, before giving the following error "Rebuild master failed with error -1".
I can't find anything on microsoft. I followed KB-298568 to perform this process, but the SQL Service will now not start as it cannot find the master, as it did not get rebuilt properly.
I have included screen shots of the error, in the zipped up word doc.
View 9 Replies
View Related
Oct 26, 2000
hi, what are the reasons for rebuilding master database and what are the steps to complete this task
Thanks
Ahmed
View 1 Replies
View Related
Sep 26, 2007
I've been in support for over ten years, but have had minimal exposure to SQL. I have a client who is running SQL 2005 (as part of SBS Premium), who experienced a server crash due to the database "administrator" filling up the C: drive with manual SQL backups.
Anyway, if I go into SQL Management Studio and try to pull up properties of any database I get a "cannot show requested dialog" error. The only other issue that I've found is that a maintenance plan doesn't quite work correctly -- It will backup their database, but not delete old copies off the hard drive. Otherwise, SQL seems to be running okay.
I have come to the conclusion that I probably need to rebuild the master database. I have tried restoring the master database from a version prior to the crash, but I still have the same issue. I believe the rebuild should be fairly easy, but just don't have a full understanding of what it will affect. They have one custom application that uses a single SQL database and very little security customization (the custom application uses one Windows AD account to access the database).
Basically, I'm wondering:
1. Can someone summarize what is contained in the master database
2. I assume that I'm looking at downtime on their custom application/database - Would this be correct?
3. Will this affect their database at all?
4. How long does the database rebuild process take?
5. I understand that in SQL 2005, the rebuild process it part of the setup on the CD. If the problem is with SQL application files themselves, will this process restore any corrupt program files?
Thanks in advance for any advice,
Vishnu
Weston Technology Solutions
Bend, OR
View 20 Replies
View Related
Dec 30, 2005
I'm using SQL SERVER 2000 and in the process of establishing recoveryguide.Tried to rebuild master using rebuildm.exe but the "Configuring Server"never ending. Then I tried to copy original databases from SQLServerInstallation CD to hard disk as the "Browse for folder", but gave thesame problem. Need advice what need to be done.
View 2 Replies
View Related
Sep 29, 2006
Installed SQLSERVER 2005 EVAL copy in my server and trying to rebuild the master database and it is not working.
I tried the following command.
start /wait setup.exe /qn INSTANCENAME=MSSQLSERVER REINSTALL=SQL_Engine REBUILDDATABASE=1 SAPWD=RAJESH
Any thoughts?
Thanks
View 1 Replies
View Related
Oct 9, 2007
I need to rebuild a corrupted/deleted master database in SQL Server 2005 SP2.
When I run setup.exe from the install media as directed by SQL Books Online, I get to the point where it says the instance is a later version and setup cannot continue. Rerunning the SP2 installer, the instances cannot be selected for upgrade (and it ignores the command line options for the original installer).
How to proceed?
Also, it would seem simpler to have a detach, copy and attach the system databases process, rather than run the installer. (I realize you can stop the instance, copy files, restart the instance; but that's not "high availability".)
W.
View 11 Replies
View Related
Apr 19, 2001
Hello All.
I tried to test Rebuildm.exe on my local server
1. Stoped Sql
2. Renamed master.mdf to master.mdf_old
3. Tried to start Sql (Does start of couse)
4. Run Rebuildm.exe ... and "Gonfigurating Sql server" message goes forever (I was waiting 1 1/2 hrs ... progress bar was running )
Do I miss some some steps ?
Tnanks
View 3 Replies
View Related
May 11, 2014
If one is regularly taking backups of system databases, when does it become necessary to rebuild the master database. I am looking for a situation where rebuilding the master is preferred to restoring it from backup.
View 1 Replies
View Related
Aug 23, 2007
Hi, I'm testing my recovery on a sql server 2005 database. The server has been restored, which includes the OS and sql server 2005 installation (binaries, full tape restore). The tape restore didn't put back the master.mdf and other .mdf files (can't be backed up when open), so I need to rebuild the master and do a database recovery on it and the other supporting databases (yes, I have database backups). I have installed the sql 2005 setup CDs in a folder and run the following command to rebuild the master, but nothing happens, it pauses for a couple of minutes before it returns to the prompt, but it does not put and new master.mdf files in the folder and I can't start the service in single user mode. "start /wait setup.exe /qn INSTANCENAME=MSSQLSERVER REINSTALL=SQL_Engine REBUILDDATABASE=1 SAPWD=mypassword" Anybody have any procedures for a full sql server 2005 recovery or suggestions on this, please post.
Thanks, Mike
View 6 Replies
View Related
Apr 13, 2007
Hello,
In SQL Server 2005 Express, how do I rebuild the master database?
I am receiving the following error messages.
The log scan number (888:136:1) passed to log scan in database 'master' is not valid. This error may indicate data corruption or that the log file (.ldf) does not match the data file (.mdf). If this error occurred during replication, re-create the publication. Otherwise, restore from backup if the problem results in a failure during startup.
AND
Cannot recover the master database. SQL Server is unable to run. Restore master from a full backup, repair it, or rebuild it. For more information about how to rebuild the master database, see SQL Server Books Online.
I tried going through Add and Remove Programs. It did not recognize anything wrong. It did nothing.
I tried 'setup' from the install media. It said to go to 'Add and Remove Programs.'
In SQL Server 2005 Express, how do I rebuild the master database?
Thanks?
AIM
View 8 Replies
View Related
Dec 17, 2007
Hi All,
I'm trying to rebuild my master database for sql server 2000. The process of rebuilding stared fine. But it is almost 4 hours since it got started. Performing it on a test system. Got doubtful and started the same on another test system. Issue is same and it is almost 2 hours. The Db size is less than 100 MB in both cases. IS IT NORMAL? I've tried the same for SQL SERVER 2005 and it got finished in couple of minutes. Please advise.
View 5 Replies
View Related
May 26, 2006
Please, help me.
I haven't a backup.
2006-05-26 11:35:22.76 server Microsoft SQL Server 2000 - 8.00.818 (Intel X86)
May 31 2003 16:08:15
Copyright (c) 1988-2003 Microsoft Corporation
Desktop Engine on Windows NT 5.2 (Build 3790: Service Pack 1)
2006-05-26 11:35:22.76 server Copyright (C) 1988-2002 Microsoft Corporation.
2006-05-26 11:35:22.76 server All rights reserved.
2006-05-26 11:35:22.76 server Server Process ID is 1868.
2006-05-26 11:35:22.76 server Logging SQL Server messages in file 'C:Program FilesMicrosoft SQL ServerMSSQL$MSFWLOGERRORLOG'.
2006-05-26 11:35:22.85 server SQL Server is starting at priority class 'normal'(2 CPUs detected).
2006-05-26 11:35:23.65 server SQL Server configured for thread mode processing.
2006-05-26 11:35:23.68 server Using dynamic lock allocation. [500] Lock Blocks, [1000] Lock Owner Blocks.
2006-05-26 11:35:24.01 spid3 Starting up database 'master'.
2006-05-26 11:35:24.31 spid3 Error: 9003, Severity: 20, State: 1.
2006-05-26 11:35:24.45 spid3 Cannot recover the master database. Exiting.
THX
MaX
View 3 Replies
View Related
Feb 14, 2005
Hi guys,
I am having a little trouble with a SQL Server 2000 database and I would like some help. After failure and recovery of a hard disk my database is marked as suspect and I cannot get it to work again. I have tryed a few things such as copying the database and the log files to another computer and then running the attach command which returns the following "Error 9003: The LSN(12:32:1) passed to log scan in database 'dbName' is invalid.".
Upon getting this error I have tryed with failure attaching a single file, I have also tryed to create a new database with the same name in the same location as the original, then replacing the new files with my old ones, restarting the SQL Server and getting the database into Emergency Mode hopping to extract the data through DTS or BCP Utility, but I cannot access the objects nor the data.
I have also tryed to create a new database with the same name and replace only the ".mdf" file with my old one, but failed.
I would be gratefull for any help.
Manuel.pereira@ricmade.pt
View 8 Replies
View Related
Dec 4, 2005
Hi All,
I'm stuck with "Error: 9003, Severity: 20, State: 1" in MS-SQL Server 2000..I dont want to re-install the sql server ..since..i have other dependent s/w..!
I guess..the Master DB is corrupted....!!
When I tried to rebuild the Master db, i dont find the exe for rebuilding....it...!!
================================================== =======
Error log:
--------
C:Program FilesMicrosoft SQL ServerMSSQLBinn>sqlservr -c -T3608
2005-12-05 09:56:50.81 server Microsoft SQL Server 2000 - 8.00.760 (Intel X8
6)
Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation
Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 1)
2005-12-05 09:56:50.82 server Copyright (C) 1988-2002 Microsoft Corporation.
2005-12-05 09:56:50.82 server All rights reserved.
2005-12-05 09:56:50.82 server Server Process ID is 5548.
2005-12-05 09:56:50.82 server Logging SQL Server messages in file 'C:Program
FilesMicrosoft SQL ServerMSSQLlogERRORLOG'.
2005-12-05 09:56:50.84 server SQL Server is starting at priority class 'norma
l'(2 CPUs detected).
2005-12-05 09:56:50.88 server SQL Server configured for thread mode processin
g.
2005-12-05 09:56:50.90 server Using dynamic lock allocation. [2500] Lock Bloc
ks, [5000] Lock Owner Blocks.
2005-12-05 09:56:50.90 server Attempting to initialize Distributed Transactio
n Coordinator.
2005-12-05 09:56:52.93 spid4 Recovering only master database
2005-12-05 09:56:52.95 spid4 Starting up database 'master'.
2005-12-05 09:56:53.07 spid4 Error: 9003, Severity: 20, State: 1.
2005-12-05 09:56:53.07 spid4 Cannot recover the master database. Exiting.
View 2 Replies
View Related
Sep 13, 2007
Hi,
I had a total server crash and lost all data except mdf and ldf files for databases.
I need to attach these to a fresh installation but it is giving Error 9003 The LSN(XXX:XX:SS) passed to log scan in database "ABC" is invalid.
I have tried using Sp_attach both for single file and N file but same error occurs.
Is there any way to attach this to a database or atleast re-cover data ?
View 3 Replies
View Related
Jan 10, 2001
How I can rebuild master db to change the Code Page of the current SQL7 , to convert my SQL7 from code page 850 to 1252 ? I have huge data in the old code page dbs , Does rebuild the master db mean reinsert the data again ?
View 1 Replies
View Related
Oct 23, 2007
I use this command to change collation on SQL 2005 cluster.
start /wait <CD or DVD Drive>setup.exe /qn VS=<VSName> INSTANCENAME=<InstanceName> REINSTALL=SQL_Engine SKUUPGRADE=1 REBUILDDATABASE=1 ADMINPASSWORD=<StrongPassword> SAPWD=<NewStrongPassword> SQLCOLLATION=<NewSystemCollation> SQLACCOUNT=<domainuser> SQLPASSWORD=<DomainUserPassword> AGTACCOUNT=<domainuser> AGTPASSWORD=<DomainUserPassword>
The rebuild master database failed with the following message. Please help.
Microsoft SQL Server 2005 Setup beginning at Tue Oct 23 07:32:48 2007
Process ID : 3112
C:Program FilesMicrosoft SQL Server90Setup Bootstrapsetup.exe Version: 2005.90.3042.0
Running: LoadResourcesAction at: 2007/9/23 7:32:48
Complete: LoadResourcesAction at: 2007/9/23 7:32:48, returned true
Running: ParseBootstrapOptionsAction at: 2007/9/23 7:32:48
Loaded DLL:C:Program FilesMicrosoft SQL Server90Setup Bootstrapxmlrw.dll Version:2.0.3609.0
Complete: ParseBootstrapOptionsAction at: 2007/9/23 7:32:48, returned true
Running: ValidateWinNTAction at: 2007/9/23 7:32:48
Complete: ValidateWinNTAction at: 2007/9/23 7:32:48, returned true
Running: ValidateMinOSAction at: 2007/9/23 7:32:48
Complete: ValidateMinOSAction at: 2007/9/23 7:32:48, returned true
Running: PerformSCCAction at: 2007/9/23 7:32:48
Complete: PerformSCCAction at: 2007/9/23 7:32:48, returned true
Running: ActivateLoggingAction at: 2007/9/23 7:32:48
Complete: ActivateLoggingAction at: 2007/9/23 7:32:48, returned true
Running: DetectPatchedBootstrapAction at: 2007/9/23 7:32:48
Complete: DetectPatchedBootstrapAction at: 2007/9/23 7:32:48, returned true
Action "LaunchPatchedBootstrapAction" will be skipped due to the following restrictions:
Condition "EventCondition: __STP_LaunchPatchedBootstrap__3112" returned false.
Running: PerformSCCAction2 at: 2007/9/23 7:32:48
Complete: PerformSCCAction2 at: 2007/9/23 7:32:48, returned true
Running: PerformDotNetCheck at: 2007/9/23 7:32:48
Complete: PerformDotNetCheck at: 2007/9/23 7:32:48, returned true
Running: ComponentUpdateAction at: 2007/9/23 7:32:48
Complete: ComponentUpdateAction at: 2007/9/23 7:32:49, returned true
Running: DetectLocalBootstrapAction at: 2007/9/23 7:32:49
Complete: DetectLocalBootstrapAction at: 2007/9/23 7:32:49, returned true
Action "LaunchLocalBootstrapAction" will be skipped due to the following restrictions:
Condition "EventCondition: __STP_LaunchLocalBootstrap__3112" returned false.
Running: PerformDotNetCheck2 at: 2007/9/23 7:32:49
Complete: PerformDotNetCheck2 at: 2007/9/23 7:32:49, returned true
Running: InvokeSqlSetupDllAction at: 2007/9/23 7:32:49
Loaded DLL:C:Program FilesMicrosoft SQL Server90Setup Bootstrapsqlspars.dll Version:2005.90.3042.0
<Func Name='DwLaunchMsiExec'>
Examining 'sqlspars' globals to initialize 'SetupStateScope'
Opening 'MachineConfigScope' for [DSQL1N1]
Trying to find Product Code from command line or passed transform
If possible, determine install id and type
Trying to find Instance Name from command line.
Instance Name = DC1
Trying to find install through Instance Name
Install Type = 1
If possible, determine action
*******************************************
Setup Consistency Check Report for Machine: DSQL1N1
*******************************************
Article: WMI Service Requirement, Result: CheckPassed
Article: MSXML Requirement, Result: CheckPassed
Article: Operating System Minimum Level Requirement, Result: CheckPassed
Article: Operating System Service Pack Level Requirement, Result: CheckPassed
Article: SQL Compatibility With Operating System, Result: CheckPassed
Article: Minimum Hardware Requirement, Result: CheckPassed
Article: IIS Feature Requirement, Result: CheckPassed
Article: Pending Reboot Requirement, Result: CheckPassed
Article: Performance Monitor Counter Requirement, Result: CheckPassed
Article: Default Installation Path Permission Requirement, Result: CheckPassed
Article: Internet Explorer Requirement, Result: CheckPassed
Article: Check COM+ Catalogue, Result: CheckPassed
Article: ASP.Net Registration Requirement, Result: CheckPassed
Article: Minimum MDAC Version Requirement, Result: CheckPassed
Article: Edition Upgrade Check, Result: CheckPassed
<Func Name='PerformDetections'>
0
Loaded DLL:C:Program FilesMicrosoft SQL Server90Setup Bootstrapsqlsval.dll Version:2005.90.3042.0
<EndFunc Name='PerformDetections' Return='0' GetLastError='997'>
*******************************************
Setup Consistency Check Report for Machine: DSQL1N1
*******************************************
Article: WMI Service Requirement, Result: CheckPassed
Article: MSXML Requirement, Result: CheckPassed
Article: Operating System Minimum Level Requirement, Result: CheckPassed
Article: Operating System Service Pack Level Requirement, Result: CheckPassed
Article: SQL Compatibility With Operating System, Result: CheckPassed
Article: Minimum Hardware Requirement, Result: CheckPassed
Article: IIS Feature Requirement, Result: CheckPassed
Article: Pending Reboot Requirement, Result: CheckPassed
Article: Performance Monitor Counter Requirement, Result: CheckPassed
Article: Default Installation Path Permission Requirement, Result: CheckPassed
Article: Internet Explorer Requirement, Result: CheckPassed
Article: Check COM+ Catalogue, Result: CheckPassed
Article: ASP.Net Registration Requirement, Result: CheckPassed
Article: Minimum MDAC Version Requirement, Result: CheckPassed
Article: Edition Upgrade Check, Result: CheckPassed
*******************************************
Setup Consistency Check Report for Machine: DSQL1N2
*******************************************
Article: WMI Service Requirement, Result: CheckPassed
Article: MSXML Requirement, Result: CheckPassed
Article: Operating System Minimum Level Requirement, Result: CheckPassed
Article: Operating System Service Pack Level Requirement, Result: CheckPassed
Article: SQL Compatibility With Operating System, Result: CheckPassed
Article: Minimum Hardware Requirement, Result: CheckPassed
Article: IIS Feature Requirement, Result: CheckPassed
Article: Administrative Shares Requirement, Result: CheckPassed
Article: Pending Reboot Requirement, Result: CheckPassed
Article: Performance Monitor Counter Requirement, Result: CheckPassed
Article: Default Installation Path Permission Requirement, Result: CheckPassed
Article: Internet Explorer Requirement, Result: CheckPassed
Article: Check COM+ Catalogue, Result: CheckPassed
Article: ASP.Net Registration Requirement, Result: CheckPassed
Article: Minimum MDAC Version Requirement, Result: CheckPassed
Article: Edition Upgrade Check, Result: CheckPassed
The CheckSCCResult returned for cluster install is 0
Loaded DLL:C:Program FilesMicrosoft SQL Server90Setup Bootstrapsqlsval.dll Version:2005.90.3042.0
<EndFunc Name='DwLaunchMsiExec' Return='0' GetLastError='0'>
Complete: InvokeSqlSetupDllAction at: 2007/9/23 7:33:41, returned true
Running: SetPackageInstallStateAction at: 2007/9/23 7:33:41
Complete: SetPackageInstallStateAction at: 2007/9/23 7:33:43, returned true
Running: DeterminePackageTransformsAction at: 2007/9/23 7:33:43
Complete: DeterminePackageTransformsAction at: 2007/9/23 7:33:43, returned true
Running: ValidateSetupPropertiesAction at: 2007/9/23 7:33:43
Complete: ValidateSetupPropertiesAction at: 2007/9/23 7:33:43, returned true
Running: OpenPipeAction at: 2007/9/23 7:33:43
Complete: OpenPipeAction at: 2007/9/23 7:33:43, returned false
Error: Action "OpenPipeAction" failed during execution.
Running: CreatePipeAction at: 2007/9/23 7:33:43
Complete: CreatePipeAction at: 2007/9/23 7:33:43, returned true
Running: RunRemoteSetupAction at: 2007/9/23 7:33:43
<Func Name='CProcessCtrl::GetInstallPath'>
<EndFunc Name='CProcessCtrl::GetInstallPath' Return='0' GetLastError='0'>
Error: 0x80070050 TaskScheduler::NewWorkItem for SQL Server Remote Setup
Error: 0x80070005 TaskSchedulerWorkItem failed to save the task [SQL Server Remote Setup ]
Complete: RunRemoteSetupAction at: 2007/9/23 7:33:43, returned false
Error: Action "RunRemoteSetupAction" failed during execution. Error information reported during run:
Attempting to determine log files for remote install.
Connection to remote computer's scheduler service.
Creating new workitem.
Deleting existing work item and trying again...
Starting remote setup onSQL1N2
Error: 80070005 Access is denied.
Running: PopulateMutatorDbAction at: 2007/9/23 7:33:43
Complete: PopulateMutatorDbAction at: 2007/9/23 7:33:43, returned true
Running: GenerateRequestsAction at: 2007/9/23 7:33:43
SQL_Engine = 3
SQL_Data_Files = -1
SQL_Replication = -1
SQL_FullText = -1
SQL_SharedTools = -1
SQL_BC_DEP = -1
Analysis_Server = -1
AnalysisDataFiles = -1
AnalysisSharedTools = -1
RS_Server = -1
RS_Web_Interface = -1
RS_SharedTools = -1
Notification_Services = -1
NS_Engine = -1
NS_Client = -1
SQL_DTS = -1
Client_Components = -1
Connectivity = -1
SQL_Tools90 = -1
SQL_WarehouseDevWorkbench = -1
SDK = -1
SQLXML = -1
Tools_Legacy = -1
TOOLS_BC_DEP = -1
SQL_SSMSEE = -1
SQL_Documentation = -1
SQL_BooksOnline = -1
SQL_DatabaseSamples = -1
SQL_AdventureWorksSamples = -1
SQL_AdventureWorksDWSamples = -1
SQL_AdventureWorksASSamples = -1
SQL_Samples = -1
Complete: GenerateRequestsAction at: 2007/9/23 7:33:44, returned true
Running: CreateProgressWindowAction at: 2007/9/23 7:33:44
Complete: CreateProgressWindowAction at: 2007/9/23 7:33:44, returned false
Error: Action "CreateProgressWindowAction" failed during execution.
Running: ScheduleActionAction at: 2007/9/23 7:33:44
Complete: ScheduleActionAction at: 2007/9/23 7:33:45, returned true
Skipped: InstallASAction.11
Waiting for actions from remote setup(s)
Breaking wait state and aborting package due to cancel code received: 1602
Remote setup(s) are ready
Notify package action is determined: 1602
Error Code: 0x800700e9 (233)
Windows Error Text: No process is on the other end of the pipe.
Source File Name: remotemessageliboverlappedpipelistener.cpp
Compiler Timestamp: Sat Oct 7 09:43:54 2006
Function Name: sqls:verlappedPipeListener::writePipe
Source Line Number: 294
Notification failed to send.
---- Context -----------------------------------------------
sqls::HostSetupPackageInstallerSynch::installAction
Removing machine from list of targets to sync.
Skipped: Action "InstallASAction.11" was not run. Information reported during analysis:
All installs have been cancelled, so package: "sqlsupport", referred by package: "as", will not be installed.
Skipped: InstallASAction.18
Skipped: Action "InstallASAction.18" was not run. Information reported during analysis:
All installs have been cancelled, so package: "owc11", referred by package: "as", will not be installed.
Skipped: InstallASAction.22
Skipped: Action "InstallASAction.22" was not run. Information reported during analysis:
All installs have been cancelled, so package: "bcRedist", referred by package: "as", will not be installed.
Skipped: InstallASAction.9
Skipped: Action "InstallASAction.9" was not run. Information reported during analysis:
All installs have been cancelled, so package: "msxml6", referred by package: "as", will not be installed.
Skipped: InstallDTSAction
Skipped: Action "InstallDTSAction" was not run. Information reported during analysis:
All installs have been cancelled, so package: "dts", will not be installed.
Skipped: InstallDTSAction.11
Skipped: Action "InstallDTSAction.11" was not run. Information reported during analysis:
All installs have been cancelled, so package: "sqlsupport", referred by package: "dts", will not be installed.
Skipped: InstallDTSAction.12
Skipped: Action "InstallDTSAction.12" was not run. Information reported during analysis:
All installs have been cancelled, so package: "sqlncli", referred by package: "dts", will not be installed.
Skipped: InstallDTSAction.18
Skipped: Action "InstallDTSAction.18" was not run. Information reported during analysis:
All installs have been cancelled, so package: "owc11", referred by package: "dts", will not be installed.
Skipped: InstallDTSAction.22
Skipped: Action "InstallDTSAction.22" was not run. Information reported during analysis:
All installs have been cancelled, so package: "bcRedist", referred by package: "dts", will not be installed.
Skipped: InstallDTSAction.9
Skipped: Action "InstallDTSAction.9" was not run. Information reported during analysis:
All installs have been cancelled, so package: "msxml6", referred by package: "dts", will not be installed.
Skipped: InstallNSAction
Skipped: Action "InstallNSAction" was not run. Information reported during analysis:
All installs have been cancelled, so package: "ns", will not be installed.
Skipped: InstallNSAction.11
Skipped: Action "InstallNSAction.11" was not run. Information reported during analysis:
All installs have been cancelled, so package: "sqlsupport", referred by package: "ns", will not be installed.
Skipped: InstallNSAction.12
Skipped: Action "InstallNSAction.12" was not run. Information reported during analysis:
All installs have been cancelled, so package: "sqlncli", referred by package: "ns", will not be installed.
Skipped: InstallNSAction.18
Skipped: Action "InstallNSAction.18" was not run. Information reported during analysis:
All installs have been cancelled, so package: "owc11", referred by package: "ns", will not be installed.
Skipped: InstallNSAction.22
Skipped: Action "InstallNSAction.22" was not run. Information reported during analysis:
All installs have been cancelled, so package: "bcRedist", referred by package: "ns", will not be installed.
Skipped: InstallNSAction.9
Skipped: Action "InstallNSAction.9" was not run. Information reported during analysis:
All installs have been cancelled, so package: "msxml6", referred by package: "ns", will not be installed.
Skipped: InstallRSAction.11
Skipped: Action "InstallRSAction.11" was not run. Information reported during analysis:
All installs have been cancelled, so package: "sqlsupport", referred by package: "rs", will not be installed.
Skipped: InstallRSAction.18
Skipped: Action "InstallRSAction.18" was not run. Information reported during analysis:
All installs have been cancelled, so package: "owc11", referred by package: "rs", will not be installed.
Skipped: InstallRSAction.22
Skipped: Action "InstallRSAction.22" was not run. Information reported during analysis:
All installs have been cancelled, so package: "bcRedist", referred by package: "rs", will not be installed.
Skipped: InstallSqlAction
Clustered feature detected: SQL_Engine
Clustered feature detected: SQL_FullText
Loaded DLL:C:Program FilesMicrosoft SQL Server90Setup Bootstrapsqlsval.dll Version:2005.90.3042.0
Windows Error Text: User cancelled installation.
Source File Name: sqlchainingsqlchainingactions.cpp
Compiler Timestamp: Thu Nov 16 20:32:00 2006
Function Name: sqls::ReportChainingResults:erform
Source Line Number: 3667
---- Context -----------------------------------------------
sqls::RunRemoteSetupAction::waitForRemoteSetupComplete
king package: "patchRS2000" as failed due to cancel code received from cancel source: 1602
sqls
Delay load of action "UploadDrWatsonLogAction" returned nothing. No action will occur as a result.
Message pump returning: 1602
View 1 Replies
View Related
Jan 3, 2008
Hi,
I am using Microsoft SQL Server 2000 Desktop Engine (MSDE 2000). When I restart the SQL Service, it fails to do so. I have tried running the service in command prompt & got the following error:
Error: 9003, Severity: 20, State: 1.
Cannot recover the master database. Exiting.
Kindly help as it is quite urgent & I can not afford to loose any data. Thanks.
View 3 Replies
View Related
Aug 8, 2007
Hi All,
We have transactional replication between two SQL Server 2000, SP4 and database is in simple recovery.
Occassionally Logreader agent fails with error 9003 (The LSN (164051:119090:22) passed to log scan in database 'ReportDB' is
invalid).
But in April 2007 this error has occurred multiple times. We have opened the case with PSS in April 2007 but till now there
is no concrete solution.
Error details in ErrorLog:
2007-04-24 16:49:09.79 spid59 Error: 9003, Severity: 20, State: 1
2007-04-24 16:49:09.79 spid59 The LSN (164051:119090:22) passed to log scan in database 'ReportDB' is invalid..
Error details in Log reader agent:
Repl Agent Status: 3
Publisher: {call sp_repldone ( 0x000280d30001d1320016, 0x000280d30001d1320016, 0, 0)}
Publisher: {call sp_replcmds (100, 0)}
Status: 0, code: 0, text: 'The process could not execute 'sp_replcmds' on 'BR14D135R17'.'.
The process could not execute 'sp_replcmds' on 'BR14D135R17'.
Repl Agent Status: 6
Status: 0, code: 9003, text: 'The LSN (164051:119090:22) passed to log scan in database 'ReportDB' is invalid.'.
From above error details it can be seen that sp_repldone is already called for LSN 164051:119090:22 (0x000280d30001d1320016)
which means it is distributed.
Since LSN is distributed, transaction log of publisher for that LSN can be truncated by checkpoint process. And afterward if
logreader issues sp_replcmds for that LSN, we will get 9003 error.
So, question is why Logreader is looking for LSN if that is already distributed.
When checked "DBCC Opentran", it also reflect oldest distributed LSN as 164051:119090:22.
We tried changing the recovery model to FULL but that has only delayed the occurrence.
Once we have noticed that LSN mentioned in Error 9003 was already backed up one day before. And we don't think replication latency to be more than 3 hrs
(maximum).
After PSS recommendation, we have applied the hotfix 2187 but error has occurred again after one month.
Other recommendation is to disable read cache of hardware controller to avoid stale read(that we are working on). Current
setting is 100% read and 0% Write.
Other Details:
SQL Server 2000 Enterprise Edition SP4 with Hotfix 2187
Window 2000 Advanced Server.
RAID 5 with array controller as HP Smart Array 641 Controller
Please let me know if you have faced such issue and have any idea on this problem.
Thanks,
Ramesh
View 3 Replies
View Related
Mar 1, 2008
hello there,
Could someone help me with my server. I could not start SQLServerAgent.
and have an error message:
An error 1068 - (The dependency service or group failed to start.) occurred while performing this service operation on the SQLServerAgent Service.
The startup account for both MSSQLServer and SQLServerAgent is on Local System Account.
And on the SQL Error Log I got:
2008-03-01 14:50:12.89 server Copyright (C) 1988-2002 Microsoft Corporation.
2008-03-01 14:50:12.89 server All rights reserved.
2008-03-01 14:50:12.89 server Server Process ID is 164.
2008-03-01 14:50:12.89 server Logging SQL Server messages in file 'D:Program FilesMicrosoft SQL ServerMSSQLLOGERRORLOG'.
2008-03-01 14:50:12.90 server SQL Server is starting at priority class 'normal'(1 CPU detected).
2008-03-01 14:50:12.92 server SQL Server configured for thread mode processing.
2008-03-01 14:50:12.92 server Using dynamic lock allocation. [500] Lock Blocks, [1000] Lock Owner Blocks.
2008-03-01 14:50:12.93 spid3 Starting up database 'master'.
2008-03-01 14:50:12.96 spid3 Error: 9003, Severity: 20, State: 1.
2008-03-01 14:50:12.96 spid3 Cannot recover the master database. Exiting.
I thnik the SQLServerAgent won't start because the the ERROR 9003. May be my Db is corrupted.
Is there anyone that could help me?
View 4 Replies
View Related
Sep 21, 2015
We have a script running everyday for rebuild and re-organisation of indexes. But, somehow its getting failed. Attached script for your consideration. There is no database name with amoperations. There is table called DatabaseObjectAudit but it exist on master db.
Message:
-->Start Index Maint
-> Gathering fragmentation information (can take a while!)
-> Gathering COMPLETE : Total of 43 databases were found.
-> Gathering COMPLETE : Total of 1622 indexes were found.
[code]...
View 9 Replies
View Related
Sep 16, 2015
We have a maintenance plan running everyday for rebuild and re-organisation of indexes. But, somehow its getting failed. Here is the script that we are running for rebuild or re-org.
/*
Script to handle index maintenance
Tuning constants are set in-line current values are;
SET @MinFragmentation
SET @MaxFragmentation
SET @TrivialPageCount
[code]....
View 19 Replies
View Related
Nov 13, 2007
My site crashed, so I had to rebuild the Project Site.
I used the SharePoint products and technologies configuration wizard to disconnect from the server farm (only actually running on the single server).
I then reran SharePoint products and technologies configuration wizard to setup the site.
Configured the Project Service and attached to the existing dB's.
Previously, I used the url http://servername.domain.forest/PWA/default.aspx .
Now when I attempt the use the same URL, I get the following error:
"An unexpected error has occurred"
I have tested this one 3 servers now and I receive the exact same result. Is there a path I should apply to the servers in order to allow fully qualified server names after a reinstall of the system?
View 1 Replies
View Related
Jun 25, 2015
I have a requirement to only rebuild the Clustered Indexes in the table ignoring the non clustered indexes as those are taken care of by the Clustered indexes.
In order to do that, I have taken the records based on the fragmentation %.
But unable to come up with a logic to only consider rebuilding the clustered indexes in the table.
create table #fragmentation
(
FragIndexId BigInt Identity(1,1),
--IDENTITY(int, 1, 1) AS FragIndexId,
DBNAME nvarchar(4000),
TableName nvarchar(4000),
[Code] ....
View 5 Replies
View Related
May 22, 2006
Hi Gurus
Sorry to rake up this issue again.we repaired this master by dbcc checkdb and now it is fine.What is this going on?do i have the chance that this willstillgodown as mentioned by paul .
Regards
Nitin
View 7 Replies
View Related
May 15, 2006
Gurus
when i run checkdb i get this error
"Database 'master' consistency errors in sysobjects, sysindexes, syscolumns, or systypes prevent further CHECKDB processing."
What can be the cause?Can i fix this with repair option of check db?
Please advice
Regards
Nitin
View 20 Replies
View Related
Aug 28, 2007
I keep getting a "Incorrect syntax error near ' -Q''' " which is at the end of my xp_cmdshell line. What am I doing wrong?
CREATE Procedure dbo.sp_ImportRawData
(@ClientAbbrev nchar(4), @FileDate nvarchar(8), @SessionId nvarchar(50) )
AS
DECLARE @Msg varchar(255)
DECLARE @DataUpdates nvarchar(255)
DECLARE @Common nvarchar(255)
DECLARE @UServer nvarchar(255)
DECLARE @FullFileName nvarchar(68)
DECLARE @FileName nvarchar(64)
DECLARE @FileExt nvarchar(3)
DECLARE @SQL varchar(3500)
DECLARE @triFileName nvarchar(255)
Declare @Ip_FileName nvarchar(255)
Declare @Ip_Active char(1)
select @UServer = sd_value from Msysdata Where SD_Property = 'UpDateServer'
select @Common = sd_value from Msysdata WHERE SD_Property = 'CommonDir'
select @DataUpdates = sd_Value from Msysdata WHERE SD_Property = 'DataUpdate'
Set @UServer = @UServer + 'D$'
SET @Msg = 'Truncate tri_ active files'
EXEC MARS_SYS.dbo.sp_WriteLog @ClientAbbrev, 'UpdateMgr', @Msg, @FileDate, @SessionId
Declare ActiveFile Cursor For
Select Ip_FileName, Ip_Active from tbl_InputFiles
where Ip_Active = 'Y'
Open ActiveFile
Fetch Next From ActiveFile
Into @Ip_FileName, @Ip_Active
While @@Fetch_Status = 0
Begin
Exec('truncate table tri_'+ @Ip_FileName)
Set @FullFileName = @Ip_Filename + '.csv'
set @UServer = ''
set @Common = ''
set @triFileName = 'tri_' + @Ip_FileName
set @sql = 'master..xp_cmdshell ''' + @UServer + @Common + 'd:mars_syscommonscriptsodbcbcp -D CopyMedMgr10_Testing -i D:mars_sysdataupdatesccbm' + @FullFileName + ' -Q''' + @triFileName
exec(@SQL)
Fetch Next From ActiveFile
Into @Ip_FileName, @Ip_Active
End
CLOSE ActiveFile
DEALLOCATE ActiveFile
View 8 Replies
View Related
Apr 22, 2006
Hi,
In sys.transmission_queue is showing the transmission_status with error. "The session keys for this conversation could not be created or accessed. The database master key is required for this operation."
But I do have a Master Key in the database, and many External Assemblies depend on that. Is there an option to use the existing master key. How to use the existing key ?
Thanks in advance.
Regards
Babu
View 5 Replies
View Related
Dec 14, 2007
Hi ,
I am trying to move the system database master database and mssqlresource database on SQL Server 2005.
I am going according to the doc's . And I am logging in as single user mode : NET START MSSQLSERVER /f /T3608 and when I try to login into sqlcmd or Management studio , I get the error:
SQL Error 18461 , can not login in more than one administrator server in single user mode.
For the managment studio , I close the object explorer as it is taken as one connection and click the new query with existing connection. But it throws me the same error. When I try to enter into sqlcmd , it throws me the same error.
What can I do here.. IS there anything I am missing.
Thanks
.
View 11 Replies
View Related
Mar 6, 2007
- First I made a full backup of master database
- Then I stopped SQL Server Service
- in cmd: cd C:Program FilesMicrosoft SQL ServerMSSQL.2MSSQLBinn
then sqlservr.exe -m
- I entered that single user mode
---> Problem here:
- I tried to connect to sql by sqlcmd -E --->
HResult 0xE9, Level 16, State 1
Shared Memory Provider: No process is on the other end of the pipe.
Sqlcmd: Error: Microsoft SQL Native Client : Communication link failure.
---> I tried to connect to management studio:
TITLE: Connect to Server
------------------------------
Cannot connect to BISHOYSERVER.
------------------------------
ADDITIONAL INFORMATION:
Login failed for user 'OFFICIALPROJECTAdministrator'. Reason: Server is in single user mode. Only one administrator can connect at this time. (Microsoft SQL Server, Error: 18461)
View 6 Replies
View Related
Mar 13, 2015
I have a SP SQL server that uses Handshake for the web parts. I am getting an error on SharePoint about 'An error occurred during Service Master Key Decryption' inside the web parts of the page, everything else comes up, from what I have researched MS says go under SQL Configuration Manager and change the service account. Is this the correct course of action for this type of error? I am just having a hard time believing that changing the engines service account will stop this issue, this account is used on several SQL server with no issues.
MCSA SQL Server 2012
View 1 Replies
View Related
Jan 17, 2008
I receive this error "Setup was unable to load the master information file' when I lanch Control Panel, Add/Remove Programs, Add/Remove Windows Components.
I was going to add ISS but recieved this error.
Running Windows XP Professional SP2
View 3 Replies
View Related
