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 |
|
Kristen
Test
22859 Posts |
 Posted - 2005-04-26 : 01:34:36
|
| What to do ... cry?!A client has installed Small Business Server.They must have just pressed "Go"SQL had the default Data/Log locations [for new DBs] as C:\Program Files\...I changed the defaults for DATA/LOG to be somewhere useful on D:That leaves the Maintenance Wizard defaulting to C:, and the Master etc. DBs on C:Do I get them to reinstall, or can this mess be patched up effectively? (And if so what's the checklist ... I presume Move System DBs, twiddle some stuff in the Registry for Default locations ... Collation looks to be OK ... anything else?)Kristen |
|
|
JimL
SQL Slinging Yak Ranger
1537 Posts |
Posted - 2005-04-26 : 07:55:14
|
| I tried patching up one of ours after a Similar mistake.Not much luck I am afraid.I would recomend a reinstall.JimUsers <> Logic |
 |
|
|
scottpt
Posting Yak Master
186 Posts |
Posted - 2005-04-26 : 10:29:59
|
| http://support.microsoft.com/default.aspx?scid=kb;en-us;224071Just move the databases. |
|
|
|
|
|
|
Default installation too "default"