| Author |
Topic |
|
TRACEYSQL
Aged Yak Warrior
594 Posts |
 Posted - 2006-06-06 : 10:37:11
|
| We have one server and on EM for the properties...database settings we haveM:\MSSQL$SQL1\Data for data directory andO:\MSSQL$SQL1\Data for log directory.If i do new install of SQL where can i put the defaults to be Q: and R: these are our new paths.I only see one change for Data....Cheers |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2006-06-06 : 10:39:29
|
Go to Enterprise Manager, right click on SQL Server instance and choose property. Set it under Database Settings
KH |
 |
|
|
TRACEYSQL
Aged Yak Warrior
594 Posts |
Posted - 2006-06-06 : 11:33:07
|
| i see it there...but when doing new complete install you cannot set this..so i end up with Q for master mdf and ldf on Q but new databases will be Q and R if change the settings.So how do i get master ldf onto R and model and msdb and distribution |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2006-06-06 : 21:41:58
|
detach the database, move the data & log to the drive you want and attach it again.
KH |
|
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2006-06-06 : 23:38:54
|
| http://support.microsoft.com/kb/224071/en-usRead that article for moving databases.It's usually better to just install to the default location so all your error logs, etc get put in the proper place. You can then move everything with the above process. We do that even in 2005.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
TRACEYSQL
Aged Yak Warrior
594 Posts |
Posted - 2006-06-07 : 07:50:56
|
| Thanks.....on that thread Note If you are using this procedure while moving the msdb and model databases, the order of reattachment must be model first and then msdb. Follow these steps:Make sure that the SQL Server Agent is not currently running.How do you get into SQL Enterprise Manager if the SQL Server Agent is not running |
|
|
|
mr_mist
Grunnio
1870 Posts |
Posted - 2006-06-07 : 07:56:35
|
| The sql agent service is not the same thing as the sql server service. Though to be honest you probably wouldn't want to do that sort of thing in EM anyway. Doesn't it have to be in single user mode?-------Moo. :) |
|
|
|
CSK
Constraint Violating Yak Guru
489 Posts |
Posted - 2006-06-08 : 06:18:39
|
| use Detach and AttachThanksKK |
|
|
|
TRACEYSQL
Aged Yak Warrior
594 Posts |
Posted - 2006-06-08 : 08:24:34
|
| Thanks everyone |
|
|
|
|
SQL instllation