Re: SQL Server SP3 vs SP4 questions



The reverse works.

SQL with SP4 applied, SPS front-end web server with SQL client tools at SP3,
mainly because I forgot to apply SP4 to the SPS FE server until last week!!!

Backups worked OK, didn't need to restore, but it ought to work as
SPSbackup.exe uses are a couple of dll's installed with the client tools...
Performing an SQL backup to a server with SP4, using client tools at SP3,
works fine...

--


MattG
MCP (Windows XP)
MCP (Windows Server 2003)
070-291 this Weds...


<davidg@xxxxxxxxxxxx> wrote in message
news:1127167558.869826.177570@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> 1) When upgrading to SP4, does both the SPS box and the SQL box need to
> be upgraded? If not, can the SQL box run SP3 and the SPS box run the
> SP4 client tools?
>
> 2) Can a portal that is running on a box with SP4 client tools, restore
> from a backup that was generated on a SQL Server running SP3?
>
> My hunch is that the above scenarios will cause major grief, given the
> past history of SharePoint. Has anyone attempted the above
> descriptions?
>
> David Goebel
>


.



Relevant Pages

  • Re: Full Text Repair
    ... Emil Caruthers ... > Since your customer has already applied SP4, I'm assuming that this is a SQL ... > For SQL Server 7.0 installations, there is a registry key and value that you ...
    (microsoft.public.sqlserver.fulltext)
  • Re: Full Text Repair
    ... Since your customer has already applied SP4, I'm assuming that this is a SQL ... For SQL Server 7.0 installations, there is a registry key and value that you ... It will contain your hotfix build version number such that 7.00.xxx is the ...
    (microsoft.public.sqlserver.fulltext)
  • Re: Unable to Apply SP4 to SQL 2000 Cluster (new Node)
    ... Scenario 1" in SQL Server 2000 Books Online. ... Run Database Components SP4 Setup on the node you have ... DBC01 (SQL Instance 1) ...
    (microsoft.public.sqlserver.clustering)
  • Re: Unable to run SQL Query Analyzer ......
    ... SP4 to both the default instance and SharePoint instance, ... I have a SBS2003 Premium Edition with SQL 2000 installed. ... MSSQL$SHAREPOINT, and Active Server Pages: ...
    (microsoft.public.windows.server.sbs)
  • Re: Cannot connect to the configuration database
    ... With the SQL client tools installed I am still unable to connect to the ... > the next issue occured with the assistance of SQL server client tools. ...
    (microsoft.public.sharepoint.windowsservices)