Re: Updating a SQL-server automatically (version 2005)

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Thanks Ekrem !

How can I "set up" such a test enviroment ?

/KSor

"Ekrem Önsoy" <ekrem@xxxxxxxxxxxx> skrev i meddelelsen news:224037E2-9BC9-48DA-A8F5-2407042762D5@xxxxxxxxxxxxxxxx
The recommended way is to apply the updates to a similiar SQL Server instance in a test environment prior updating your production SQL Server instance.

After ensuring you don't face problems with the updated version in your test environment, then you can apply the updates to your production SQL Server instance.

Automatic updating is not recommended not only because of this but also updating could cause a restart of the computer or SQL Server services and this could cause unexpected interruptions that you would not want to experience. It's better to perform this action manually and take the control of the server yourself.

--
Ekrem Önsoy



"KS soerensen@xxxxx>" <keld.<SLET_DETTE> wrote in message news:C1B2EC55-AA66-42FA-AD0E-AD165ECD05F8@xxxxxxxxxxxxxxxx
Would you dare to make this updating automatic ?

I just got a new job and can see that the server has not been updated for a long time.

Best regards
KSor, Denmark



.

Relevant Pages

  • RE: Error installing (KB 921896)
    ... instance MSSMLBIZ ... to SQL Server. ... correct or check to see if the SQL Server Instance is set to Mixed ... the SQL Server Instance is set to Mixed Authentication ...
    (microsoft.public.windowsupdate)
  • Re: SQL 200 Dev edition on workgroup will not connect
    ... I have been using sql server for about 8 years but mainly working with sql 2000. ... know your experience level with SQL Server and yes, sometimes things being messy but letting a SQL Server instance to accept remote connections and uninstalling it are generally straightforward tasks to perform. ... I suggest you to check for the dynamic port number that your SQL Server graps. ... Write down the port number in the "TCP Dynamic Ports" property and then run a Command Prompt and see if this port is bening listened. ...
    (microsoft.public.sqlserver.connect)
  • Re: Display data from ODBC table
    ... Have you tested updating the data in the DatasheetView of the Query? ... If you can in the above, you might have set the Recordset Type of the Form ... If you can't update in the DatasheetView then the problem is in the Query. ... Check your permissions on the SQL Server. ...
    (microsoft.public.access.forms)
  • Re: Installing Sql Server Express on Vista Home Premium
    ... What comes to my mind is that there is a Default SQL Server instance is installed on that working system and your application connects to that instance. ... This connection string should work as you do not force the connection to use a specific protocol, Shared Memory will be used as this is the primary protocol by default. ... Default Instances uses 1433 TCP port by default as a Static Port but not the ...
    (microsoft.public.sqlserver.setup)
  • Re: SQL Server 2005 and security patch issues?
    ... I guess the problem occurs while you are trying to log in to your SQL Server instance, if so, do you get any error message? ... I recreated a fresh instance and a fresh copy of the ...
    (microsoft.public.sqlserver.security)