December 20, 2010 at 3:33 am
Dear All,
Can some one advise how to add mdf files to tempdb with equally sized?
Thanks and Regards,
Ravichandra.
December 20, 2010 at 4:08 am
Look up ALTER DATABASE. It's done the same as for any user databases.
p.s. typically secondary data files have the .ndf extension, not .mdf. That's just convention though.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 20, 2010 at 1:20 pm
As Gail already mentioned, you need to use ALTER DATABASE Command.
Check if this helps..
http://adventuresinsql.com/2010/04/script-to-create-a-tempdb-file-per-processor/
Just comment out -- EXEC sp_executesql @alter_command
http://www.sqlskills.com/BLOGS/PAUL/category/Misconceptions.aspx#p22
Just make sure that the Autogrowth, maxsize and the size are same for all the files.
SQL Server needs to be restarted for the changes to take affect.
Always test before you trust.
Thank You,
Best Regards,
SQLBuddy
December 20, 2010 at 2:32 pm
sqlbuddy123 (12/20/2010)
SQL Server needs to be restarted for the changes to take affect.
Only if you are moving the files is a restart necessary. If you are only adding additional files, those will be added immediately.
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
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply