DB Engine :: Server Agent Job Failing After Moving A Database
Aug 10, 2015
On Saturday we moved a few databases from SQL Server 2005 to a SQL Server 2012 cluster; and as expected some jobs have been failing because of this. The Job in Question executes two stored procedures and then an SSIS package; however when I ran the Job it failed with the error
Msg 7411, Level 16, State 1, Line 1
Server 'servername' is not configured for RPC
I therefore configured the Server for RPC with the following script: -
exec sp_serveroption @server='servername', @optname='rpc', @optvalue='true'
GO
But the job failed again. So I therefore reran the script with the reconfigure option: -
exec sp_serveroption @server='OCELOT7CLUST', @optname='rpc', @optvalue='true'
GO
reconfigure with override
go
But again the job failed. I then closed SSMS and reopened it and attempt to run the job again and once again it failed.This is not an issue with the Linked Server as the linked Server is connecting as sa.
Our development organization has created an application employing FILESTREAM, which through the pilot has been incorporated into a schema within our Data Warehouse Staging database. Going to production, the development and BI teams have determined that they want it separated out into a separate database, and they'd like to separate it in the current pilot environment (DEV). How can I best move (or at least copy) the existing FILESTREAM data from the current database into a new one?
Hi. I was wondering if anyone has ever had a problem where nothing seems to be wrong with the server, and SQL Server Agent is up and running, but jobs fail. We had a job run at midnight, and it was the last successful run. Every job failed after that, with an error stating "Unable to retrieve steps for job..." There doesn't seem to be any reason for the problem. The jobs were kicked off manually and they all ran.
The only other error messages we could find were in the Application Event Viewer on the server. But the first error happened days ago and said this: "The description for Event ID ( 0 ) in Source ( .NET Runtime ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: Unable to open shim database version registry key - v2.0.50727.00000."
Since then, every few seconds this error occurred: "Windows cannot load extensible counter DLL MSSQLServerOLAPService, the first DWORD in data section is the Windows error code."
We turned off the performance monitor counters and that error stopped. But we still have no idea if that was the cause of the problem.
This isn't the first time we've had an issue with jobs failing because the steps couldn't be 'found', while SQL Server Agent was up and running.
Hi. I have installed an SQL 2005 Failover Cluster on a Two Node Active Passive Windows 2003 Cluster.If i am trying to failover from the Active node to the passive Node,The Sql Server,Sql Server Agent and SQL Analysis resources fail,However if i reset the passowrd in the services tab of the above three services on the pasive node,the resources come online. Below is the brief of my setup 1.I have two Active directory domain controllers running Windows 2003 R2 Standard edition with SP2. 2.i have installed a Windows 2003 Two Node Active Passive Cluster as NODE1 and NODE2. 3.The Domain account used to install WIndows 2003 A/P Cluster is Clusteradmin.This account is the member of Administartors on the Domain as well as the Local Admin on NODE1 and NODE2. 4.SQL 2005 with SP2 is installed on both the Nodes as SQL 2005 Failover Cluster.The account used to install SQL 2005 is sqadmin.This account is the member of Administartors on the domain and the member of Local Admins on NODE1 and NODE2. 5.SLQ 2005 has four domain groups for 4 SQL Services.The Services are SQL Server,SQL Server Agent,SLQ Anaylisis Server and Full text Search. 6.Each of these servcie has a seperate service account created for them.All these service accounts areb the members of domain admin and the member of Local Admin on NODE1 and NODE2. 7.Each of these servcies is running under these servcie accounts in the Servcies tab in NODE1 and NODE2. 8.If i fail the resources from NODE1 to NODE2 ,The SQL Server,SQL Server Agent and SQL Anaylisis resources are failing.on going to the service tab of NODE 2 I reset the password for these services,the services come online. 10.The Cluster resources and MSDTC Resources are Failing over successfully.They are coming online successfully. 11,I have a problem with the SQL Server Resources,even if i failback to NODE1 from NODE2,the same resources are failing again.
2006-03-27 13:01:49.820 Skipping file 'NotesHistory_21.sch' because it has already been delivered for a previous article or by a previously interrupted snapshot. 2006-03-27 13:01:49.867 OLE DB Subscriber 'LUZERNV4-PDOSQL4': SET ANSI_NULLS ON
2006-03-27 13:01:49.898 OLE DB Distributor 'LARGOS00-SDI': {call sys.sp_MSadd_merge_history90 (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)} 2006-03-27 13:01:49.945 OLE DB Subscriber 'LUZERNV4-PDOSQL4': SET QUOTED_IDENTIFIER ON
2006-03-27 13:01:50.008 [17%] OLE DB Subscriber 'LUZERNV4-PDOSQL4': CREATE TABLE [dbo].[MSmerge_conflict_EFILE_MERGE_NotesHistory]( [NoteID] [int] NOT NULL, [CaseRefNum] [int] NOT NULL, [KeyField] [varchar](500) NOT NULL, [KeyValue] [varchar](500) NOT NULL, [Note] [varchar](800) NULL, [NoteField] [varchar](100) NULL, [ScanDocID] [int] NULL, [PDF_ID] [int] NULL, [RescanCode] [int] NULL, [RescanNote] [varchar](100) NULL, [AuditID] [bigint] NOT NULL, [rowguid] [uniqueidentifier] ROWGUIDCOL NOT NULL )
ꜽśã¹? êœ?Å›B 27 13:01î–”Å›è›ªç —êœ?Å›é”?Ä€Percent Complete: 17 2006-03-27 13:01:50.086 OLE DB Subscriber 'LUZERNV4-PDOSQL4': SET ANSI_NULLS ON
2006-03-27 13:01:50.117 Preparing table 'NotesHistory' for merge replication 2006-03-27 13:01:50.164 OLE DB Subscriber 'LUZERNV4-PDOSQL4': SET QUOTED_IDENTIFIER ON
2006-03-27 13:01:50.195 OLE DB Distributor 'LARGOS00-SDI': {call sys.sp_MSadd_merge_history90 (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)} 2006-03-27 13:01:50.258 OLE DB Subscriber 'LUZERNV4-PDOSQL4': if object_id('MSmerge_conflicts_info') is not NULL alter table [MSmerge_conflict_EFILE_MERGE_NotesHistory] add origin_datasource_id uniqueidentifier NULL
2006-03-27 13:01:50.351 OLE DB Subscriber 'LUZERNV4-PDOSQL4': if object_id('MSmerge_conflicts_info') is not NULL create nonclustered index [ncMSmerge_conflict_EFILE_MERGE_NotesHistory] on [MSmerge_conflict_EFILE_MERGE_NotesHistory] ([rowguid], origin_datasource_id)
2006-03-27 13:01:50.383 OLE DB Subscriber 'LUZERNV4-PDOSQL4': exec sp_MSsetconflicttable @article = N'NotesHistory', @conflict_table = N'MSmerge_conflict_EFILE_MERGE_NotesHistory'
2006-03-27 13:01:50.430 OLE DB Subscriber 'LUZERNV4-PDOSQL4': {call sys.sp_MSadd_merge_history90 (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)} 2006-03-27 13:01:50.476 [17%] The merge process was unable to deliver the snapshot to the Subscriber. If using Web synchronization, the merge process may have been unable to create or write to the message file. When troubleshooting, restart the synchronization with verbose history logging and specify an output file to which to write.Percent Complete: 17 2006-03-27 13:01:50.50é”?Ä€ 2006-03-27 13:01:50.539 Applied script 'NotesHistory_21.cft' 2006-03-27 13:01:50.586 OLE DB Subscriber 'LUZERNV4-PDOSQL4': {call sys.sp_MSadd_merge_history90 (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)} 2006-03-27 13:01:50.617 OLE DB Distributor 'LARGOS00-SDI': {call sys.sp_MSadd_merge_history90 (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)} 2006-03-27 13:01:50.711 Percent Complete: 17 2006-03-27 13:01:50.742 {call sp_MSsetconflicttable (N'NotesHistory', N'MSmerge_conflict_EFILE_MERGE_NotesHistory', N'LARGOS00-SDI', N'EFILE', N'EFILE_MERGE')} 2006-03-27 13:01:50.773 OLE DB Distributor 'LARGOS00-SDI': {call sys.sp_MSadd_merge_history90 (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)} 2006-03-27 13:01:50.867 Percent Complete: 0 2006-03-27 13:01:50.898 Category:COMMAND Source: Failed Command Number: 0 Message: {call sp_MSsetconflicttable (N'NotesHistory', N'MSmerge_conflict_EFILE_MERGE_NotesHistory', N'LARGOS00-SDI', N'EFILE', N'EFILE_MERGE')} 2006-03-27 13:01:50.961 Percent Complete: 0 2006-03-27 13:01:50.992 Category:SQLSERVER Source: LUZERNV4-PDOSQL4 Number: 102 Message: Incorrect syntax near 'NoteID'. 2006-03-27 13:01:51.039 Percent Complete: 0 2006-03-27 13:01:51.070 Category:NULL Source: Merge Replication Provider Number: -2147201001 Message: The merge process was unable to deliver the snapshot to the Subscriber. If using Web synchronization, the merge process may have been unable to create or write to the message file. When troubleshooting, restart the synchronization with verbose history logging and specify an output file to which to write. 2006-03-27 13:01:51.133 Disconnecting from OLE DB Subscriber 'LUZERNV4-PDOSQL4' 2006-03-27 13:01:51.180 Disconnecting from OLE DB Subscriber 'LUZERNV4-PDOSQL4' 2006-03-27 13:01:51.226 Disconnecting from OLE DB Subscriber 'LUZERNV4-PDOSQL4' 2006-03-27 13:01:51.258 Disconnecting from OLE DB Subscriber 'LUZERNV4-PDOSQL4' 2006-03-27 13:01:51.305 Disconnecting from OLE DB Publisher 'LARGOS00-SDI' 2006-03-27 13:01:51.336 Disconnecting from OLE DB Publisher 'LARGOS00-SDI' 2006-03-27 13:01:51.383 Disconnecting from OLE DB Publisher 'LARGOS00-SDI' 2006-03-27 13:01:51.414 Disconnecting from OLE DB Publisher 'LARGOS00-SDI' 2006-03-27 13:01:51.445 Disconnecting from OLE DB Distributor 'LARGOS00-SDI' 2006-03-27 13:01:51.492 Disconnecting from OLE DB Distributor 'LARGOS00-SDI' 2006-03-27 13:01:51.523 The merge process will restart after waiting 60 second(s)...
The SQL Server Agent (MSSQLSERVER) service on server started and then stopped. If i Manually start the services also SQL Server Agent services are stopping automatically.Though I selected Auto Restart SQL Server Agent if it stops unexpectedly, The services are stopping automatically.TCP/IP protocol was enabled for port 1433.Are there any setup I missed?
I am currently running Windows XP Professional Service Pack2. It already has MSDE & SQL Server 2000 installed (although I just uninstalled MSDE in the vain hope that it might present the installer with a more straightforward upgrade).
I have tried installing with the default instance & a new instance (I don't really care - I just need to install the darn thing). I just want the basic database & Books On-line, nothing fancy.
Here is the Summary log, for what it's worth:
Microsoft SQL Server 2005 9.00.1399.06 ============================== OS Version : Microsoft Windows XP Professional Service Pack 2 (Build 2600) Time : Tue Feb 06 16:45:14 2007
Machine : ANTHONYY1 Product : Microsoft SQL Server Setup Support Files (English) Product Version : 9.00.1399.06 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0011_ANTHONYY1_SQLSupport_1.log -------------------------------------------------------------------------------- Machine : ANTHONYY1 Product : Microsoft SQL Server Native Client Product Version : 9.00.2047.00 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0011_ANTHONYY1_SQLNCLI_1.log -------------------------------------------------------------------------------- Machine : ANTHONYY1 Product : Microsoft Office 2003 Web Components Product Version : 11.0.6558.0 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0011_ANTHONYY1_OWC11_1.log -------------------------------------------------------------------------------- Machine : ANTHONYY1 Product : Microsoft SQL Server VSS Writer Product Version : 9.00.1399.06 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0011_ANTHONYY1_SqlWriter_1.log -------------------------------------------------------------------------------- Machine : ANTHONYY1 Product : Microsoft SQL Server 2005 Backward compatibility Product Version : 8.05.1054 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0011_ANTHONYY1_BackwardsCompat_1.log -------------------------------------------------------------------------------- Machine : ANTHONYY1 Product : MSXML 6.0 Parser (KB927977) Product Version : 6.00.3890.0 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0011_ANTHONYY1_MSXML6_1.log -------------------------------------------------------------------------------- Machine : ANTHONYY1 Product : Microsoft SQL Server Setup Support Files (English) Product Version : 9.00.1399.06 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0011_ANTHONYY1_SQLSupport_2.log -------------------------------------------------------------------------------- Machine : ANTHONYY1 Product : Microsoft SQL Server Native Client Product Version : 9.00.2047.00 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0011_ANTHONYY1_SQLNCLI_2.log -------------------------------------------------------------------------------- Machine : ANTHONYY1 Product : Microsoft Office 2003 Web Components Product Version : 11.0.6558.0 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0011_ANTHONYY1_OWC11_2.log -------------------------------------------------------------------------------- Machine : ANTHONYY1 Product : Microsoft SQL Server 2005 Books Online (English) Product Version : 9.00.1399.06 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0011_ANTHONYY1_BOL_1.log -------------------------------------------------------------------------------- Machine : ANTHONYY1 Product : Microsoft SQL Server 2005 Backward compatibility Product Version : 8.05.1054 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0011_ANTHONYY1_BackwardsCompat_2.log -------------------------------------------------------------------------------- Machine : ANTHONYY1 Product : MSXML 6.0 Parser (KB927977) Product Version : 6.00.3890.0 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0011_ANTHONYY1_MSXML6_2.log -------------------------------------------------------------------------------- Machine : ANTHONYY1 Product : SQLXML4 Error : Setup is preparing to continue with the installation. --------------------------------------------------------------------------------
Here is the SQLSetup0011_ANTHONYY1_Core(Local).log
Microsoft SQL Server 2005 Setup beginning at Tue Feb 06 16:45:14 2007 Process ID : 2560 C:Program FilesMicrosoft SQL Server90Setup Bootstrapsetup.exe Version: 2005.90.1399.0 Running: LoadResourcesAction at: 2007/1/6 16:45:14 Complete: LoadResourcesAction at: 2007/1/6 16:45:14, returned true Running: ParseBootstrapOptionsAction at: 2007/1/6 16:45:14 Loaded DLL:C:Program FilesMicrosoft SQL Server90Setup Bootstrapxmlrw.dll Version:2.0.3604.0 Complete: ParseBootstrapOptionsAction at: 2007/1/6 16:45:14, returned true Running: ValidateWinNTAction at: 2007/1/6 16:45:14 Complete: ValidateWinNTAction at: 2007/1/6 16:45:14, returned true Running: ValidateMinOSAction at: 2007/1/6 16:45:14 Complete: ValidateMinOSAction at: 2007/1/6 16:45:14, returned true Running: PerformSCCAction at: 2007/1/6 16:45:14 Complete: PerformSCCAction at: 2007/1/6 16:45:14, returned true Running: ActivateLoggingAction at: 2007/1/6 16:45:14 Complete: ActivateLoggingAction at: 2007/1/6 16:45:14, returned true Running: DetectPatchedBootstrapAction at: 2007/1/6 16:45:14 Complete: DetectPatchedBootstrapAction at: 2007/1/6 16:45:14, returned true Action "LaunchPatchedBootstrapAction" will be skipped due to the following restrictions: Condition "EventCondition: __STP_LaunchPatchedBootstrap__2560" returned false. Action "BeginBootstrapLogicStage" will be skipped due to the following restrictions: Condition "Setup is running locally." returned true. Running: PerformDotNetCheck2 at: 2007/1/6 16:45:14 Complete: PerformDotNetCheck2 at: 2007/1/6 16:45:14, returned true Running: InvokeSqlSetupDllAction at: 2007/1/6 16:45:14 Loaded DLL:C:Program FilesMicrosoft SQL Server90Setup Bootstrapsqlspars.dll Version:2005.90.1399.0 <Func Name='DwLaunchMsiExec'> Examining 'sqlspars' globals to initialize 'SetupStateScope' Opening 'MachineConfigScope' for [ANTHONYY1] 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. No Instance Name provided on the command line If possible, determine action Machine = ANTHONYY1, Article = WMIServiceWin32OSWorking, Result = 0 (0x0) Machine = ANTHONYY1, Article = WMIServiceWin32CompSystemWorking, Result = 0 (0x0) Machine = ANTHONYY1, Article = WMIServiceWin32ProcessorWorking, Result = 0 (0x0) Machine = ANTHONYY1, Article = WMIServiceReadRegWorking, Result = 0 (0x0) Machine = ANTHONYY1, Article = WMIServiceWin32DirectoryWorking, Result = 0 (0x0) Machine = ANTHONYY1, Article = WMIServiceCIMDataWorking, Result = 0 (0x0) Machine = ANTHONYY1, Article = XMLDomDocument, Result = 0 (0x0) Machine = ANTHONYY1, Article = Processor, Result = 0 (0x0) Machine = ANTHONYY1, Article = PhysicalMemory, Result = 0 (0x0) Machine = ANTHONYY1, Article = DiskFreeSpace, Result = 0 (0x0) Machine = ANTHONYY1, Article = OSVersion, Result = 0 (0x0) Machine = ANTHONYY1, Article = OSServicePack, Result = 0 (0x0) Machine = ANTHONYY1, Article = OSType, Result = 0 (0x0) Machine = ANTHONYY1, Article = iisDep, Result = 0 (0x0) Machine = ANTHONYY1, Article = AdminShare, Result = 0 (0x0) Machine = ANTHONYY1, Article = PendingReboot, Result = 70011 (0x1117b) Machine = ANTHONYY1, Article = PerfMon, Result = 0 (0x0) Machine = ANTHONYY1, Article = IEVersion, Result = 0 (0x0) Machine = ANTHONYY1, Article = DriveWriteAccess, Result = 0 (0x0) Machine = ANTHONYY1, Article = COMPlus, Result = 0 (0x0) Machine = ANTHONYY1, Article = ASPNETVersionRegistration, Result = 0 (0x0) Machine = ANTHONYY1, Article = MDAC25Version, Result = 0 (0x0) ******************************************* Setup Consistency Check Report for Machine: ANTHONYY1 ******************************************* 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 <Func Name='PerformDetections'> 0 <EndFunc Name='PerformDetections' Return='0' GetLastError='0'> <Func Name='DisplaySCCWizard'> CSetupBootstrapWizard returned 1 <EndFunc Name='DisplaySCCWizard' Return='0' GetLastError='183'> Failed to find help file for LCID :2057 Loaded DLL:C:Program FilesMicrosoft SQL Server90Setup Bootstrapsqlsval.dll Version:2005.90.1399.0 <EndFunc Name='DwLaunchMsiExec' Return='0' GetLastError='0'> Complete: InvokeSqlSetupDllAction at: 2007/1/6 16:49:35, returned true Running: SetPackageInstallStateAction at: 2007/1/6 16:49:35 Complete: SetPackageInstallStateAction at: 2007/1/6 16:49:36, returned true Running: DeterminePackageTransformsAction at: 2007/1/6 16:49:36 Complete: DeterminePackageTransformsAction at: 2007/1/6 16:49:47, returned true Running: ValidateSetupPropertiesAction at: 2007/1/6 16:49:47 Complete: ValidateSetupPropertiesAction at: 2007/1/6 16:49:47, returned true Running: OpenPipeAction at: 2007/1/6 16:49:47 Complete: OpenPipeAction at: 2007/1/6 16:49:47, returned false Error: Action "OpenPipeAction" failed during execution. Running: CreatePipeAction at: 2007/1/6 16:49:47 Complete: CreatePipeAction at: 2007/1/6 16:49:47, returned false Error: Action "CreatePipeAction" failed during execution. Action "RunRemoteSetupAction" will be skipped due to the following restrictions: Condition "Action: CreatePipeAction has finished and passed." returned false. Running: PopulateMutatorDbAction at: 2007/1/6 16:49:47 Complete: PopulateMutatorDbAction at: 2007/1/6 16:49:47, returned true Running: GenerateRequestsAction at: 2007/1/6 16:49:47 SQL_Engine = 3 SQL_Data_Files = 3 SQL_Replication = 3 SQL_FullText = 3 SQL_SharedTools = 3 SQL_BC_DEP = 3 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 = 3 Connectivity = 3 SQL_Tools90 = 3 SQL_WarehouseDevWorkbench = 3 SDK = 3 SQLXML = 3 Tools_Legacy = 3 TOOLS_BC_DEP = 3 SQL_Documentation = 3 SQL_BooksOnline = 3 SQL_DatabaseSamples = -1 SQL_AdventureWorksSamples = -1 SQL_AdventureWorksDWSamples = -1 SQL_AdventureWorksASSamples = -1 SQL_Samples = -1 Complete: GenerateRequestsAction at: 2007/1/6 16:49:48, returned true Running: CreateProgressWindowAction at: 2007/1/6 16:49:48 Complete: CreateProgressWindowAction at: 2007/1/6 16:49:48, returned true Running: ScheduleActionAction at: 2007/1/6 16:49:48 Complete: ScheduleActionAction at: 2007/1/6 16:49:48, returned true Skipped: InstallASAction.11 Skipped: Action "InstallASAction.11" was not run. Information reported during analysis: No install request found for package: "sqlsupport", referred by package: "as", install will be skipped as a result. Skipped: InstallASAction.18 Skipped: Action "InstallASAction.18" was not run. Information reported during analysis: No install request found for package: "owc11", referred by package: "as", install will be skipped as a result. Skipped: InstallASAction.22 Skipped: Action "InstallASAction.22" was not run. Information reported during analysis: No install request found for package: "bcRedist", referred by package: "as", install will be skipped as a result. Skipped: InstallASAction.9 Skipped: Action "InstallASAction.9" was not run. Information reported during analysis: No install request found for package: "msxml6", referred by package: "as", install will be skipped as a result. Skipped: InstallDTSAction Skipped: Action "InstallDTSAction" was not run. Information reported during analysis: No install request found for package: "dts", install will be skipped as a result. Skipped: InstallDTSAction.11 Skipped: Action "InstallDTSAction.11" was not run. Information reported during analysis: No install request found for package: "sqlsupport", referred by package: "dts", install will be skipped as a result. Skipped: InstallDTSAction.12 Skipped: Action "InstallDTSAction.12" was not run. Information reported during analysis: No install request found for package: "sqlncli", referred by package: "dts", install will be skipped as a result. Skipped: InstallDTSAction.18 Skipped: Action "InstallDTSAction.18" was not run. Information reported during analysis: No install request found for package: "owc11", referred by package: "dts", install will be skipped as a result. Skipped: InstallDTSAction.22 Skipped: Action "InstallDTSAction.22" was not run. Information reported during analysis: No install request found for package: "bcRedist", referred by package: "dts", install will be skipped as a result. Skipped: InstallDTSAction.9 Skipped: Action "InstallDTSAction.9" was not run. Information reported during analysis: No install request found for package: "msxml6", referred by package: "dts", install will be skipped as a result. Skipped: InstallNSAction Skipped: Action "InstallNSAction" was not run. Information reported during analysis: No install request found for package: "ns", install will be skipped as a result. Skipped: InstallNSAction.11 Skipped: Action "InstallNSAction.11" was not run. Information reported during analysis: No install request found for package: "sqlsupport", referred by package: "ns", install will be skipped as a result. Skipped: InstallNSAction.12 Skipped: Action "InstallNSAction.12" was not run. Information reported during analysis: No install request found for package: "sqlncli", referred by package: "ns", install will be skipped as a result. Skipped: InstallNSAction.18 Skipped: Action "InstallNSAction.18" was not run. Information reported during analysis: No install request found for package: "owc11", referred by package: "ns", install will be skipped as a result. Skipped: InstallNSAction.22 Skipped: Action "InstallNSAction.22" was not run. Information reported during analysis: No install request found for package: "bcRedist", referred by package: "ns", install will be skipped as a result. Skipped: InstallNSAction.9 Skipped: Action "InstallNSAction.9" was not run. Information reported during analysis: No install request found for package: "msxml6", referred by package: "ns", install will be skipped as a result. Skipped: InstallRSAction.11 Skipped: Action "InstallRSAction.11" was not run. Information reported during analysis: No install request found for package: "sqlsupport", referred by package: "rs", install will be skipped as a result. Skipped: InstallRSAction.18 Skipped: Action "InstallRSAction.18" was not run. Information reported during analysis: No install request found for package: "owc11", referred by package: "rs", install will be skipped as a result. Skipped: InstallRSAction.22 Skipped: Action "InstallRSAction.22" was not run. Information reported during analysis: No install request found for package: "bcRedist", referred by package: "rs", install will be skipped as a result. Running: InstallSqlAction.11 at: 2007/1/6 16:49:48 Installing: sqlsupport on target: ANTHONYY1 Complete: InstallSqlAction.11 at: 2007/1/6 16:49:51, returned true Running: InstallSqlAction.12 at: 2007/1/6 16:49:51 Installing: sqlncli on target: ANTHONYY1 Complete: InstallSqlAction.12 at: 2007/1/6 16:49:55, returned true Running: InstallSqlAction.18 at: 2007/1/6 16:49:55 Installing: owc11 on target: ANTHONYY1 Complete: InstallSqlAction.18 at: 2007/1/6 16:49:56, returned true Running: InstallSqlAction.21 at: 2007/1/6 16:49:56 Installing: sqlwriter on target: ANTHONYY1 Complete: InstallSqlAction.21 at: 2007/1/6 16:49:58, returned true Running: InstallSqlAction.22 at: 2007/1/6 16:49:58 Installing: bcRedist on target: ANTHONYY1 Complete: InstallSqlAction.22 at: 2007/1/6 16:50:0, returned true Running: InstallSqlAction.9 at: 2007/1/6 16:50:0 Installing: msxml6 on target: ANTHONYY1 Complete: InstallSqlAction.9 at: 2007/1/6 16:50:2, returned true Running: InstallToolsAction.11 at: 2007/1/6 16:50:2 Installing: sqlsupport on target: ANTHONYY1 Complete: InstallToolsAction.11 at: 2007/1/6 16:50:5, returned true Running: InstallToolsAction.12 at: 2007/1/6 16:50:5 Installing: sqlncli on target: ANTHONYY1 Complete: InstallToolsAction.12 at: 2007/1/6 16:50:8, returned true Skipped: InstallToolsAction.13 Skipped: Action "InstallToolsAction.13" was not run. Information reported during analysis: No install request found for package: "PPESku", referred by package: "tools", install will be skipped as a result. Running: InstallToolsAction.18 at: 2007/1/6 16:50:8 Installing: owc11 on target: ANTHONYY1 Complete: InstallToolsAction.18 at: 2007/1/6 16:50:10, returned true Running: InstallToolsAction.20 at: 2007/1/6 16:50:10 Installing: BOL on target: ANTHONYY1 Complete: InstallToolsAction.20 at: 2007/1/6 16:52:2, returned true Running: InstallToolsAction.22 at: 2007/1/6 16:52:2 Installing: bcRedist on target: ANTHONYY1 Complete: InstallToolsAction.22 at: 2007/1/6 16:52:4, returned true Running: InstallToolsAction.9 at: 2007/1/6 16:52:4 Installing: msxml6 on target: ANTHONYY1 Complete: InstallToolsAction.9 at: 2007/1/6 16:52:6, returned true Skipped: InstallNSAction.10 Skipped: Action "InstallNSAction.10" was not run. Information reported during analysis: No install request found for package: "sqlxml4", referred by package: "ns", install will be skipped as a result. Running: InstallSqlAction at: 2007/1/6 16:52:7 Installing: sql on target: ANTHONYY1 Error: MsiOpenDatabase failed with 110 Failed to install package This installation package could not be opened. Contact the application vendor to verify that this is a valid Windows Installer package. Error: MsiOpenDatabase failed with 110 for MSI D:ServersSetupSqlRun_SQL.msi Setting package return code to: 1620 Complete: InstallSqlAction at: 2007/1/6 16:52:27, returned false Error: Action "InstallSqlAction" failed during execution. Error information reported during run: Target collection includes the local machine. Invoking installPackage() on local machine. Running: InstallToolsAction.10 at: 2007/1/6 16:52:27 Installing: sqlxml4 on target: ANTHONYY1 Error Code: 0x8007006e (110) Windows Error Text: The system cannot open the device or file specified.
Source File Name: sqlchainingminorbuildactionbehavior.cpp Compiler Timestamp: Mon Jun 13 14:30:04 2005 Function Name: sqls::MinorBuildActionBehavior::modifyRequest Source Line Number: 65
Complete: InstallToolsAction.10 at: 2007/1/6 16:55:59, returned false Error: Action "InstallToolsAction.10" failed during execution. Error information reported during run: Target collection includes the local machine. Invoking installPackage() on local machine. Action "InstallToolsAction" will return false due to the following preconditions: Condition "Action: InstallToolsAction.10 has finished and failed." returned true. Installation of package: "tools" failed due to a precondition. Step "InstallToolsAction" was not able to run. Skipped: InstallASAction Skipped: Action "InstallASAction" was not run. Information reported during analysis: No install request found for package: "as", install will be skipped as a result. Skipped: InstallRSAction Skipped: Action "InstallRSAction" was not run. Information reported during analysis: No install request found for package: "rs", install will be skipped as a result. Skipped: RepairForBackwardsCompatRedistAction Skipped: Action "RepairForBackwardsCompatRedistAction" was not run. Information reported during analysis: Action: "RepairForBackwardsCompatRedistAction" will be skipped due to the following condition: Condition "sql was successfully upgraded." returned false. Condition context: sql failed to upgrade and so the uninstall of the upgraded product will not occur. Error: Action "UninstallForMSDE2000Action" failed during execution. Error information reported during run: Action: "UninstallForMSDE2000Action" will be marked as failed due to the following condition: Condition "sql was successfully upgraded." returned false. Condition context: sql failed to upgrade and so the uninstall of the upgraded product will not occur. Installation of package: "patchMSDE2000" failed due to a precondition. Error: Action "UninstallForSQLAction" failed during execution. Error information reported during run: Action: "UninstallForSQLAction" will be marked as failed due to the following condition: Condition "sql was successfully upgraded." returned false. Condition context: sql failed to upgrade and so the uninstall of the upgraded product will not occur. Installation of package: "patchLibertySql" failed due to a precondition. Skipped: UninstallForRS2000Action Skipped: Action "UninstallForRS2000Action" was not run. Information reported during analysis: Action: "UninstallForRS2000Action" will be skipped due to the following condition: Condition "Action: InstallRSAction was skipped." returned true. Running: ReportChainingResults at: 2007/1/6 16:55:59 Error: Action "ReportChainingResults" threw an exception during execution. One or more packages failed to install. Refer to logs for error details. : 1620 Error Code: 0x80070654 (1620) Windows Error Text: This installation package could not be opened. Contact the application vendor to verify that this is a valid Windows Installer package.
Source File Name: sqlchainingsqlchainingactions.cpp Compiler Timestamp: Thu Sep 1 22:23:05 2005 Function Name: sqls::ReportChainingResults::perform Source Line Number: 3097
---- Context ----------------------------------------------- sqls::HostSetupPackageInstallerSynch::postCommit sqls::HighlyAvailablePackage::preInstall led due to cancel code received from cancel source: 29539
...and here is the SQLSetup0011_ANTHONYY1_SQL.log:
=== Verbose logging started: 06/02/2007 16:52:14 Build type: SHIP UNICODE 3.01.4000.2435 Calling process: C:Program FilesMicrosoft SQL Server90Setup Bootstrapsetup.exe === MSI (c) (00:54) [16:52:14:284]: Resetting cached policy values MSI (c) (00:54) [16:52:14:284]: Machine policy value 'Debug' is 0 MSI (c) (00:54) [16:52:14:284]: ******* RunEngine: ******* Product: D:ServersSetupSqlRun_SQL.msi ******* Action: ******* CommandLine: ********** MSI (c) (00:54) [16:52:14:284]: Client-side and UI is none or basic: Running entire install on the server. MSI (c) (00:54) [16:52:14:284]: Grabbed execution mutex. MSI (c) (00:54) [16:52:14:299]: Cloaking enabled. MSI (c) (00:54) [16:52:14:299]: Attempting to enable all disabled priveleges before calling Install on Server MSI (c) (00:54) [16:52:14:299]: Incrementing counter to disable shutdown. Counter after increment: 0 MSI (s) (A4:98) [16:52:14:299]: Grabbed execution mutex. MSI (s) (A4:00) [16:52:14:299]: Resetting cached policy values MSI (s) (A4:00) [16:52:14:299]: Machine policy value 'Debug' is 0 MSI (s) (A4:00) [16:52:14:299]: ******* RunEngine: ******* Product: D:ServersSetupSqlRun_SQL.msi ******* Action: ******* CommandLine: ********** MSI (s) (A4:00) [16:52:21:080]: Note: 1: 2203 2: D:ServersSetupSqlRun_SQL.msi 3: -2147024873 MSI (s) (A4:00) [16:52:21:080]: MainEngineThread is returning 1620 MSI (c) (00:54) [16:52:21:080]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied. Counter after decrement: -1 MSI (c) (00:54) [16:52:21:080]: MainEngineThread is returning 1620 === Verbose logging stopped: 06/02/2007 16:52:21 ===
I suppose an error dialog (or log message) that actually told you what is wrong and then what to do is too much to ask for. (Or an installer than just copied all the files into place). :(
I am actually the MOM administrator and only know enough SQL 2005 to keep mom working....sometimes I noticed on my dev mom box that SQL server agent has a lot of jobs configured to run against the mom onepoint database. The production box does not have these jobs. What would be the simplest way to export these jobs so that i can import them on the production box. Any help would be appreciated.
In one off my production box, we are notable to take a backups of MSDB . When i look at the error, it is failing locate allocation unit ID.. complete error as below
Msg 2533,Sev 16,State 1, Line 36 : Table error : Page (1:111720 ) allocated to object id 110623437, index ID 1, Partition ID 72057594043432960, alloc unit ID 72057594044874752 (type-inrow data) was not seen. This page is invalid or may have an incorrect alloc unit ID in its header.[SQLSTATE 42000]
Due this failure, we are unable to take the backup of MSDB database and our integrity check and reindex jobs also failured with the same.Also, I could see events of I/O issues with underlaying hard dirve with following name
DeviceHarddisk0DR0,has a bad block.
1. I dont no what could happen if restart my server, Question is: Does it recognize MSDB during server statup.
Whenever i change the SA password to anything else, my SQL Agent services like jobs, alerts starts falling, and if i attempt to stop and then restart sql agent service, it will not start again.
My server uses sql authentication for everything...
I am having problems with an SSIS package whereby the first step of the package is failing. I am getting the following error message:
Unable to connect to FTP server using "FTPLocation".
This only happens when I use a Agent Proxy as the 'Run as' option. If I change it back to SQL Agent Service Account it works perfectly.
For the credentials of the proxy, I have used my own windows login as the identity. And I have full priveleges on the server, ie if I log on to the server I can successfully ftp to the same site and download the file without any problems. So shouldn't the Agent be able to do so too when it uses my credentials?
I found a similar thread posted under the same title as this by dba123. Unfortunately, his solution does not match my problem.
I have a SSIS package that will run fine in debug mode, will run fine when published to the server when I right click and execute it. However, when I run it through a job, either scheduled or running the job manually, the job fails. There is an entry in the servers application log telling me that "login failed for user xxxxx" where xxxxx is the name of SQL login that I am using. I know that the login works (logged in manually to the server via management studio, and it runs fine when I run it manually). Both connection managers are SQL, no flat files or other data source types. All the commands are T-SQL. The SQL Agent has full database access to both servers that the connection manager connects to - and its NOT the profile that is reporting as failing - it is a domain account.
This is totally bizzare - ANY help would be appreciated.
Hi, I have a problem with an Access db connection in my package when run by SQL Agent. I have problem running a job with my package so i used the log and found out that when i change the connection property of the access connection manager in my package to a local Access file on my machine, it works just fine but if i change the connection to that of an Access db on my Y drive (which has been set up on my machine), it doesnt execute. I checked the security property of the network folder in which the access db exist and I do have rights. That is to say, i dont know why it cannot access it then. The funny part is that when i run the packae in SSIS (VS.NET) or Intergration services in Managment studio, it runs just fine but when i execute the job through Sql Server Agent, it generates the following error:
OnError,CYPRESS0927,CYPRESSebuah,CLMH from ocan access,{b1f7035e-919c-434b-8a1d-d0f6267a13aa},{6ED748E8-16C0-4E9A-9DBD-882641657572},2/20/2006 6:15:15 PM,2/20/2006 6:15:15 PM,-1071611876,0x,The AcquireConnection method call to the connection manager "ocan_conn" failed with error code 0xC0202009.
ocan_conn is the name of my connection object to the access db in my package.
They wre runnning fine until 4/21/2008 then all SSIS packages started to fail.
Simple SQL jobs are still running fine thouhgt and reporting success.
Unable to start execution of step 1 (reason: The SSIS subsystem failed to load [see the SQLAGENT.OUT file for details]; The job has been suspended). The step failed.
My SQL Agent was working fine. Now when I try to run it, it failes when trying to run my SSIS package. I looked in the logs, and job history, no luck in finding any critical errors.
My SSIS package runs fine through VS 2005 in debug mode.
Here are the only errors:
01/04/2006 09:53:48,,Warning,[396] An idle CPU condition has not been defined - OnIdle job schedules will have no effect 01/04/2006 09:53:48,,Warning,[260] Unable to start mail session (reason: No mail profile defined) 01/04/2006 09:53:48,,Information,[129] SQLSERVERAGENT starting under Windows NT service control 01/04/2006 09:53:48,,Error,[364] The Messenger service has not been started - NetSend notifications will not be sent 01/04/2006 09:53:30,,Information,[432] There are 11 subsystems in the subsystems cache 01/04/2006 09:53:29,,Information,[339] Local computer is BG-SQL2005 running Windows NT 5.2 (3790) Service Pack 1 01/04/2006 09:53:29,,Information,[310] 1 processor(s) and 512 MB RAM detected 01/04/2006 09:53:29,,Information,[103] NetLib being used by driver is DBNETLIB.DLL; Local host server is 01/04/2006 09:53:29,,Information,[102] SQL Server ODBC driver version 9.00.1399 01/04/2006 09:53:29,,Information,[101] SQL Server BG-SQL2005 version 9.00.1399 (0 connection limit) 01/04/2006 09:53:29,,Information,[100] Microsoft SQLServerAgent version 9.00.1399.06 (x86 unicode retail build) : Process ID 1860
I've created a package that runs fine from BIDS when logged in with my domain account. I have created a SQL Agent Proxy on the server with that same account. In the Job Step on the server, I edit the connection strings so that username and password is there for both my source Access connection and the destination SQL Server. Here is the connection string I create for MS Access:
Code SnippetData Source=\10.210.226.202OTM Reports for SymmetricsCDRD001.MDB;User ID=admin;Password=;Provider=Microsoft.Jet.OLEDB.4.0;
Here is the error:
Code SnippetExecuted as user: DOMAINMRUSER. ethod call to the connection manager "MSAccessDB" failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireConnection method call failed. End Error Error: 2008-01-30 09:49:19.66 Code: 0xC0047017 Source: Cost DTS.Pipeline Description: component "Cost" (1) failed validation and returned error code 0xC020801C. End Error Error: 2008-01-30 09:49:19.66 Code: 0xC004700C Source: Cost DTS.Pipeline
I have tried with various settings in the package for "ProtectionLevel" such as "DontSaveSensitive" and "EncryptSensitiveWithUserKey". I would think that using my account with the proxy the last option would work when running it on the server, since it is essentially the same user running the package, but I'm new to playing with the proxy.
I tried using package configurations but got an error there too, think it couldn't access the file, event though it was on an accessible share--accessible to my account.
I have created a package that extracts data from an Oracle 10g database into a database on SQL Server 2005 SP2.
This package run fine when run inside BIDS and also if run from DTExecUI or DTExec (This is done while logged in using the same domain account that runs both the SQL Service and the SQL Agent Service. This account is also a local admin on the box.)
When I try to schedule this with SQL Server Agent (running under the SQL Agent Service Account) it returns an MSDAORA error
"Oracle client and network components were not found"
The same error occurs if I try to use CmdExe step to try and execute the DTExec command.
The interesting part however is that I use a lower privaleged proxy account then
(a) Executing the package directly still fails but (b) Running a DTExec command will succed
Can anyone provide an explanation for this behaviour. While I can work around this "feature" by using the DTExec and a proxy account it does make the packages harder to configure/debug and defeats many of the configuration advantages provided by SSIS
Using SQL 2005, SSIS, I have an SSIS package which is scheduled as a SQL Server Agent job. The package contains a Send Mail task. This task fails when SQL Agent runs the package. The task succeeds when executed interactively from the package, logged on as the SQL Agent service account. The package as a whole succeeds when executed from "Start Debugging". An Execute SQL Task in the same package containing an sp_send_dbmail statement succeeds when SQL Agent runs the job, and the same sp_send_dbmail succeeds in Mgmt Studio query window. All these events all logged onto the server as the SQL Server/SQL Agent service account.
I would appreciate ideas on what else to check for here, so that I can use the Send Mail SSIS task in packages which are run by SQL Agent jobs.
1) Gave the sql agent account permissions to the msdb database and other databases
2) Checked the paths for "Data Sources" under properties of my agent in the SSIS properties
3) Set the authentification to Windows and used the sql agent account (a domain account that I setup) to run the agent. I also tried my login. So it's not a permission issue, because I do not get permission errors...it's past this.
What works:
1) Other SQL Agent packages...they are not running an SSIS package, just SQL
2) Running the SSiS package by right-clicking on it in Management Sudio. No errors found in the execution and the package does it's intended function
3) Package runs fine with absolutely no errors in VS 2005
What doesn't work:
1) My agent that points to my SSIS package. All this agent does is run that package. When I run the agent, I get a minimal error message in the job history logs stating the following error message:
03/09/2006 12:49:58,Run EN Process,Error,0,BG-22SQL,Run EN Process,(Job outcome),,The job failed. The Job was invoked by User domainmy_account. The last step to run was step 1 (Run EN SSIS Package).,00:00:02,0,0,,,,0
03/09/2006 12:49:58,Run EN Process,Error,1,BG-22SQL,Run EN Process,Run EN SSIS Package,,Executed as user: domainsqlagent_account. The package execution failed. The step failed.,00:00:01,0,0,,,,0
I am trying to get details out of targetinstance from a WMI alert, using Token Replacement in the job step.
The alert fires properly.
The WQL query for the alert is:
select * from __InstanceModificationEvent within 300 where targetinstance ISA 'Win32_LogicalDisk' and TargetInstance.DriveType = 3 and TargetInstance.Freespace < 44832876928
However, I can't get the WMI info out from the alert - everything I've read says it's within TargetInstance, but I don't see how to use the WMI call for it. I'm specifically looking for DeviceID In the job step, I've tried multiple variations. Only the __CLASS has worked, and that's because it's not within TargetInstance.Â
set @mybody = '$(ESCAPE_SQUOTE(WMI(DeviceID)))' set @mybody = '$(ESCAPE_SQUOTE(WMI(TargetInstanceDeviceID)))' set @mybody = '$(ESCAPE_SQUOTE(WMI(__CLASS)))' set @mybody = '$(ESCAPE_SQUOTE(WMI(TargetInstance.DeviceID)))'
I have installed SQL 2014 (Evaluation Version) on testing machine. We want to import some excel files on database. I manually created one Test Database and now trying to import excel file. Import completed successfully but I am not able to see any table created as result of Import. I tried it 3-4 times and even restarted sql services but no luck.
I am trying to move a database which I wrote in SQL Server 2005 to a SQL Server 2000 database. I'm not sure the best way to do this....... Can anyone enlighten me?.....
One of my programmers changed their database from full to Simple recovery. Saw that my job that backs up the Full Recovery mode databases failed, so I moved that database to my Simple database backup job plan and removed it from the Full Recovery job. I am unable to remove the db from the Transaction Log task on the Full Plan because when I try to edit that job "Databases with Simple Recovery will be excluded"
My transaction log backups are still failing with the following error: "The statement BACKUP LOG is not allowed while the recovery model is SIMPLE. Use BACKUP DATABASE or change the recovery model using ALTER DATABASE. BACKUP LOG is terminating abnormally.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.Just want to remove that database so my Full Recovery backup job does not try to back it up.
I have a SQL Server 2005 Express database on my local machince called OpenAssess.mdf. The server we host with has a file extension of .mdb. How can I go about getting my database to the server? I tried changing the extension to mdb on the local machine but then it tried opening the database in MS Access and didn't work. I just need to connect to the database in my web pages. Here is my connection string and then the error which is visible at the botton of openassessment.org. *********************************************connection string************************************************* OPEN_Conn = "Provider=SQLOLEDB;Data Source=connectionToHostServer;Network Library=DBMSSOCN;Initial Catalog=OpenAssess.mdb;User ID=myuserid;Password=mypassword" *****************************************************error********************************************************* Microsoft OLE DB Provider for SQL Server error '80004005' Cannot open database requested in login 'OpenAssess.mdb'. Login fails.
i got few questions. i need to move a databases from old server to new server. old server has 25 user databases total datafile around 300GB. heres the questions.
1. what is the fastest way to move all the data to new server? and what's the best way to do it? (DTS? MDF copy over/attach? bak copy over/restore? other theres other way?)
2. i got alot of job and user need to transfer over. i know DTS can do the user.. how about the jobs?
3. do i need to move the master and msdb over too?
4. beside all 3 questions above... do i miss anything that need to be move too?
Hi, I have a database that resides on a server that`s become too old. It spans 2 devices that sit on 2 different drive letters - D: and E:. I bought a new server, installed and configured NT4.0 and SQL6.5. Initially I restored the database to the new server from a dump .It worked fine, however all the login information was lost. Then I tried partitioning the new server the same way as the old one and copying all the DAT files over. Thus I was hoping to retain the information contained in the MASTER.DAT, drop the database, repartition to create 1 physical drivewith 1 database device, and restore from a dump to it. After copying the DATs, though, SQL Server would not start. Help Please!
I am not a SQL person. I want to copy/move a SQL datbase from old server to a new server and eventualy bring the old server down. What is the procedure to do it. Thanks in advance.
Hi all. I know that since you know nothing about my database it will be a stretch to answer this - but does anyone have a boiler plate checklist for moving a database, dts packages, agent jobs, etc...from one server to another? Maybe something that just says I should at least do x,y,z.
Also if anyone out there has any hard won experience/advice about gotchas when doing this I would love to hear it. We have outgrown a server and are installing a new one this week that we need to move over to.
