I'm using Sybase 12.5 on Solaris Sparc. Everytime I restart my server
some of the user logins lose permissions to some (But not all)
databases including tempdb. Why would this be?
My dba tells me tempdb is created from the model database after a
reboot. But is happens to non tempdb databases.
Any reasons why this would be?
Recently the server was rebuilt from 2K to 8K pages. The only thing I
can think of is the something got screwed up in the process?
What could it be?
Seems like every sucessive reboot, more and more databases are
affected.
Re: tempdb mdf and ldf placement ... > or LDF files from user or system databases.... > the tempdb MDF and LDF to separate hard drives or can they ... If it has a LOT of activity, then a RAID 0 might be your best choice. ... (microsoft.public.sqlserver.server)
Re: Migrating to new hardward ...Moving SQL Server databases to a new location with Detach/Attach ... There is a specific section on moving tempdb.... recreating the clustered index and specifying a filegroup for the new table. ... (microsoft.public.sqlserver.setup)
Re: Moving tempdb ... there are two databases on the server that are being used. ... I also have another server running a database about 16GB in size. ... I'm planning on moving our tempdb to it's own LUN but I'm not sure what ... (microsoft.public.sqlserver.setup)
Re: Checkpointing Not Happening in Simple Recovery Model ... I am looking at databases set to simple: ... > Columnist, SQL Server Professional... >> She says that she has simple recovery and that one of them is tempdb.... >> Yes, you are right, I read that Michelle is writing about logs not log, ... (microsoft.public.sqlserver.server)
Re: Master Database Collation issue ... > The question is how do I change master, tempdb, model etc from their existing ... but note that it will scratch your system databases.... > Later a third part application was added that created a database with this collation:... (microsoft.public.sqlserver.server)
