Quick Upgrade SQL Environment (Database Engine, SSIS, SSRS, Etc.) Exchange Hardware Plan

Feb 7, 2008

We have installation of Dbase Engine and SSIS that is PRODUCTION, and want to replace with newer hardware. In "the old days", we built "boxname_new" and installed SQL with "sqlname_new", took PROD users off-line, and quickly renamed original boxes/SQL and new boxes/SQL to original name, copied data and off we went with upgrade.



NOW, the "renaming" option for SQL tools is not supported, but with re-installation.



Has anyone developed game plan steps for accomplishing hardware upgrade, including SQL environment swap with MINIMAL downtime for PRODUCTION environment? Can you share?

View 2 Replies


ADVERTISEMENT

SQL Server 2014 :: Maintenance Plan Not Visible Under Database Engine After Import

Aug 13, 2015

I have a query. Here are the steps:

1. I created a maintenance plan using Visual Studio 2013 (nothing fancy pretty basic)
2. Using ssms 2014 I imported it (the dtsx file) under the Integration Services and it appeared there successfully
3. I connected to the Database Engine again using ssms 2014 - my expectation was to see it under the Management > Maintenance Plans folder but it was not present.

View 0 Replies View Related

Setup And Upgrade :: 2012 - Database Engine Services Failed

Mar 26, 2013

I can't install the SQL Server 2012 Express version with tools downloaded from [URL]

I'm getting the following error: 

Error installing SQL Server Database Engine Services Instance Features
Could not find the Database Engine startup handle.
Error code: 0x851A0019

I'm trying to install a new stand-alone version with a default instance but always getting this error. From the features I'm installing the database engine services (not the replication), all the tools, only the basic management toolds and the SQL Client connectivity SDK.

Further in the installation I'm choosing the Windows authentication and in the list of SQL administrators I've already tried to install as current user but also as System. Both with the same error result.

[URL]

Note: Visual studio is not installed.

View 8 Replies View Related

Converter And Chunk Errors After SSRS Database Upgrade

Jun 1, 2007

Following upgrade to SSRS2005, Reporting Services worked EXCEPT from within applications or from scheduled jobs. Running reports from application-generated URL€™s produced the following error: €˜An internal error occurred on the report server. See the error log for more details€™. These same reports, however, ran perfectly from within SSRS. After running them once from Reporting Services, they subsequently run without problem when called by applications or jobs.

Examples of these errors include the following (stack traces available if needed):

ReportingServicesService!runningjobs!13!5/27/2007-01:57:23:: i INFO: Adding: 1 running jobs to the database
ReportingServicesService!chunks!f!05/27/2007-01:58:34:: e ERROR: LockSnapshotForUpgrade: System.Data.SqlClient.SqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)

ReportingServicesService!chunks!1a!05/27/2007-01:58:34:: e ERROR: GetChunkPointerAndLength: System.Data.SqlClient.SqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)

ReportingServicesService!chunks!11!05/27/2007-01:58:34:: e ERROR: ### SnapshotConverter(00d68151-85e5-4669-a0de-28ed81bd091c, True), System.Data.SqlClient.SqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)

Log entries below correspond to the following attempts to run a specific report.

ENF_Comprehensive_Report 5/31/2007 9:43:37 AM rsInternalError
(one of many user attempts to run from app after upgrade)
ENF_Comprehensive_Report 5/31/2007 10:50:57 AM rsSuccess
(first successful run after upgrade; run from within SSRS)
ENF_Comprehensive_Report 5/31/2007 11:09:59 AM rsSuccess
(first successful run by user from application)

It appears that after the upgrade Reporting Services was attempting to use non-existent or invalid chunks and snapshots to satisfy application or job originated requests. When first called from within SSRS, the old chunk was accessed but then appears to have been ignored, with subsequent calls running without a chunk. Our workaround for the problem was to manually run each of our 200+ reports from within SSRS to €˜initialize€™ them for applications and jobs.

Typical Application Request Failure for report:
w3wp!library!a!5/31/2007-09:43:22:: i INFO: Cleaned 0 batch records, 0 policies, 4 sessions, 0 cache entries, 5 snapshots, 46 chunks, 0 running jobs, 0 persisted streams
w3wp!library!a!05/31/2007-09:43:37:: i INFO: Call to RenderFirst( '/Enforcement/Historical/ENF_Comprehensive_Report' )
w3wp!chunks!a!05/31/2007-09:43:37:: i INFO: Returning old chunk for: (24788648-41c5-43d8-ba6b-409662211a37, 'CompiledDefinition', 0)
w3wp!runningjobs!6!5/31/2007-09:44:29:: i INFO: Adding: 1 running jobs to the database
w3wp!chunks!a!05/31/2007-09:45:37:: e ERROR: ### SnapshotConverter(24788648-41c5-43d8-ba6b-409662211a37, True), System.Data.SqlClient.SqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
ßstack trace entries here€”>
w3wp!library!a!05/31/2007-09:45:37:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details. ---> System.Data.SqlClient.SqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
ßstack trace entries here€”>
--- End of inner exception stack trace ---
w3wp!webserver!a!05/31/2007-09:45:37:: e ERROR: Reporting Services error Microsoft.ReportingServices.Diagnostics.Utilities.RSException: An internal error occurred on the report server. See the error log for more details. ---> Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details. ---> System.Data.SqlClient.SqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.

First run of report from within Reporting Services following upgrade:
w3wp!library!19!05/31/2007-10:50:30:: Call to GetPermissionsAction(/Enforcement/Historical/ENF_Comprehensive_Report).
w3wp!library!19!05/31/2007-10:50:30:: Call to GetSystemPropertiesAction().
w3wp!library!19!05/31/2007-10:50:30:: Call to GetPropertiesAction(/Enforcement/Historical/ENF_Comprehensive_Report, PathBased).
w3wp!chunks!19!05/31/2007-10:50:30:: i INFO: Returning old chunk for: (24788648-41c5-43d8-ba6b-409662211a37, 'CompiledDefinition', 0)
w3wp!library!1!05/31/2007-10:50:31:: Call to GetSystemPermissionsAction().
w3wp!library!1!05/31/2007-10:50:31:: Call to GetPropertiesAction(/Enforcement/Historical/ENF_Comprehensive_Report, PathBased).
w3wp!library!e!05/31/2007-10:50:31:: Call to GetSystemPropertiesAction().
w3wp!library!1!05/31/2007-10:50:56:: Call to GetPermissionsAction(/Enforcement/Historical/ENF_Comprehensive_Report).
w3wp!library!6!05/31/2007-10:50:56:: Call to GetSystemPropertiesAction().
w3wp!library!6!05/31/2007-10:50:56:: Call to GetPropertiesAction(/Enforcement/Historical/ENF_Comprehensive_Report, PathBased).
w3wp!library!6!05/31/2007-10:50:56:: Call to GetSystemPermissionsAction().
w3wp!library!6!05/31/2007-10:50:56:: Call to GetPropertiesAction(/Enforcement/Historical/ENF_Comprehensive_Report, PathBased).
w3wp!library!6!05/31/2007-10:50:56:: Call to GetSystemPropertiesAction().
w3wp!library!1!05/31/2007-10:50:57:: i INFO: Call to RenderFirst( '/Enforcement/Historical/ENF_Comprehensive_Report' )
w3wp!webserver!1!05/31/2007-10:50:58:: i INFO: Processed report.

Subsequent application request for same report:
w3wp!library!11!05/31/2007-11:09:59:: i INFO: Call to RenderFirst( '/Enforcement/Historical/ENF_Comprehensive_Report' )
w3wp!webserver!11!05/31/2007-11:10:00:: i INFO: Processed report. Report='/Enforcement/Historical/ENF_Comprehensive_Report', Stream=''

Environment: 32-bit WK3 Enterprise R2 SP2 with single instance of SQL2000 SP3 hosting SSRS2005 SP2 metadata; IIS running in 6.0 isolation mode; separate dedicated IIS server; dedicated domain user accounts for service accounts and application pools. Over 200 reports deployed, half of which are run by users from within applications.

SSRS upgrade process: backup up existing databases, settings, keys; uninstall SSRS2000; perform €˜files only€™ install of SSRS2005 to existing SQL2000 instance; manually configure SSRS2005 and IIS; upgrade reporting services databases.

This is a followup of a previous posting to this forum 30-May 6:28 pm UTC: Problems following SSRS database upgrade.

View 2 Replies View Related

How To Deploy Updated Database From Development Environment To Live Environment?

Nov 16, 2005

I have finished a change request from our client. I need to update clients' database with the one in developments.Here is the changes i made to database:Added/Changed some tablesAdded/Changed some stored proceduresAdded data to some dictionary tableThe data in clients' current database MUST be kept. So how can I merge the changed information to clients' database?

View 3 Replies View Related

DB Engine :: Linked Server Set In Cluster Environment

Apr 24, 2015

Need to set up a linked server in two node SQL Cluster pointing to a standalone SQL thru security setting "be made using current login's security context". It's double hop Kerberos setup. Cluster uses a domain account, so we manually set SPNs for that account with both instance name and protocol as well (set up these SPNs with SQL virtual name only).

Also, constrained delegation has been  set to that stand alone SQL services (MSSQLSvc).

Both SQL cluster and standalone servers are in same domain, cluster service account is domain account and standalone SQL uses default SQL local service account.

Coming to SQL, when I create linked server, sometimes it lets me create without issues and sometime it throws this below warning and even if I create it won't work.

 Login failed for user 'NT AUTHORITY/ANANOMOUS LOGIN'. 

View 6 Replies View Related

DB Engine :: AlwaysOn Feature On Cluster Environment

Sep 16, 2015

To set up AlwaysOn Feature on cluster environment how many VM's we would require.

We have already have 2 VM's for cluster but am not able to configure AlwaysOn. 

View 2 Replies View Related

Setup And Upgrade :: Several Same Environment Variables In Path

May 5, 2015

I noticed accidentally today on my PATH and discovered that I have several variables for different sql versions. I can understand this as I have upgraded from 2008, to 2012 then 2014. Here are the list of variables

C:Program FilesMicrosoft SQL Server100ToolsBinn;
C:Program FilesMicrosoft SQL Server110ToolsBinn;
C:Program FilesMicrosoft SQL Server120DTSBinn;
C:Program Files (x86)Microsoft SQL Server120DTSBinn;

[Code] ....

Can I delete all variables related to older versions safely without any issue.

View 13 Replies View Related

Setup And Upgrade :: Storage Performance In Virtual Environment

May 27, 2015

If you have your Data, Logs, System and TempDB all in VMDK's and those VMDK's are formatted to 64K and then reside on Clustered Storage that is formatted as 4K, which is then running through a SAN controller that is reading and writing in 2MB chunks, is there value in formatting the SQL drives as 64K?  Also, would it be better to format the Clustered Storage as 64K?  Is this a situation in which formatting the SQL drives as 64K is becoming a moot point?

View 2 Replies View Related

SQL 2012 :: Can SSIS And Database Engine Be Linked To SSAS

Feb 12, 2014

I have a server which has SQL Server 2012 SSAS.

My client wants SSIS and database engine to be installed to be mapped to this analysis services engine.

Is that possible?

View 3 Replies View Related

DB Engine :: Setup Backup Share Folder In Clustered Environment While Setting Up Logshipping?

Oct 25, 2015

I am trying to set up log shipping in a clustered server environment. I am pretty confused about the location of the shared folder to be created to put backup created by  log shipping job. Which drive should I use either local or clustered shared drive to store the backups in primary server and  to copy the same in secondary Server?

View 2 Replies View Related

Setup And Upgrade :: How To Add Additional Server Instance In Existing Clustered Environment

May 14, 2015

How can i add additional SQL server instance to existing clustered environment on SQL 2005.

View 7 Replies View Related

Written Plan For 6.5 > 7.0 Upgrade?

Oct 12, 1999

I'm wondering if anyone has a written project plan for upgrading a server to 7.0 from 6.5.
I'm looking to make this upgrade myself shortly. I would appreciate any dialog, or a written
working plan. Thanks,



Mark Blackburn o `"._ _ M onterey
mark@mbari.org o / _ |||;._/ ) B ay
Science at its Best! ~ _/@ @ /// ( ~ A quarium
(831) 775-1880 ( (`__, ,`| R esearch
http://www.mbari.org/ '.\_/ |\_.' I nstitute

Database Administrator
MBARI Personal Web Page: http://www.mbari.org/~mark/

View 1 Replies View Related

DB Engine :: Maintenance Plan Runs Twice When Its Scheduled To Run Once

Nov 10, 2015

I have one maintenance plan for full backup to run at midnight daily, but somehow it runs another one at 11:40PM which I don't have plan for it. I can see it happened twice by opening job history. They all use same maintenance plan.

The only difference, I can see is in the message, one is "The job succeeded. The job was invoked by Schedule 112(Daily Backup.subplan_1)", the one I did not expect has message "The job succeeded.

The job was invoked by user sa". How to find this job that invoked by user sa and delete it? Again I can only see one job for full backup , but I can see it happened twice from view job history.

View 18 Replies View Related

DB Engine :: Cannot Remove Key Lookup From Execution Plan

Jun 4, 2015

how to eliminate a key lookup from the execution plan

  SET TRANSACTION ISOLATION LEVEL READ COMMITTED    
    SET NOCOUNT ON  
    SELECT COUNT(ph.lid) AS Total  
    FROM   PLB ph  
    WHERE  ph.lPhysician = @Physician  
    AND  ph.BSF = CAST(0 AS bit)  
   
[code]....

View 6 Replies View Related

Reporting Services :: Implementing SSRS In A New Environment

Nov 12, 2015

I've been charged with architecting a new SSRS solution for our environment. We're mainly a .NET shop which works with an Oracle Database Server. Our developers want to start using SSRS for report creation and I'm not sure what is the best approach when it comes to this. Normally most of our environments have 3 separate servers, each one is DEV, QA and Prod. With SSRS however, i know that you can create multiple folders each with its own datasource connection, so i wonder if it would be better to just have one server were the developers develop their reports and then move them into a 'production' folder. (Any particular downsides to this approach?)

Also, are there considerations to be taken say, to tune Production SSRS vs a development SSRS or is that not really an issue? Besides that any other resources or tips for implementing SSRS for the first time, we're not going to do much with the actual databases to start we're just going to connect to our main Oracle database. 

View 2 Replies View Related

Configuring SSRS In A SaaS-kind Of Environment

Feb 14, 2008



Hi,

We are developing a windows application (Distributed via ClickOnce) and hosting the
SqlServer 2005 at our company. Now, we need to add reporting services to our application
and I've stumbled upon some problems.

First off, each customer has their own database on the same SqlServer instance. What
I would want, and need guidance for, is the following..

1. I want each customer to be able to use the Report Builder to login and access a
model only targeted against their database (maybe using some sort of sql user account?).

2. I want each customer to be able to login to Report Manager and save/edit their
own reports targeted solely for their database.


3. If possible, is there a way to script this for easy creation when we acquire a new customer.

4. If this is not at all possible, what other solutions are there out there?



Kind Regards,
Robert

View 2 Replies View Related

DB Engine :: Forcing INSERT / SELECT To Use A Parallel Plan

Jul 13, 2015

I’ve been looking at a bug in an application stored proc. This merely inserts 7 million rows from one table into another (empty) table.

INSERT 
dbo.TradeDataPrimary
(Id, SinaiTrade) 
SELECT 
ts.Id,
CAST(ts.XmlTrade
AS varbinary(MAX))
FROM dbo.TradePrimary ts

Both tables have a clustered index with the same key order (on the first column) but the query optimizer insisted on placing a SORT step in the query plan. This use a lot of tempdb which I wanted to avoid.

I discovered that the bug was a data type mismatch. Fixing the bug and/or dropping the clustered index from the target table before the insert resulted in the plan I expected, that is, with no sort.

I was hoping it would run faster but, unfortunately, as can be seen from the new plan below, a serial plan is used. This results in the insert taking nearly three times as long as the original.

I’ve been looking at Paul White’s article: [URL] ....
and Adam Machanic’s: [URL] ....

Both are excellent articles but neither approaches i.e. trace flag 8649 or make_parallel () give me a parallel plan. Am I missing a trick here? How I can force parallelism? I know there are no features that require a serial zone in the plan otherwise the plan with the sort would not be parallel..

This is SQL Server 2012 Enterprise 11.0.5522.0, 512 GB of RAM and 16 procs.

View 10 Replies View Related

Walk-through Of A Distributed SSRS Environment Installation/configuration?

Apr 30, 2008

I'm using Virtual PC on my WinXP PC, with two W2K3 environments runnings as Virtual PC guests. My goal is to use these virtual servers to emulate a distributed SSRS environment--prior to setting up a similar environment on physical servers.

One of the W2K3 guests is my database server; the other W2K3 guest is my report server. Just like with a physical SSRS environment, there are many choices that need to be made during the installation and configuration--any one of which, it seems, can prevent the environment from working properly.

Currently, I'm struggling with getting my virtual distributed SSRS environment to work. I could go into the details, but I figured I'd ask a basic question first: Is anyone aware of a book, magazine article, blog, etc. that goes through a distributed SSRS installation--listing the requirements, discussing the choices, considering the implications, etc.?

Off the top of my head, such a walk-through would ideally cover networking configuration issues (Virtual PC or otherwise), Active Directory considerations, Windows Firewall settings between the servers, SSRS-related service account selections, authentication between the servers, etc.

If no one has produced such a walk-through (!), I'd be happy to write one so that others don't have to deal with the same struggles I'm currently dealing with....but I'd need your help.

View 8 Replies View Related

Installing SSRS 2005 In Web Server And Cluster Environment.

Dec 8, 2006

Hi,

I am installing SSRS 2005 with the following scenario:

- Report Server and Report Manager will be installed on web server

- The repository databases (ReportServer and ReportServerTempDB) will be hosted in SQL2005 cluster server.

Both servers are running Win2003 SP1, SQL/SSRS 2005 SP1

When I try to browse the ReportServer virtual directory from IIS on the web server, the system keep asking username and password. After 3 times trials and it failed eventhough the username and password is correct.

The error message is:

HTTP Error 401.1 - Unauthorized: Access is denied due to invalid credentials.
Internet Information Services (IIS)

I've been searching on the web and found couple of articles talking about this issue. I've tried some of them like: http://support.microsoft.com/kb/887993 or even this one: http://groups.google.ca/group/microsoft.public.sqlserver.reportingsvcs/browse_frm/thread/991c9178ceab8f58/8f1a447aa60ad837?lnk=st&q=reporting+services+the+server+is+not+responding&rnum=3&hl=en#8f1a447aa60ad837

But this doesn't work.

I've checked both event viewer both web server and SQL server, but I can't see any information that tell me what had happened.

I also look at BOL, but doesn't help much.

Is there anyone can help me or point me to the right direction? Is there any guide document that explains step-by-step how to install SSRS in my scenario or similiar?

Many Thanks,

Usman Tjiudri

View 3 Replies View Related

Maintenance Plan Problem After MSSQL 2005 Upgrade

May 5, 2008

Hi,

I have recently upgrade from MS SQL 2000 to MS SQL 2005. The maintenance plan disappeared. Although the jobs are still around and running. What issues might arise from this? Thanks..

View 1 Replies View Related

DB Engine :: Cost Vs Time When Including Actual Query Plan In SSMS

Nov 11, 2015

I have two queries yielding the same result that I wanted to compare for performance. I did enter both queries in one Mangement Studio query window and execute them as one batch with the actual query plan included.Query 1 took 8.2 seconds to complete and the query plan said that the cost was 21% of the batchQuery 2 took 2.3 seconds to complete and the query plan said that the cost was 79% of the batch.The queries were run on my local development machine. I was the only user. No other programs were running at the time of this test. The results are repeatable.I understand that the query with the lowest cost is not necessarily the fastest query. On the other hand, the difference is quite big. The query that has approx. 80% of the cost takes 20% of the time and the other way around. I have two questions:

Is such a discrepancy normal?Can conclusions be drawn from the cost distribution? For instance, does the query that takes 8.2 seconds but only costs 21% scale better?

View 9 Replies View Related

DB Engine :: How To Add Execution Plan To Extended Events Results Also When Capturing Deadlock Event

Oct 24, 2015

We know we can use the event lock_deadlock and xml_deadlock_report to capture the deadlock info,  however I also want to capture the execution plans for all of the SPIDs in the deadlock graph,  how to output the execution plans to the extended events trace results either ? such as if there is an action for execution plan or workaround for it ?If there is no built in action for execution plan , may I know if we can add the customized info to the extended events results file also ? Such as when the deadlock related event happens , then we can run a query to get some info ,then added the info along with other info such as sql_text, dbname  etc  to the events trace results file either ? The reason is if we also know the execution plans when the deadlock happens, it is useful to turning the query based on the execution plans to reduce deadlock happening .

View 5 Replies View Related

Reporting Services :: Where To Install SSRS SharePoint Mode In A Multi-server Environment

Aug 17, 2015

I am setting up sharepoint and sql server integration environment. I am considering the following topology: PowerPivot for SharePoint 2013 and Reporting Services in SharePoint mode Two Server Deployment

[URL]

I am looking to follow the topology example by the letter, which involves installing PowerPivot for SharePoint (aka SSAS in SharePoint mode) in the same server as my SQL, and installing SSRS in SharePoint (SP) integrated mode in the same server as SharePoint.

I understand, however, that if I wanted to install SSRS in SP mode in the same server as SQL, I could but only if the server contains the SP Object Model.

My first question is, what would involve having the SP Object Model in the SQL Server?

Would only installing SP binaries be enough; or Do I need to do a minimal install of SP in the SQL server enough for it to joing the SP farm? And most importantly, what would be the licensing implications for SP in case I want proceed down this route and have SSRS in SharePoint mode installed in the same server as the SQL?

View 4 Replies View Related

MSSQL 2005 SP2 Upgrade Fails - DB Engine

Feb 20, 2007

Just downloaded and installed mssql 2005 sp2 on one of our servers

All components upgrade apart from the database engine. After the first upgrade i rebooted then tried to update the db engine again it failed for a second time.

Below is the error from mssql setup, any help would be nice!

Event Type: Error
Event Source: MsiInstaller
Event Category: None
Event ID: 1023
Date:  2/20/2007
Time:  12:08:11 AM
User:  DNETWORKdadmin
Computer: SGC
Description:
Product: Microsoft SQL Server 2005 - Update 'Service Pack 2 for SQL Server Database Services 2005 ENU (KB921896)' could not be installed. Error code 1603. Additional information is available in the log file C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixSQL9_Hotfix_KB921896_sqlrun_sql.msp.log.

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Data:
0000: 7b 45 42 37 36 42 32 31   {EB76B21
0008: 38 2d 38 46 43 35 2d 34   8-8FC5-4
0010: 31 44 46 2d 39 46 31 46   1DF-9F1F
0018: 2d 37 46 46 33 45 30 34   -7FF3E04
0020: 34 38 33 38 33 7d 20 7b   48383} {
0028: 30 34 41 44 42 33 46 44   04ADB3FD
0030: 2d 42 32 38 36 2d 34 39   -B286-49
0038: 41 46 2d 38 35 34 45 2d   AF-854E-
0040: 45 44 44 33 38 42 36 44   EDD38B6D
0048: 45 36 44 37 7d 20 31 36   E6D7} 16
0050: 30 33                     03     


MSSQL Setup log http://www.dwebs.ltd.uk/mssqlinstall.txt
Its a rather large file!

View 6 Replies View Related

DB Engine :: Deleting 1 Million Records From Transaction Table Of 10 Million Data On 24/7 Environment

Jun 12, 2015

I have a requirement to delete 1 Million records from a table having 10 Million data and it's being queried on 24/7 basis (don't have a downtime). how can I achieve that?

View 13 Replies View Related

Database Mail And MS Exchange

Oct 30, 2007



I have set up database mail in SQL 2005. We have an MS Exchange group that is alerted when SQL jobs fail.
Two things ;
i) I can't seem to be able to use Exchange mail Groups. If I specify the group name SQL returns ;

The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 1 (2007-10-30T15:40:39). Exception Message: Cannot send mails to mail server. (The specified string is not in the form required for an e-mail address.).
If Exchange cannot be used in the way that Outlook did then how can we alert a group of users about SQL job failures ?

Therefore I tried specifiying an indiviual email address rather than a group ;

- sending a test message (right click database mail) using the full single email address works fine.
- sp_send_dbmail using the full single email address is also fine.

ii) When a job fails the notifications do not seem to work. The Job history log just reports ;
NOTE: Failed to notify 'Operator Name ' via email.
The SQL Error log reports ;
Message
[264] An attempt was made to send an email when no email session has been established

However sysmail_help_status_sp indicates that database mail has started.
The job fails to notify the operator and in this case it is a single email address.


Anybody got any suggestions, (thanks in advance) ?

View 7 Replies View Related

Upgrade 2K To 2005 Db Engine Fails On Vista From Cmd Prompt

Feb 1, 2008

I need some help please. I've got SQL 2K (default instance) and SQL 2005 Express installed on Vista Ultimate. I want to upgrade the 2K instance to 2005 Developer. I ran this from the command prompt:

D:ENGLISHSQL2005DEVELOPERSQL Server x86Servers>setup.exe ADDLOCAL=All SKUUP
GRADE=1 UPGRADE=SQL_Engine INSTANCENAME=MSSQLSERVER

This is the error message I received (from Summary):


--------------------------------------------------------------------------------
Machine : HPMEDIACENTER
Product : SQL Server Database Services
Error : SQL Server Setup cannot upgrade the instance because the uninstall file is missing or corrupted. The error code is (87) The parameter is incorrect.
--------------------------------------------------------------------------------
Machine : HPMEDIACENTER
Product : Microsoft SQL Server 2005
Product Version : 9.00.1399.06
Install : Failed
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0003_HPMEDIACENTER_SQL.log
Last Action : ValidateUpgrade
Error String : SQL Server Setup cannot upgrade the instance because the uninstall file is missing or corrupted. The error code is (87) The parameter is incorrect.
Error Number : 29523
--------------------------------------------------------------------------------

From the Log:

Property(S): PrimaryVolumeSpaceRemaining = 0
Property(S): RSVirtualDirectoryManager = Reports
Property(S): RSVirtualDirectoryServer = ReportServer
Property(S): SqlActionManaged = 3
Property(S): SqlStateManaged = 2
Property(S): Sql_sqlSqlUpgradeSequence = 714057000
MSI (s) (14:5C) [22:19:35:714]: Product: Microsoft SQL Server 2005 - Update 'Hotfix 3024 for SQL Server Database Services 2005 ENU (KB000000)' could not be installed. Error code 1603. Additional information is available in the log file C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0003_HPMEDIACENTER_SQL.log.
MSI (s) (14:5C) [22:19:35:718]: Windows Installer installed an update. Product Name: Microsoft SQL Server 2005. Product Version: 9.00.1399.06. Product Language: 1033. Update Name: Hotfix 3024 for SQL Server Database Services 2005 ENU (KB000000). Installation success or error status: 1603.
MSI (s) (14:5C) [22:19:35:719]: Note: 1: 1708
MSI (s) (14:5C) [22:19:35:719]: Product: Microsoft SQL Server 2005 -- Installation failed.
MSI (s) (14:5C) [22:19:35:719]: Windows Installer installed the product. Product Name: Microsoft SQL Server 2005. Product Version: 9.00.1399.06. Product Language: 1033. Installation success or error status: 1603.
MSI (s) (14:5C) [22:19:35:720]: Attempting to delete file C:WindowsInstaller1dcfcb3.msp
MSI (s) (14:5C) [22:19:35:720]: Unable to delete the file. LastError = 32
MSI (s) (14:5C) [22:19:35:733]: Cleaning up uninstalled install packages, if any exist
MSI (s) (14:5C) [22:19:35:733]: Attempting to delete file C:WindowsInstaller1dcfcb3.msp


I can't locate anything more about Hotfix 3024...maybe it's in Area 51. Or Studio 54. Or Blink 182...

Should I attach the logs? TIA
John

View 5 Replies View Related

Quick SSIS Expression Builder Question

Jul 26, 2007

This works:
len ((DT_WSTR,2)DATEPART("mm", getdate()))==1 ? (DT_WSTR,1)0 + (DT_WSTR,1)DATEPART("mm", getdate()) : (DT_WSTR,4)DATEPART("mm", getdate())

This doesn't:
"dataware/"+ len ((DT_WSTR,2)DATEPART("mm", getdate()))==1 ? (DT_WSTR,1)0 + (DT_WSTR,1)DATEPART("mm", getdate()) : (DT_WSTR,4)DATEPART("mm", getdate())

I tried a couple of different things at this point, where am I missing the cast? Before len? Cast to what?

View 4 Replies View Related

Alternative To DTC? - SSIS Transactions - Quick Question

Jan 5, 2007

Hi:

I would like to have my SSIS tasks to be transacted, but due to infrastructure issues in our network, cannot utilize DTC, because our SQL Boxes are situated where the DTC cannot communicate. Are any other alternatives? Is it a feasible alternative? Please let me know. Thanks.

View 1 Replies View Related

Exchange Of Login For Database User

Aug 24, 2005

I have a database with 2 users - 'dbo' and 'user1'.Currently:=> 'dbo' is tied to login - 'login1'=> 'user1' is not tied to any login.I want to change the login tied to the database users to:=> 'dbo' tied to no login=> 'user1' tied to 'login1'I try to use:sp_change_users_login 'Update_One', 'user1', 'login1'But it give me an error said 'login1' is already tied to a user.Then I try to remove the login tied to 'dbo' with this:sp_change_users_login 'Update_One', 'dbo', ''Then I get another error said that 'dbo' is a forbidden value for thelogin name parameter.------Previously, all the while 'dbo' is not tied to any login and 'user1' istied to 'login1', but yesterday I restore the DB from the backup filebring back from customer side, then I saw the login changed to the oneI mention above, I'm not sure whether is the DBA from customer sidechange it or what, but is there any way for me to change the login backto the state I want?Thanks.Peter CCH

View 11 Replies View Related

DB Engine :: Upgrade Two Nodes Utilizing AlwaysOn Of Some Other Method Without Downtime?

Oct 15, 2015

Two servers are configured with Windows 2008 / SQL server 2012 utililizing Always-On for HA. We need to upgrade both servers to Windows 2012 / SQL Server 2014 with minimum downtime(Time for Always-On failover). The upgrade to SQL 2014 is straight forward with for minimum downtime.The Windows upgrade(2008 -> 2012) is the problem. From what I have observed and read in blogs.The Windows node to be upgraded must be removed from the Windows cluster before the node can be upgraded to Win 2012.A Win 2008 and Win 2012 node can not reside in the same cluster. If this is true then the only option I can think of is to dump the DB on WIN 2008 server and restore on Win 2012. This is an outage(time it takes to dump and restore).Is there any other method to upgrade these two nodes utilizing Always-On of some other method without downtime?

View 2 Replies View Related

Quick Question - Need Some Advice On Troubleshooting SSIS Errors

Apr 3, 2007



Hi Everyone:



I have a SSIS Package which in brief moves data from one SQL data store to another. On my local machine, the package executes fines, and does what it is supposed to do, by moving data from Point A to Point B. I have both Point A(DB) and Point B(DB) on my local machine. But when I deploy this package over to ASSEMBLY which is basically another environment, I get weird intermittent errors. What should I do? Can someone give me some tips on how to do good error logging in SSIS? I am currently writing to Windows Event Log, and I seem to look at some errors that are coming thru. What else can I do on SSIS Package side, to improve error reporting and handling, so troubleshooting is faster and more effective. I just need some stable advice on how to setup my package to do error logging where troubleshooting issues in different environments is more effective. Also I need to know, what could be causing these issues? Thanks.



MA

View 8 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved