Drop Table

Support Forum for database administrators and web based access to important newsgroups related to databases

For Database admins: Free Database-related Magazines Now Free shipping to Texas

Database Topics > MS SQL Database Server > MS SQL Server >

RE: Tempdb

Thread

Author

RE: Tempdb

These may help:

http://www.sql-server-performance.com/tempdb.asp

http://msdn2.microsoft.com/en-us/library/ms190768.aspx

http://support.microsoft.com/kb/224071


"mmc" wrote:

> I am trying to move tempdb to a separate logical drive in a SAN. What are 
the
> best methodologies? Should the DB be in Single mode? offline? What are
> potential issues if I move it?