Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
cwalston
Starting Member
25 Posts |
 Posted - 2009-01-13 : 12:29:37
|
| Either I am crazy or this is very strange. I have a 2005 server that needs a rather large tempdb (both data and log) due to the apps running (poorly written code IMHO). During a maintenance window, I added files and synced up their sizes so that everything is neat and inline. Then to make sure all is clean, I bounced the instance. When it came backup, all my added files were gone! In the db properties in the gui it listed all the files, but did not adjust the sizes in the overall tempdb size. In sp_helpdb, it did not even recognize the new files. Anyone ever seen this behavior? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
cwalston
Starting Member
25 Posts |
Posted - 2009-01-13 : 13:04:51
|
| I appreciate the script...but any idea why I would be getting this behavior? In looking at your script, you eventially execute an Alter database command, which is what I did. What would the difference be?Thanks again for your reply. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Tempdb files disappearing??