Re: system databases

Hi Soc,

Look into the below site for moving system databases.In your case move only
the transaction log files.

http://support.microsoft.com/default.aspx?scid=kb;EN-US;224071

Is it true that the system databases require the guest account?

Do not remove Guest user from Master and Tempdb databases; But u could
remove Guest from other databases.

http://support.microsoft.com/kb/315523/EN-US/

But you can can make the "guest" account unavailable for databases. So that
Guest users can not login to user databases.

Thanks
Hari
SQL Server MVP


"soc" <zxc0@xxxxxxxxx> wrote in message
news:e%23TDaRfNFHA.1604@xxxxxxxxxxxxxxxxxxxxxxx
>I have installed sql server 2000,sp3a on a w2003 server. The server has a
>separate disk array for os,data, transaction files and backups.
>
> The installation has put the system database data and transaction files
> onto the data array. Should i move the transaction files onto the
> transaction array? If so how would I do this?
>
> Also, is it true that the system databases require the guest account? Why?
>
> Thanks Soc.
>


.

Relevant Pages

  • Re: system databases
    ... > Do not remove Guest user from Master and Tempdb databases; ... >>I have installed sql server 2000,sp3a on a w2003 server. ... >>separate disk array for os,data, transaction files and backups. ...
    (microsoft.public.sqlserver.setup)
  • Re: db_owner
    ... and user databases since I noticed this Microsoft article recommends not to remove the 'guest' account http://support.microsoft.com/default.aspx/kb/315523 ... The guest user inherits only minimal permissions from the public role so permissions are quite limited in master and tempdb. ... SQL Server MVP ... includes sample and system databases but permissions in the system databases are minimal. ...
    (microsoft.public.sqlserver.security)
  • Re: Session ending shutdown problem
    ... massively long shutdown time, you will have to rethink what it means to "shut down". ... and start routing everything to it instead of the databases. ... this process starts gets appended to the transaction file instead. ... Of course I can detect the QueryEndSession and EndSession messages. ...
    (microsoft.public.vc.mfc)
  • Re: How can I remove Public access to SQL Express dbs?
    ... Guest has no CONNECT permission in user databases by default. ... You can't delete guest but can render it unusable by revoking CONNECT permission in databases other than master and tempdb. ... it will remove the public access of the database in question. ...
    (microsoft.public.sqlserver.security)
  • Re: Why is database integrity so impopular ?
    ... When time comes to build transactional databases (as opposed to data ... normalizing data with high integrity mechanisms. ... What is wrong with modern DB design approaches? ... declarative model of some version of transaction interests me though ...
    (comp.databases.theory)