On CBS.com: Six show girls attacked

Moving the Tempdb and Master Database in SQL Server 2000

Tags: the hot button, steven s. warren, sql server, sql, screenshots

  • Save
  • 0
There have been many occasions where I found it necessary to move the database and log files to different drives to increase performance. When you want to move a typical user database to a different drive for performance or to split out the logs, you run sp_detach and sp_attach to perform the move. However, when it comes to moving the Master and Tempdb database, different rules apply.
         

What do you think?

See more TR Photo Galleries TR Gallery Newsletter signup

The PC Cracked Open

advertisement
Click Here