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 |
|
10Dawg
Starting Member
46 Posts |
 Posted - 2012-06-28 : 11:16:28
|
| I have 4 secondary databases taking up 20+ GB on my C: drive. I did not set this instance up and have never used secondary databases. I need that room. Is there any harm in deleting them? Do i have to detach them from somewhere first?10Dawg |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2012-06-28 : 11:43:58
|
| Do you mean secondary log shipping databases?Jack Vamvas--------------------http://www.sqlserver-dba.com |
 |
|
|
10Dawg
Starting Member
46 Posts |
Posted - 2012-06-28 : 12:56:02
|
| SQL Server Database Secondary Data File (.ndf) Since i posted this I read that is was done for the purpose splitting up the load on the system's Tempdb. They are TempDev2, 3 & 4. They are 5 GB a piece. Is there any harm in shinking these files back to 1GB? Will they just expand back out?10Dawg |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2012-07-02 : 11:44:05
|
| Consider segmenting out onto a diferent drive for performance gain - and general manageabilityJack Vamvas--------------------http://www.sqlserver-dba.com |
|
|
|
|
|
|
Secondary Databases