Moving master txn log files

I was able to move the master data/log tables, but one I issue the alter
statement on the systemresource tables I get the following error:
Msg 911, Level 16, State 1, Line 1
Could not locate entry in sysdatabases for database 'mssqlsystemresource'.
No entry found with that name. Make sure that the name is entered correctly.
This is the SQL that I ran:
ALTER DATABASE mssqlsystemresource
MODIFY FILE (NAME=data, FILENAME= 'D:\Microsoft SQL
Server\MSSQL.1\MSSQL\Data\mssqlsystemresource.mdf' );
GO
ALTER DATABASE mssqlsystemresource
MODIFY FILE (NAME=log, FILENAME= 'D:\Microsoft SQL
Server\MSSQL.1\MSSQL\Data\mssqlsystemresource.ldf' );
GO
"Gail Erickson [MS]" wrote:

> Hi Michael,
> The answer to your question is yes, you can move the master log file
> wherever you like, however, the Resource data and log files must remain
> together and must be in the same directory as the master data file (.mdf). I
> apologize for the lack of clarify in the topic. We'll get that topic
> corrected. Unforunately, it's too late to get it fixed for the next BOL
> update coming out late next week, but it will be in the subsequent update.
> --
> Gail Erickson [MS]
> SQL Server Documentation Team
> This posting is provided "AS IS" with no warranties, and confers no rights
> Download the latest version of Books Online from
> http://technet.microsoft.com/en-us/sqlserver/bb428874.aspx
> "Gail Erickson [MS]" <gaile@.online.microsoft.com> wrote in message
> news:%23hWQQNB8HHA.5404@.TK2MSFTNGP02.phx.gbl...
>
>
I was able to reproduce your error only when I started the MSQLSERVER
service this way: NET START MSSQLSERVER /T3608
When I used the /f parameter indicated in the instructions, I had no
problems. You might try stopping the service again and reissuing the net
start using
both the /f and /T3608 parameters to see if that fixes it.
Gail Erickson [MS]
SQL Server Documentation Team
This posting is provided "AS IS" with no warranties, and confers no rights
Download the latest version of Books Online from
http://technet.microsoft.com/en-us/sqlserver/bb428874.aspx
"Scott" <Scott@.discussions.microsoft.com> wrote in message
news:00355600-0AA9-4699-B674-9AF49360FECB@.microsoft.com...[vbcol=seagreen]
>I was able to move the master data/log tables, but one I issue the alter
> statement on the systemresource tables I get the following error:
> Msg 911, Level 16, State 1, Line 1
> Could not locate entry in sysdatabases for database 'mssqlsystemresource'.
> No entry found with that name. Make sure that the name is entered
> correctly.
> This is the SQL that I ran:
> ALTER DATABASE mssqlsystemresource
> MODIFY FILE (NAME=data, FILENAME= 'D:\Microsoft SQL
> Server\MSSQL.1\MSSQL\Data\mssqlsystemresource.mdf' );
> GO
> ALTER DATABASE mssqlsystemresource
> MODIFY FILE (NAME=log, FILENAME= 'D:\Microsoft SQL
> Server\MSSQL.1\MSSQL\Data\mssqlsystemresource.ldf' );
> GO
>
> "Gail Erickson [MS]" wrote:
|||Gail,
You're a popular person...THANK YOU!
I was able to rectify this problem by following your steps in the following
thread:
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=126761&SiteID=1
THANK YOU SO MUCH!
"Gail Erickson [MS]" wrote:

> I was able to reproduce your error only when I started the MSQLSERVER
> service this way: NET START MSSQLSERVER /T3608
> When I used the /f parameter indicated in the instructions, I had no
> problems. You might try stopping the service again and reissuing the net
> start using
> both the /f and /T3608 parameters to see if that fixes it.
>
> --
> Gail Erickson [MS]
> SQL Server Documentation Team
> This posting is provided "AS IS" with no warranties, and confers no rights
> Download the latest version of Books Online from
> http://technet.microsoft.com/en-us/sqlserver/bb428874.aspx
> "Scott" <Scott@.discussions.microsoft.com> wrote in message
> news:00355600-0AA9-4699-B674-9AF49360FECB@.microsoft.com...
>
>
|||You're welcome. I'm glad you found that post. I had forgotten about it.
I've created a documentation bug to get a troubleshooting topic written to
cover the material in that post.
Gail Erickson [MS]
SQL Server Documentation Team
This posting is provided "AS IS" with no warranties, and confers no rights
Download the latest version of Books Online from
http://technet.microsoft.com/en-us/sqlserver/bb428874.aspx
"Scott" <Scott@.discussions.microsoft.com> wrote in message
news:5DDE5713-942A-425D-A033-CCCE08599B71@.microsoft.com...[vbcol=seagreen]
> Gail,
> You're a popular person...THANK YOU!
> I was able to rectify this problem by following your steps in the
> following
> thread:
> http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=126761&SiteID=1
> THANK YOU SO MUCH!
> "Gail Erickson [MS]" wrote: