hotfixes, mssqlsystemresource.ldf

I've just discovered that applying a hotfix to SQL2005 can fail if you
have moved the 'mssqlsystemresource.ldf' logfile to a different
subirectory from the MDF.
It is well documented that the mssqlsystemresource.mdf must be in the
same location as master.mdf, but I haven't seen anything about keeping
the ldf with the mdf (our practice is to run with LDF files on a
different set of spindles from the MDF files).
If you have this setup and haven't done a service pack, you can readily
fix it by moving the LDF from the MDF folder and putting it where it
'belongs' according to the master catalog.
However, you're better off leaving both the LDF and MDF together with
master.mdf.> However, you're better off leaving both the LDF and MDF together with
> master.mdf.
Yes, this is the Best Practice. Unfortunately, it's easy to forget about
those mssqlsystemresource files.
Hope this helps.
Dan Guzman
SQL Server MVP
"horseradish" <millardjk@.gmail.com> wrote in message
news:OWUWEgDuHHA.4412@.TK2MSFTNGP02.phx.gbl...
> I've just discovered that applying a hotfix to SQL2005 can fail if you
> have moved the 'mssqlsystemresource.ldf' logfile to a different
> subirectory from the MDF.
> It is well documented that the mssqlsystemresource.mdf must be in the same
> location as master.mdf, but I haven't seen anything about keeping the ldf
> with the mdf (our practice is to run with LDF files on a different set of
> spindles from the MDF files).
> If you have this setup and haven't done a service pack, you can readily
> fix it by moving the LDF from the MDF folder and putting it where it
> 'belongs' according to the master catalog.
> However, you're better off leaving both the LDF and MDF together with
> master.mdf.

hotfixes, mssqlsystemresource.ldf

I've just discovered that applying a hotfix to SQL2005 can fail if you
have moved the 'mssqlsystemresource.ldf' logfile to a different
subirectory from the MDF.
It is well documented that the mssqlsystemresource.mdf must be in the
same location as master.mdf, but I haven't seen anything about keeping
the ldf with the mdf (our practice is to run with LDF files on a
different set of spindles from the MDF files).
If you have this setup and haven't done a service pack, you can readily
fix it by moving the LDF from the MDF folder and putting it where it
'belongs' according to the master catalog.
However, you're better off leaving both the LDF and MDF together with
master.mdf.
> However, you're better off leaving both the LDF and MDF together with
> master.mdf.
Yes, this is the Best Practice. Unfortunately, it's easy to forget about
those mssqlsystemresource files.
Hope this helps.
Dan Guzman
SQL Server MVP
"horseradish" <millardjk@.gmail.com> wrote in message
news:OWUWEgDuHHA.4412@.TK2MSFTNGP02.phx.gbl...
> I've just discovered that applying a hotfix to SQL2005 can fail if you
> have moved the 'mssqlsystemresource.ldf' logfile to a different
> subirectory from the MDF.
> It is well documented that the mssqlsystemresource.mdf must be in the same
> location as master.mdf, but I haven't seen anything about keeping the ldf
> with the mdf (our practice is to run with LDF files on a different set of
> spindles from the MDF files).
> If you have this setup and haven't done a service pack, you can readily
> fix it by moving the LDF from the MDF folder and putting it where it
> 'belongs' according to the master catalog.
> However, you're better off leaving both the LDF and MDF together with
> master.mdf.

hotfixes, mssqlsystemresource.ldf

I've just discovered that applying a hotfix to SQL2005 can fail if you
have moved the 'mssqlsystemresource.ldf' logfile to a different
subirectory from the MDF.
It is well documented that the mssqlsystemresource.mdf must be in the
same location as master.mdf, but I haven't seen anything about keeping
the ldf with the mdf (our practice is to run with LDF files on a
different set of spindles from the MDF files).
If you have this setup and haven't done a service pack, you can readily
fix it by moving the LDF from the MDF folder and putting it where it
'belongs' according to the master catalog.
However, you're better off leaving both the LDF and MDF together with
master.mdf.> However, you're better off leaving both the LDF and MDF together with
> master.mdf.
Yes, this is the Best Practice. Unfortunately, it's easy to forget about
those mssqlsystemresource files.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"horseradish" <millardjk@.gmail.com> wrote in message
news:OWUWEgDuHHA.4412@.TK2MSFTNGP02.phx.gbl...
> I've just discovered that applying a hotfix to SQL2005 can fail if you
> have moved the 'mssqlsystemresource.ldf' logfile to a different
> subirectory from the MDF.
> It is well documented that the mssqlsystemresource.mdf must be in the same
> location as master.mdf, but I haven't seen anything about keeping the ldf
> with the mdf (our practice is to run with LDF files on a different set of
> spindles from the MDF files).
> If you have this setup and haven't done a service pack, you can readily
> fix it by moving the LDF from the MDF folder and putting it where it
> 'belongs' according to the master catalog.
> However, you're better off leaving both the LDF and MDF together with
> master.mdf.

hot fixes

Are there any fixes that I need to apply after applying sp3 or sp3a or I
should wait for sp4.
yes . . .roll up hotfix 826161 to bring minor version to 818/819
"SB138" wrote:

> Are there any fixes that I need to apply after applying sp3 or sp3a or I
> should wait for sp4.
|||Definitely.
http://support.microsoft.com/?kbid=821277
http://www.aspfaq.com/
(Reverse address to reply.)
"SB138" <SB138@.discussions.microsoft.com> wrote in message
news:257396DF-80D6-4DFF-9F9B-76D8D7D4A275@.microsoft.com...
> Are there any fixes that I need to apply after applying sp3 or sp3a or I
> should wait for sp4.
|||and u can sign up for sp4 beta if intrested :
http://support.microsoft.com/kb/290211
Andy.
"SB138" <SB138@.discussions.microsoft.com> wrote in message
news:257396DF-80D6-4DFF-9F9B-76D8D7D4A275@.microsoft.com...
> Are there any fixes that I need to apply after applying sp3 or sp3a or I
> should wait for sp4.

hot fixes

Are there any fixes that I need to apply after applying sp3 or sp3a or I
should wait for sp4.yes . . .roll up hotfix 826161 to bring minor version to 818/819
"SB138" wrote:

> Are there any fixes that I need to apply after applying sp3 or sp3a or I
> should wait for sp4.|||Definitely.
http://support.microsoft.com/?kbid=821277
http://www.aspfaq.com/
(Reverse address to reply.)
"SB138" <SB138@.discussions.microsoft.com> wrote in message
news:257396DF-80D6-4DFF-9F9B-76D8D7D4A275@.microsoft.com...
> Are there any fixes that I need to apply after applying sp3 or sp3a or I
> should wait for sp4.|||and u can sign up for sp4 beta if intrested :
http://support.microsoft.com/kb/290211
Andy.
"SB138" <SB138@.discussions.microsoft.com> wrote in message
news:257396DF-80D6-4DFF-9F9B-76D8D7D4A275@.microsoft.com...
> Are there any fixes that I need to apply after applying sp3 or sp3a or I
> should wait for sp4.

hot fixes

Are there any fixes that I need to apply after applying sp3 or sp3a or I
should wait for sp4.yes . . .roll up hotfix 826161 to bring minor version to 818/819
"SB138" wrote:
> Are there any fixes that I need to apply after applying sp3 or sp3a or I
> should wait for sp4.|||Definitely.
http://support.microsoft.com/?kbid=821277
--
http://www.aspfaq.com/
(Reverse address to reply.)
"SB138" <SB138@.discussions.microsoft.com> wrote in message
news:257396DF-80D6-4DFF-9F9B-76D8D7D4A275@.microsoft.com...
> Are there any fixes that I need to apply after applying sp3 or sp3a or I
> should wait for sp4.|||and u can sign up for sp4 beta if intrested :
http://support.microsoft.com/kb/290211
Andy.
"SB138" <SB138@.discussions.microsoft.com> wrote in message
news:257396DF-80D6-4DFF-9F9B-76D8D7D4A275@.microsoft.com...
> Are there any fixes that I need to apply after applying sp3 or sp3a or I
> should wait for sp4.