|
Home > Archive > microsoft.public.sqlserver.server > August 2002 > sp4 installation help
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
sp4 installation help
|
|
| herbert 2002-08-15, 8:23 am |
| hi folks,
sorry this quite stupid question..
installing sql sp4 to sql 7 gold.
tree databases (web_board, web_board_dev, carparts)
sp4 readme says:
"SP4 Setup does not upgrade user databases except for
those user databases that are actively involved in
replication topologies. Databases that are not involved in
replication topologies do not have dependencies on SP4."
does this mean that my databases arent upgraded at all,
and i have to do something to bring them alive after
update ?
i dont have second server nor sql server.
these exaples was in sp4 readme:
"You can restore a user database backup from an instance
of SQL Server 7.0 or SQL Server 7.0 SP1, SP2, or SP3 to an
instance of SQL Server 7.0 SP4.
You can restore a user database backup from an instance of
SQL Server 7.0 SP4 to an instance of SQL Server 7.0 or SQL
Server 7.0 SP1, SP2, or SP3.
You can detach a user database from an instance of SQL
Server 7.0 or SQL Server 7.0 SP1, SP2, or SP3 and attach
it to an instance of SQL Server 7.0 SP4.
You can detach a user database from an instance of SQL
Server 7.0 SP4 and attach it to an instance of SQL Server
7.0 or SQL Server 7.0 SP1, SP2, or SP3. "
so, does this mean that i have to:
1) make backup from all tree databases to hd/tape
2) restore those db's from backups after install sql sp4
ps what means detach/attach in plain english ?
herbert
| |
| Tibor Karaszi 2002-08-15, 8:23 am |
| I guess it means that installation of sp4 doesn't "touch" non-replication databases. There's
nothing to do.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=...ublic.sqlserver
"herbert" <newbie@wannabe.org> wrote in message
news:2a7501c2445d$ed5604c0$b1e
62ecf@tkmsftngxa04...
> hi folks,
> sorry this quite stupid question..
>
> installing sql sp4 to sql 7 gold.
> tree databases (web_board, web_board_dev, carparts)
>
> sp4 readme says:
> "SP4 Setup does not upgrade user databases except for
> those user databases that are actively involved in
> replication topologies. Databases that are not involved in
> replication topologies do not have dependencies on SP4."
>
> does this mean that my databases arent upgraded at all,
> and i have to do something to bring them alive after
> update ?
>
> i dont have second server nor sql server.
>
> these exaples was in sp4 readme:
> "You can restore a user database backup from an instance
> of SQL Server 7.0 or SQL Server 7.0 SP1, SP2, or SP3 to an
> instance of SQL Server 7.0 SP4.
>
> You can restore a user database backup from an instance of
> SQL Server 7.0 SP4 to an instance of SQL Server 7.0 or SQL
> Server 7.0 SP1, SP2, or SP3.
>
> You can detach a user database from an instance of SQL
> Server 7.0 or SQL Server 7.0 SP1, SP2, or SP3 and attach
> it to an instance of SQL Server 7.0 SP4.
>
> You can detach a user database from an instance of SQL
> Server 7.0 SP4 and attach it to an instance of SQL Server
> 7.0 or SQL Server 7.0 SP1, SP2, or SP3. "
>
> so, does this mean that i have to:
> 1) make backup from all tree databases to hd/tape
> 2) restore those db's from backups after install sql sp4
>
> ps what means detach/attach in plain english ?
>
> herbert
|
|
|
|
|