April 19, 2013 at 4:46 pm
Other considerations besides just moving the files (code should be fine that you provided)
Consider the size of the files
Consider more files than just the default 1 data file
Consider the growth settings for the files
Monitor for activity and adjust as necessary if contention in tempdb arises.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
April 19, 2013 at 5:03 pm
ensure the sql service account has full control permissions on the E:\sqldata directory.
You will need to restart the instance for the change to take effect.
Delete the old files after successful move.
You cannot backup tempdb so not sure what you mean by that.
---------------------------------------------------------------------
April 23, 2013 at 8:22 am
Thanks for sharing your experiences,
I will try to apply it.
Viewing 3 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply