June 11, 2007 at 12:46 pm
Hello,
My question has to do with moving the Temp databases transaction log file to another drive. I have moved the transaction log before with non-system dtabases and I was wondering if the steps for the Temp database were the same ?
Here's what I've done before with non-system database :
1.) Detach database
2.) OS level - copy transaction log to desired location
3.) Re-attach database with transaction log in new location.
I have never tried to detach the Temp database before and I was wondering if that was possible and if any special steps were required ? I don't want to just add another transaction log for the Temp database, I want to completely move it to new locale.
Please share your thoughts.
Thanks in advance.
Don
June 11, 2007 at 12:59 pm
This may be what you are looking for ...
http://www.databasejournal.com/features/mssql/article.php/3379901
June 11, 2007 at 1:48 pm
Look in Books Online under "Moving System Databases"
June 12, 2007 at 11:56 pm
This is good documentation of your question. Answer to your question.
Pinal Dave
sqlauthority.com
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply