touchwithme2 (11/18/2009)
Hi,It was quite good to follow...i have query on this, whether we can move the temp db in production server on business hours.
Plz update on this ....
Waiting for your reply.
Thanks and Regards
Eswari.S
No, you cannot move the tempdb (or any database files) without an outage. For normal databases, moving the files just requires that database to be offline. For system databases, moving the files requires a restart (at a minimum) of SQL Server.
For tempdb, you can make the changes to the system tables at any time - then at the next restart of SQL Server the files will be created in the new location. Be aware that if you make a mistake on the path for tempdb (e.g. typo in the directory name) - SQL Server will not start and you will have to start SQL Server in single-user mode to fix.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs